Hi Svein

Thanks for your proposal.

Cast() function is useful but I want to treat datetime data type.

for now, dbXpress + Parameter + Datetime solution is AsString +
FormatDateTime().

regards,

From Tsutomu Hayashi in Japan
Mail hayashi@...
Web http://www.apex-jp.com/ (Japanese Only)

> -----Original Message-----
> From: Svein Erling Tysvaer
> [mailto:svein.erling.tysvaer@...]
> Sent: Wednesday, February 26, 2003 6:33 PM
> To: ib-support@yahoogroups.com
> Subject: RE: [ib-support] unassigned code
>
>
> Sorry, I don't know. Maybe dbXpress doesn't handle all types of
> date format
> (I only use IBO with Firebird myself, so others will have to help
> you out).
> I guess you could try changing the ShortDateFormat or something to see if
> this helps. But your particular question can be solved another
> way that is
> relevant for this list:
>
> UPDATE
> T_KOUJI_P_GYOUSYA
> SET
> GYOUSYA_LIST_NO = 1560 ,
> UPDATEUSER = 'tomneko' ,
> LASTUPDATE = cast('NOW' as Date)
> WHERE
> GYOUSYA_LIST_NO = 1591 AND
> KOUJI_P_NO IN (SELECT
> KP.KOUJI_P_NO
> FROM
> T_KOUJI_PRIVATE KP
> WHERE
> KP.BUKKEN_NO = 55 AND
> KP.TENKEN_CODE = 3
> );
>
> HTH,
> Set
>
> At 17:50 26.02.2003 +0900, you wrote:
> >I realize this problem is caused by using parameter for datetime
> field like
> >Params[3].AsDateTime := Now();.
> >
> >Am I wrong? Using AsDateTime is wrong?
> >
> >Sorry, this is not suitable this ML
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>