Problem: Locate on timestamp field
Posted: 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
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