[thelist] SQL Update CORRECTION

Jason Robbins evolt at whisky-fudge.org.uk
Sun Jul 4 18:53:09 CDT 2004


Ken Moore wrote:
>> There is one exception, that is if you have two functions (for 
>> example, "scatter_tablename" and "gather_tablename") where one line 
>> loads all fields into variables and the other saves all variables into 
>> the table. Even then, in your calling procs, only update the data that 
>> has changed.
The only trouble with that is it means writing ever different 
possibility as a stored procedure - unless someone knows a trick to 
solve this problem?

Jas


More information about the thelist mailing list