Problem: Locate on timestamp field

heuckeg · Post by **heuckeg** » Wed 28 Dec 2005 15:11

Hello,
I've a problem using TSmartQuery.Locate on a timestamp field.

I can set the timestamp field with correct date and time (as well formated string (dd.mm.yyyy hh:mm:ss)) with FieldByName(Fieldname).AsString.
But as soon as I use the same date string with the locate function, I get an error "cannot convert type".

I tried to set DateFormat in TOraSeesion.Option, but don't found any information what format chars are valid.
Also tried to set DateLanguage to "German", but got no success (same error message).

What I am doing wrong ?

Environment:
Delphi 7 on Win2k, ODAC 5.55.1.26

Thanks in advance,
Gunter

Challenger · Post by **Challenger** » Thu 29 Dec 2005 12:48

We couldn't reproduce your problem. Please send to ODAC support address complete sample to demonstrate it.