Helen Borrie wrote:

>
> At 05:21 PM 30/09/2007, you wrote:
>
> > > >After one thread fetches data from the select, can't the other
> > > >thread use it?
> > >
> > > No.
> >
> >Thanks again Helen.
> >
> > I think I'm not being clear. Or I'm confused. "it" means
> >the data from the select, not the connection.
>
> You're confused apparently because you think "the data from the
> select" has nothing to do with the connection.

I think you're both misunderstanding each other, but I may be wrong.

If I'm not completely misundestanding things, this is how it is:

1. Each thread has to use its own connection(s) and any datasets/cursors
that are opened withint a certain thread via one of that thread's
connections can be accessed by that thread only.

2. If that thread extracts data from the datatset and writes it into any
kind of application specific data structure, that has nothing to do with
Firebird, that extracted data can be accessed by any thread, at least if
those data structures are made thread safe.

Please correct me if I'm wrong.

Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64