Hi Cor, > The extension fastNAW does send a SQL command to the relevant datasource. > Now it would be fine if selecting data from the datasource, could be > case insensitive. > > However, since the connected datasource can be either one of the > following three: > - internal HSQLDB > - connected flat file databases > - database x with its own ODBC/JDBC driver ... > that causes me some problems.
As far as I know, there is no portable way to tell a database to return upper/lower-cased strings, so you will need to do this on your own after retrieving the data. Ciao Frank -- - Frank Schönheit, Software Engineer [email protected] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
