Hi

I'm trying this SQL waht is using TSQLDataSet with Parameter. Example is
bellow.

UPDATE
T_KOUJI_P_GYOUSYA
SET
GYOUSYA_LIST_NO = :To_Num ,
UPDATEUSER = :UserName ,
LASTUPDATE = :LastUpdate
WHERE
GYOUSYA_LIST_NO = :From_Num 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
);


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

Regards,

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

> -----Original Message-----
> From: Hayashi@... [mailto:hayashi@...]
> Sent: Wednesday, February 26, 2003 5:10 PM
> To: ib-support@yahoogroups.com
> Subject: [ib-support] unassigned code
>
>
> Hi
>
> I get 'unassigned code' error from firebird with Delphi6 + dbXpress
> InterBase driver.
> This error happens when TSQLDataset.ExcecSQL method is execute with UPDATE
> SQL example bellow,
>
> UPDATE
> T_KOUJI_P_GYOUSYA
> SET
> GYOUSYA_LIST_NO = 1560 ,
> UPDATEUSER = 'tomneko' ,
> LASTUPDATE = '2003-02-25'
> 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
> );
>
> Using with IBPhenix ODBC driver or using with IBX dos'nt raise this error.
>
> Is this dbXpress driver Bug?
>
> best regards,
>
> >From Tsutomu Hayashi in Japan
> mail hayashi@...
> Web http://www.apex-jp.com/ (Japanese Only)
>
>
>
>
>
> 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/
>
>
>