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