Subject | updating views |
---|---|
Author | Walter Neumann |
Post date | 2002-11-17T17:43:28Z |
Hi,
For a view with 2 tables I wrote 3 triggers for delte, insert and update.
Creating this triggers, I don't recieve an error message. But in IBAccess I
still can't insert, update or delete rows in this view. With dbExpress from
Kylix I could insert a row, but the following select failed:
SELECT * FROM KLIENTENVIEW
WHERE NN STARTING WITH 'N' AND BETREUT = 'J';
with the error "invalid data packeg".
It seems, that the view is still considered as read only.
How can I solve this problem?
Thanks.
Walter Neumann
For a view with 2 tables I wrote 3 triggers for delte, insert and update.
Creating this triggers, I don't recieve an error message. But in IBAccess I
still can't insert, update or delete rows in this view. With dbExpress from
Kylix I could insert a row, but the following select failed:
SELECT * FROM KLIENTENVIEW
WHERE NN STARTING WITH 'N' AND BETREUT = 'J';
with the error "invalid data packeg".
It seems, that the view is still considered as read only.
How can I solve this problem?
Thanks.
Walter Neumann