Hello, On Donnerstag, 20. M�rz 2003 20:03, Andris Spruds wrote:
Yes, it's not very well documented, but SAPDB internaly converts all table names to uppercase. So, instead of 'person', use 'PERSON'
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?
Regards
Elias
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
