gastrocus wrote: > INSERT INTO T1 (type, name, sysid, flag) values (1, 'ZZZZZ', 1, 0) > WHERE NOT EXISTS (SELECT 1 FROM T1 WHERE name = 'ZZZZZ')
You can apply select to rdb$database table which always returns one row: INSERT INTO T1 (type, name, sysid, flag) SELECT 1, 'ZZZZZ', 1, 0 FROM RDB$DATABASE WHERE NOT EXISTS (SELECT 1 FROM T1 WHERE name = 'ZZZZZ'); HTH -- Milan Babuskov ================================== The easiest way to import XML, CSV and textual files into Firebird: http://www.guacosoft.com/xmlwizard ==================================
