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
insert/update/delete.

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,

H.

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]