> dm.Query.ParamByName('Separator').AsString := AObject;
> dm.Query.ParamByName('MeasDate').AsDateTime := StartDate;
> dm.st.Lines.Text := dm.Query.Text;
> dm.st.Edit;
>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....
I dont know if it's related but we've had no luck using .asdatetime parameters
with personal ORACLE 7.3... It's always treated as an invalid parameter and
the best solution we've found is to pass as string formatted american
mm/dd/yyyy. Thankfully the majority of date related material for us is server-side
in our date-specific interaction and for feedback purposes the date field is selected
but does not appear in a where clause - you do not appear to be so lucky.
If anyone knows what you have to fiddle to get oracle to accept dates passed as
parameters in procedures and queries please speak up... Note the failure was traced
through to the parameter binding stage at the oracle interface where ORACLE
reports that the parameter is the incorrect type.
--
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
