| Subject | Why won't this work in Firebird? |
|---|---|
| Author | Myles Wakeham |
| Post date | 2005-02-22T06:42:06Z |
INSERT INTO CUSTOMER_TYPE (CUST_TYPE_COMPANY_ID, CUST_TYPE_DESC) values
(1,'General') where not exists(SELECT CUST_TYPE_DESC from CUSTOMER_TYPE
where CUST_TYPE_DESC = 'General');
Any ideas?
Myles
===========================
Myles Wakeham
Director of Engineering
Tech Solutions Inc.
Scottsdale, Arizona USA
Phone (480) 451-7440
Web: www.techsol.org
(1,'General') where not exists(SELECT CUST_TYPE_DESC from CUSTOMER_TYPE
where CUST_TYPE_DESC = 'General');
Any ideas?
Myles
===========================
Myles Wakeham
Director of Engineering
Tech Solutions Inc.
Scottsdale, Arizona USA
Phone (480) 451-7440
Web: www.techsol.org