21 Jan
2003
21 Jan
'03
10:28 p.m.
andreas rippel wrote at 2003-1-21 10:26 +0100:
I'm looking for the SQL grammar, which is allowed/supported by ZSQL. Z SQL Methods do not restrict the SQL statements that can be generated.
There is just one condition. The database engine must understand it.
E.g. the point is, how does ZSQL support sql-transaction expressions. E.g. "select NOW()" is a legal expression for MySQL, but causes a parse-error in ZSQL. There seems to be a "standard" inclusion of a limit clause within ZSQL for security and/or overflow reasons. Does anybody know the grammar? Usually, the limit addition is disabled, when you put "0" in the field "Maximum rows to retrieve" ("Advanced" tab of Z SQL methods).
Dieter