Subject Re: [IBO] [Jason] Fail to prepare sentence in all my queries after update to IBO 4.9.14
Author hamacker
Well, before I used IB_Query.ExecSQL for insert/update/detete
or IB_Query.Execute for execute procedure...
I use TIB_Script only when I have two or more sentences separate by ";".

To new applications I can change that to a new method, but all current
applications is more fast use IB_Query.ExecuteDDL(m.sql.text) for

Just would like to know, if it�s a bug or not on this new version.

As you say, this new version change old ways.

Thanks a lot,


2011/9/1 Svein Erling Tysv�r <svein.erling.tysvaer@...>

> **
> >Before (IBO 4.6), I was create a query in this way :
> >
> > m:=TIB_Query.Create(Self);
> > m.IB_Connection:=SetFB.IB_Connection;
> > m.sql.clear;
> > m.sql.add('DELETE FROM CLIENTS');
> > m.sql.add('WHERE id_client='+IntToStr(nId)+';');
> >---> m.ExecSQL;
> what happens if you change the first line to:
> m:=TIB_DSQL.Create(Self);
> I've no idea whether using a TIB_Query should work or not, but I use
> TIB_Query when I need a bidirectional dataset, TIB_Cursor when a
> unidirectional dataset would suffice, TIB_DSQL when I want to execute
> something and sometimes TIB_Script when I want to execute many things.
> HTH,
> Set

[Non-text portions of this message have been removed]