Hello, On Freitag, 21. M�rz 2003 14:58, Elias Martenson wrote: > > [...] > > > > This does not need to be documented, as it is standard sql behaviour. > > When you want a table name to be in lowercase, you have to use double > > quotes during creation and ever after when you want to refer to it. > > For some reason Microsoft consider themselves above this standard. They > feel that square brackets are a better way to go. Are they really ANSI > SQL compliant? > > And does Sybase the same thing? They also support the user of double > quotes for quoting strings as an alternative to single quotes? > > How about a comaptibility mode in SapDB to support MS (and Sybase?) syntax? > As the jet engine accepts standard sql (within the limits of it's capabilities) there is perhaps no need for other systems to accept the jet engine's crooked style. As there are other incompatibilities (e.g. case insensivity, wrong implementation of between()), you still have to rewrite your 'jet' statements to use a real database. (And, you can be sure that there always comes a new incompatibility with any later version of the jet engine)
Peter Willadt _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
