I've had similar problems with Date and DateTime parameters so now I use TimeStamp instead.
ParamByName('DT').AsSQLTimeStamp :=
DateTimeToSQLTimeStamp(Trunc(EffluentRec.DT));
should work.
Cheers,
Carl
_______________________________________________
Delphi mailing list
Delphi@ns3.123.co.nz
http://ns3.123.co.nz/mailman/listinfo/delphi
