On Sep 02, 2006, at 10:10 PM, Charles Yeomans wrote:
On Sep 2, 2006, at 11:23 PM, Dr Gerard Hammond wrote:
At 7:37 PM -0600 2/9/06, Norman Palardy wrote:
On Sep 02, 2006, at 7:00 PM, Charles Yeomans wrote:
Does the version of SQLite used in Rb 2006 r3 support the SQL
keyword EXISTS?
I'm certain it does
for eg...
drop table if exists UserGroup;
Hmmm. Is there some something like
INSERT INTO Table1 (1, 'foo') IF NOT EXISTS (SELECT * FROM Table1
WHERE Table1.keyField=1)
available?
Not that I know of
You can probably restructure it as a select
INSERT INTO Table1 (SELECT 1,'foo' FROM Table1 WHERE not exists
( select * from tbale1 where Table1.keyField=1) )
You may need to insert column names in the inset into clause
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
