Set PreparedEdits to false and you will get a customized UPDATE SQL each time depending on what has changed.

Jason Wharton

--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
Thanks Helen!

So on my BeforeOpen on the TIB_Query I checked for the Role and set the
correct EditSQL, which also makes the non-updatable fields read only in
the GUI - so perfect.

But I'm getting a bit greedy ;-)

As far as I can see Jason hasn't implemented a feature that queries
RDB$USER_PRIVILEGES for a specific table rights and sets its EditSQL.
Using a bit of bandwidth.

..well I guess I need to do some coding myself... :-(

Kind regards
Steffen Nyeland

Group IT Business Development & Integration
Hempel's Marine Paints A/S
Lundtoftevej 150, DK-2800 Kgs. Lyngby, Denmark
Phone : (+45) 4527 3427 (Direct) Fax : (+45) 4588 5518




Helen Borrie <helebor@...>
07-04-2004 11:21
Please respond to IBObjects


To: IBObjects@yahoogroups.com
cc:
Subject: Re: [IBO] Update only of "Changed" fields...


At 09:11 AM 7/04/2004 +0000, you wrote:

>Hi,
>
>I wanted to move all the "rights"-management in my app to the
>database.
>
>The problem is that I for one SQL ROLE have only granted rights to
>update
>FIELD3 and FIELD5, but since the update statement sent to the
>server looks like this:
>
>UPDATE MYTABLE
>SET FIELD1 = ? /*FIELD1*/
>,FIELD2 = ? /*FIELD2*/
>,FIELD3 = ? /*FIELD3*/
>,FIELD4 = ? /*FIELD4*/
>,FIELD5 = ? /*FIELD5*/
>,FIELD6 = ? /*FIELD6*/
>WHERE MYTABLE.FIELD1 = ? /*OLD.FIELD1*/
>
>I would have hoped that there was some way that it could look like
>this:
>
>UPDATE MYTABLE
>SET FIELD3 = ? /*FIELD1*/
>,FIELD5 = ? /*FIELD2*/
>WHERE MYTABLE.FIELD1 = ? /*OLD.FIELD1*/
>
>I was wishing for a update changed fields only or atleast update non-
>key
>fields only property type of thing.
>
>Any ideas anyone, or must I keep the rights to the TABLE-level, and
>the
>implement the Field stuff on the GUI?

Just use custom EditSQL on the dataset that you show to that role.

Helen