>The reason I ask is that for somereason the queries are now failing and not
>returning any data, this is as far as I can tell, due to wrong date formats
>being put in the SQL, however, I'm assigning the parameter via .AsDateTime
>which I would have thought would work around those date inconsistancy
>problems....
>
>Any thoughts/ideas/suggestions or darn it - out-right solutions?
>
I understand that you are not recieving any data because the Date format is
incorrect. We had similar problems with querying our Oracle Database. And
had to Use FormatDateTime('dd-mm-yyyy',Date).
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
