Subject | IB_Parse.pas - ROWS not recognized as SQL token |
---|---|
Author | Thomas Steinmaurer |
Post date | 2010-04-14T08:11:25Z |
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/
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/