$createnames strange DAM bug

Alain Stouder Omnis omnis at smartway.ch
Tue Dec 20 02:41:34 EST 2016

Hi Vik,

As I'm not an experienced MS SQL user I cannot help but you should check the MS SQL reserved words because they have more words than other vendors (but I digress here...).

Learn something new every day!

> On 20 Dec 2016, at 06:59, Vik Shah <Vik at Keys2Solutions.com.au> wrote:
> Hi Listers,
> Here is a pickle to pick on while we are all on our deserving breaks. :-)
> The backend is MS SQL server 2008 R2 and the client is Studio 4.3.2.x (running on windows). As a part of the installation process we create the entire database and the tables and all the assortments that go with it. 
> With the recent build of the library when creating the database it fails at ONE table only. The $createnames method returns the column name and NULL. 
> e.g. (normally) ma_id varchar(16), ma_name varchar(250) ...
> But we get, (bug), ma_id NULL, ma_name NULL, ...
> We opened up the schema class and it looks like all the other schema classes we have, similarly we checked our table class, its the same as all the others.
> We deleted the schema and table classes and recreated them, still the same...?!?
> Has anyone here ever seen anything like this. Is this library corruption? Is this a DAM bug?
> NOTE: if we run the same creation process on PostgreSQL server, all goes well !?!
> Help!
> Vik Shah
> Director
> Keys2Solutions
> AU: +61 411 493 495
> SE: +46 21-495 01 05
> US: +1 (415) 413 4172
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com

More information about the omnisdev-en mailing list