Subject Re: [IBO] EIBO_ISCError - ISC ERROR CODE:335544569 ?
Author Helen Borrie
At 03:56 AM 14/12/2003 +0000, you wrote:
>Dear sir,
>
>I user ibo 4.3a ibodataset
>connect to firebird 1.0798
>
>in the begining my app will connect to the server
>and get the server time,
>sql :
>select current_timestamp from rdb$database
>
>the app run fine under win2k and win98.
>but when the app run under winxp,
>the error appear:
>
>
>EIBO_ISCError - ISC ERROR CODE:335544569
>
>ISC ERROR MESSAGE:
>Dynamic SQL Error
>SQL error code = -206
>Column unknown
>CURRENT_TIMESTAMP
>At line 2, column 8.
>
>STATEMENT:
>TIBOInternalDataset: "<TApplication>.FMain.qNow.IBOqrqNow."
>
>dose I do something wrong?

select current_timestamp as TheTimeStamp from rdb$database;

Alternatively (and much better) use a TIB_DSQL, not an IBOQuery, call "if
not Prepared then Prepare", then call Execute, and read
Fields[0].AsDateTime to get the result back to your function.

Helen