Ronan,

At 01:45 AM 11/01/2004 +0100, you wrote:

>Hello,
>
>Using TIB_DSQL.
>
> >>2) -When I have Delphi perform an INSERT, the record is not being
>committed.
> >>When querying the table, with IB Expert I see the record has been added.
>
> >It does get committed; but you are observing the effect of not setting up
> >your KeyLinks. If IBO doesn't know the key, it can't synchronise. After
> >the Commit you would have to close and open the whole dataset to see the
> >new row.
> >
> >Helen
>
>I have since added the correct PK to my table, but where can I set TIB_DSQL
>keysautodefine and keylinks?

You can't, and wouldn't need to, since TIB_DQSL is not a dataset
component. I've probably responded to your question out of context, for
which I apologise.

You *can* assign keylinks to an ib_cursor, if they are needed. But I'm not
sure it's relevant to the problem you describe...

The output fields in a selectable SP don't exist in the database. They are
"cooked" at the time the SP executes. There is no way to update the client
view after a DML operation except by cooking them again when the database
image changes.

If this doesn't direct you to a solution to your problem, could you state
the actual problem again?

Helen

>Kind regards,
>Ronan van Riet
>
>___________________________________________________________________________
>IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
>___________________________________________________________________________
>http://www.ibobjects.com - your IBO community resource for Tech Info papers,
>keyword-searchable FAQ, community code contributions and more !
>
>Yahoo! Groups Links
>
>To visit your group on the web, go to:
> http://groups.yahoo.com/group/IBObjects/
>
>To unsubscribe from this group, send an email to:
> IBObjects-unsubscribe@yahoogroups.com
>
>Your use of Yahoo! Groups is subject to:
> http://docs.yahoo.com/info/terms/