Page 1 of 1

List of sql keywords incomplete for firebird sql

Posted: 11.01.2011, 15:54
by duzenko
There are some keywords missing in TZInterbase6DatabaseInfo.GetSQLKeywords, such as DATE, TIME, MIN, MAX, USER

Posted: 13.01.2011, 22:29
by mdaems
such as DATE, TIME, MIN, MAX
Can you provide a complete list of missing keywords?
Attention: there's also a list of

Code: Select all

  AnsiSQLKeywords = 'insert,update,delete,select,drop,create,from,set,values,'
    + 'where,order,group,by,having,into,as,table,index,primary,key,on,is,null,'
    + 'char,varchar,integer,number,alter,column';
in ZDbcMetadata where the GetSQLKeywords are used.

Mark

Posted: 17.01.2011, 12:49
by duzenko
I don't have the full list - this four are used in my program as field names, so I suggest to add only them

I am aware of the default ansi keywords function, thanks anyway

Posted: 26.01.2011, 22:56
by mdaems
Done. Svn rev. 876.

Posted: 31.05.2011, 13:26
by duzenko
Also, please add "VALUE" as a keyword

Posted: 30.10.2011, 22:07
by mdaems
Added it as a AnsiSQL keyword. (SVN rev 954)

Mark