Hello,
In my HTML page I have a table of 12 rows and 5 columns (60 cells). Users
can modify values in any number of cells and submit changes by clicking a
button. In button's onWebEvent() I loop thru each row and setValue() to
CSpUpdate object and than execute() it.
This works fine but I am not sure that this is the most efficient way to
perform an UPDATE.
I think that ND executes UPDATE statement 60 times regardless of the number
of rows changed by the users. Is there a way to prevent this from happening
? I know that I can do something like this:
1) from CSpSelect dataobject driving my repeated, read values than store
them in CSpVector, row by row.
2) getDisplayFieldValues(), again row by row, storing values in CSpVector.
3) Compare CSpValues stored in the corresponding positions of both vectors
and if they are different (modified by the user), do setValue() in my
CSpUpdate object and execute() it.
This doesn't seem to be very efficient either. Can anyone think of a better
solution ?
Does CSpMultiSQL know what data was changed and what wasn't and generate the
appropriate SQL ?
Thanks for your help.
Alex
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
