> What happens if you use a string (e.g. '25-FEB-2005') instead of

the field

> name(?) "25-Feb-2005" ? (Depends on Dialect, I believe).

same exception. Here's my Delphi code that creates the SQL:

lIBQ.SQL.Text :=
'Select Log_ID, CodeGiven From ClientLog ' +
' where Client_ID = ' + IntToStr(aClientId) +
' and MachineID = ' + IntToSTr(lMachID) +
' and Expires_DateTime = ''' +
FormatDateTime('dd-mmm-yyyy', aExpireDate) + '''';

It seems that it has something to do with the particular values I am
using as I can change them and they work just fine.

Ed Dressel