> yes, thanks, found that also in the FAQ list (I forgot about the
> existance of that list, sorry). However, the Prepared property of
> the TIBO_StoredProc was set to true at designtime, so I guessed that
> this meant that the storedproc was prepared.

There is a property on the TIB_SessionProps component (which you can
drop on the form if you want to control the various TIB_Session
aspects) called StoreActive. If you enable this then the application
will save the Prepared and Active properties of the datasets. However
this generally causes more problems than it solves, because you
generally want to only prepare/open datasets as appropriate in your
application.

> Also why do we've to prepare before we give the parameter values and
> not after it?

Prepare sends the SQL statement to the server, which parses and
validates the statement and returns information to IBO describing the
properties of each field and parameter.

After the statement is prepared IBO can then tell what data type fits
each column as well as various other attributes.


hth

--
Geoff Worboys
Telesis Computing