Subject | InsertSQL |
---|---|
Author | SwS |
Post date | 2001-02-07T13:56:50Z |
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
[Non-text portions of this message have been removed]
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
[Non-text portions of this message have been removed]