Hi.

I'm using :
P4 2.4GHz, 1 GB Ram, Windows 2003 server enterprise FR, Firebird 1.03
IbExpert Trial Version (2003 11 06)

Using the sql editor, the statement :

select current_timestamp as TheTimeStamp from rdb$database;

yielded the following result :

14/12/2003 16:53:03

Using Delphi 7 enterprise and IBO 4.2Hd, I dropped a TIB_Dsql
component, at design time, assigned a value to the IB_connection and
ib_transaction
as instructed by Helen, and everything worked fine when attached to the
on_click event of a button :

with ib_DSQL1 do
begin
with sql do
begin
clear ;
add('select current_timestamp as TheTimeStamp from rdb$database');
end; // with
if not prepared then prepare ;
execute ;
showMessage( formatdatetime( 'hh:mm:ss dd-mm-yyyy',
Fields[0].AsDateTime ));
end; // with

Hth,

J.

----- Original Message -----
From: "Kadee" <bigred17201720@...>
To: <IBObjects@yahoogroups.com>
Sent: Sunday, December 14, 2003 11:13 AM
Subject: Re: [IBO] EIBO_ISCError - ISC ERROR CODE:335544569 ?


> 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
>
>
>
>
___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
> without the need for BDE, ODBC or any other layer.
>
___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>