On Feb 12, 2007, at 4:24 PM, Carlos M wrote:
Nice approach Norman.
Just a question as I don't use regularly substrings and
concanetations. Aren't
these operations (using substrings and concanetations) on a UPDATE
slower than
gettings all records and update them?
Carlos
This does the entire update IN the SQLite engine instead of grabbing
the record set and going through each record issuing an update
It should actually be quicker as less data gets moved about
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>
