Subject IB_Parse.pas - ROWS not recognized as SQL token
Author Thomas Steinmaurer
Hello,

I'm on 4.8.7.

ROWS is not recognized as SQL token when using IB_Parse.mkVarIdent. This
function calls another function isSQLQuoteToken, which I think
implements some kind of binary search in the SQLTokens array. Right?

If so, the sequence of the array items matters. In respect to ROWS,
there is:

...
'ROLLBACK',
'ROW_COUNT', // fb1.5
'ROWS', // fb2.0, ib6.5
'RUNTIME',
...


which does not recognize ROWS as keyword. If I make it that way:

...
'ROLLBACK',
'ROWS', // fb2.0, ib6.5
'ROW_COUNT', // fb1.5
'RUNTIME',
...


ROWS is detected as SQL token properly.


Comments?


I see, there are some SQL tokens missing in respect to newly added
reserved words in newer Firebird and InterBase versions. Have they been
updated in more recent IBO versions?



--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/