> I'm always design client-server applications with rich GUI in this way.
> Users even have no grants to SELECT from any table. Applications calls
> only SPs.
>

So how do you know what field a person has updated, then what to do to update the database back again.

for example

SELECT FIELD1...FIELD200
FROM PROC_PRODUCT( :THEPRODUCT )

User changes FIELD121.

How do you then move this data back to the database. without updating all fields that were received to start with.

Kind Regards,

Robert.