Malformed GUID in Query expression

[Mario]

Hi,

Using the SQL builder of the Data Envirnment, I generated the following
query:

SELECT `Date`, Close
FROM Prices
WHERE (`Date` > { d '1999-01-07' })

However, when I run (test) it in the data environment then I get the
following error:

Malformed GUID in query expression (`Date` > { d '1999-01-07' })

Whats causing the problem? may be the generated syntax is not correct?

Thanks in advance.
Mario

[Jens Neuhalfen]

If you find the answer, please let me know!!!!!
If you use Jet as provider (Access, even with ADO)
use Where Date > #12/31/1999#

jens
PS:
> SELECT `Date`, Close
^-- why the `'s ???

[Carlos J. Quintero]

The problem is that the native OLEDB Jet Provider doesn´t support ODBC
syntax like { d 'yyyy-mm-dd'}.

Solutions:

- Use OLEDB Provider for ODBC + ODBC Access driver

or

- Use native syntax for dates in Access #....#

Regards,

Carlos J. Quintero
Madrid (Spain)

car...@cat.es

Jens Neuhalfen escribió en mensaje <37A997DF...@akkaya.de>...