Dear Helen,

Thanks a lot for your quick reply.

I replace the tibodatase with tib_Dsql,and
in WINXP HOME edition get same error.
my delphi work in Win2000.
(in win2000 it work fine as usual)

EIB_ISCError - ISC ERROR CODE:335544569

ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -206
Column unknown
CURRENT_TIMESTAMP
At line 1, column 8.

Best Regard,

Kadee

--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
> 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