On 2/14/07, Norman Palardy <[EMAIL PROTECTED]> wrote:
On Feb 14, 2007, at 11:19 PM, Norman Palardy wrote: >> If it makes any difference, I'm using the REALSQLDatabase for this. > > Or you can use REPLACE INTO which will do an update if it already > exists or add it if not IF you use raw SQL you can do INSERT OR REPLACE INTO table .... OR INSERT OR IGNORE INTO table .... The first will do an update or insert The second will insert only it its new Either way the engine will have to look it up just like you would BUT this lets the engine handle it instead of you having to explicitly handle it
Thanks much for the help with this. It turns out I realized overnight that I need to clear the table and start from scratch with a fresh list because users could uncheck items to take them out of the list as well. I haven't had my coffee yet this morning, so this could all change again. But either way I can see some potential for using these functions in other ways. _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives: <http://support.realsoftware.com/listarchives/lists.html>
