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
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>
