Hi Jörg, Ocke,
>>@Frank, Ocke: Can I influence somehow, how date literals are added to
>>queries created in the design view ?
>
> I'm sorry to say but it is at the moment not possible to turn this
> feature off.
> ....
> There the parse nodes for the {D...} will be created. I don't know how
> other databases react when we change this code to create SQL 2003
> conform expression. The {D...} format comes from the ODBC standard.
We could probably introduce yet another per-data-source option, called
"Use ODBC-conformant dates in SQL expressions", default switched ON,
which controls this. Couldn't we?
Ciao
Frank
--
- Frank Schönheit, Software Engineer [EMAIL PROTECTED] -
- Sun Microsystems http://www.sun.com/staroffice -
- OpenOffice.org Database http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
