> -----Original Message-----
> From: Holger Schurig [mailto:[EMAIL PROTECTED]]
> Sent: Donnerstag, 14. M�rz 2002 11:40
> But still then demo app "sqltable" did not work, it said
>
> QSqlCursor::setName: unable to build record, does
> 'simpletable' exist?
>
> and that is not nice. :-)
>
> So I change the source code for "sqltable" from
>
> SimpleCursor () : QSqlCursor( "simpletable") {}
>
> to
>
> SimpleCursor () : QSqlCursor( "SIMPLETABLE") {}
>
> and, voila, it worked.
>
>
>
>
> So, I'd suggest that some code in libsqlod.so does an automatic
> uppercasing of table names. After all, SAP DB runs in caps-lock mode,
> doesn't it?
>
Hello Holger,
SAPDB uppercases all identifier which are not enclosed in double quotes.
The ODBC driver returns this information by calling SQLGetInfo with
SQL_IDENTIFIER_QUOTE_CHAR and SQL_QUOTED_IDENTIFIER_CASE.
If you double quote the table/column names during the create table statement
the
table/column names are case sensitive.
Regards
Burkhard
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
