The conflict algorithms in SQLite are brilliant. It's exactly what I've needed, and after working with SQLite for so long, I had forgotten that it wasn't part of the SQL standard (as far as I know--but it should be!!!)
For those of you using MS SQL or Oracle, is there any way to get the same result without first selecting and then doing an insert/update depending on what I find? (ie I want to put a value into a table. If it's there fine, and if not, just add it). I know I should ask this in a MS SQL forum, but I figure you folks are quite familiar with the end goal (which is to make MS SQL behave like SQLite). Thanks for any ideas. Doug ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
