Subject Problem With IB_Query
Author Ahmet Elgin
Hello all.

I have a problem with IB_Query. A user have only select privilege to a
table. I use IB_Query's generate for table function and it creates a
statement like this:
UPDATE table SET
CODE = :CODE, /*PK*/
DESC = :DESC
WHERE
CODE = :OLD_CODE

INSERT INTO table(
CODE, /*PK*/
DESC)
VALUES (
:CODE,
:DESC)

DELETE FROM table
WHERE
CODE = :OLD_CODE

everthing ok, but when a user with only select privilege opens the form,
an error occurs " no permission for update/write access to table". User
is not trying to update records just selecting.

If I set SQL statement "select * from table for update" and don't set
any EditSQL, UpdateSQL or DeleteSQL no problem occurs. and user can see
the records. Why this happens? do I have to do someting special?

Thanks for your help...

Ahmet ELGIN