.


i tested and nothing, continues error.

I did:

Assign a connection to the TIB_Cursor (again, for sure!)

Add a SELECT to the TIB_Cursor
Open
close

Add a executable procedure to a TIB_DSQL
Execute

Assign a connection to the TIB_Cursor (again too, for more sure!)

Add another SELECT to the TIB_Cursor
Ope..<crash>


.
--- In IBObjects@yahoogroups.com, "Filipe Belchior"
<filipe.belchior@m...> wrote:

> .
>
>
> exactly, i doing it. And ...hehehe, nothing, no motive,
> "I did for to do", but thanks, i´ll try.
>
>
> .
> --- In IBObjects@yahoogroups.com, Svein Erling Tysvær
> <svein.erling.tysvaer@k...> wrote:
> > So you have one TIB_Query that you are using like this:
> >
> > Add a SELECT to the TIB_Query
> > Open
> > Close
> > SQL.Clear
> >
> > Add a executable procedure to the TIB_Query
> > Execute
> > SQL.Clear
> >
> > Add another SELECT to the TIB_Query
> > Ope..<crash>
> >
> > Myself, I never use a TIB_Query for an executable procedure and

do

> not
> > know whether this should work or not. If I should guess, I think

I

> > would have used one TIB_Cursor for your first select statement, a
> > TIB_DSQL for your executable procedure and either a TIB_Cursor or

a

> > TIB_Query for your last statement. Why is it that you only want

to

> use
> > one TIB_Query to do all the work rather than use three separate
> > components?
> >
> > Set
> >
> > --- In IBObjects@yahoogroups.com, "Filipe Belchior" wrote:
> > > Jason, i thinked that too, but...
> > >
> > > as i said, the "2 first statements" are executing correctly.

Just

> > > the last statement not executes, and
> > > i´m not change the "transaction connection assign".
> > >
> > > I´ll verify the transaction component too, thanks.
> > >
> > > > I am using a TIB_Query to various statements.
> > > >
> > > > In a procedure, i execute 3 statements with the TIB_Query.
> > > >
> > > > the first, a query statement, the second, a execute procedure
> > > > statement and, the last, a query statement too.
> > > >
> > > > all SQL statements are corrects, i tested in a DB adminitrator
> > > > system. but, in the last statement, when execute

IB_Query.Open,

> > > > occurs "transacton has no connections" exception, only in the
> > > > last statement.