Locate by date

[kend]

I'm in the process of converting from Access using dbGo to MySQL using Zeos. These lines:

if locate('Date', datetostr(date), []) then
Edit
else
Append;

worked with Access to edit a record if it exists with todays date or add a record if not but it doesn't work with MySQL. Could someone let me know what might be wrong? I assume it's a date format problem or some such?

Many thanks,

Ken

[seawolf]

If i type

Query.Locate('c_date_came',EncodeDateTime(2002,12,19,14,0,0,0),[])

It works to me

[kend]

You're a gentleman and a scholar, works perferctly.