>Sorry, read my email in the wrong order. Didn't realize that TDateTime
>wasn't working for you. Ignore my last submission. What wasn't working
>about
>TDateTime?
>To answer your first question below, I think it's the Win95 date settings,
>but don't quote me. :)
1. Either the numerical format of Tdatetime and the database numerical
representation of a date differ.
or
2. the Parameter type set by .AsDateTime (ftDATE,ftTIME,ft??) differs from the
type of the column the parameter is being applied to Parameter Binding fails.
I suspect it's 2 personally... but don't quote me on that... ;)
NOTE: we had exactly the same problem in ORACLE 7.3 (Personal addition)
Solution use formatted (mm-dd-yyyy) date-strings imbedded in the SQL (no
good for preprepared iterative calls from a query but we were lucky and this
didn't matter to us).
--
Aaron Scott-Boddendijk
Jump Productions
(07) 838-3371 Voice
(07) 838-3372 Fax
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
