Make sure you know the values of the columns in the KeyLinks property prior
to posting the insert.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "SwS" <apatri@...>
To: <ibobjects@yahoogroups.com>
Sent: Wednesday, February 07, 2001 6:56 AM
Subject: [IBO] InsertSQL


> Hi all.
>
> I am learnig to alter the views.
>
> Actually I can edit and delete records from a view without problems.
>
> But if I try to add a record, using InsertSQL I MUST refresh the
TIB_SQLQuery, doing so i left the hook to the actual record.
>
> I bypass this putting a TIB_DSQL with the following SQL:
>
> SELECT MAX(MYCODE) FROM ATABLE.
>
> MYCODE is the Primary key.
>
> ATable is the one on which is based the view.
>
> Performing a Locate I solve.
>
> List: There is a " IBO WAY " to do this???
>
> Thanks.
>
> Tony
>