>
>every runs ok... (well, the datas crap cause its using wrong data).
>
>but if I use:
>
>where
> S.Vessel = C.Object AND
> S.Separator = :Separator AND
> C.MeasDate = :MeasDate
>
>with the code:
>etc etc
I avoided using parameters - would that help?
DateValue := FormatDateTime('dd-mm-yyyy',Date);
SQL.Add('Select from ........
SQL.Add('Where Trunc(C.MeasDate) = ');
SQL.Add('TO_DATE(' ' '+DateValue+' ' ', ' 'dd-mm-yyyy')')
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
