| Subject | Re: [firebird-support] Re: Firebird Stored Procedures to select to update from delphi application forms |
|---|---|
| Author | Vlad Khorsun |
| Post date | 2009-11-24T21:07:13Z |
>> I'm always design client-server applications with rich GUI in this way.I pass all the record fields back to the updating procedure and see nothing bad here.
>> 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.
Regards,
Vlad