List of sql keywords incomplete for firebird sql

[duzenko]

There are some keywords missing in TZInterbase6DatabaseInfo.GetSQLKeywords, such as DATE, TIME, MIN, MAX, USER

[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

[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

[mdaems]

Done. Svn rev. 876.

[duzenko]

Also, please add "VALUE" as a keyword

[mdaems]

Added it as a AnsiSQL keyword. (SVN rev 954)

Mark