Is there a way to do a conditional insert in the compact edition? I've tried two ways that I think would work on SqlServer:
INSERT INTO CUSTQUOTE (QTE_ID) VALUES (1)
WHERE EXISTS(SELECT * FROM JOB WHERE JOB_NUMBER = 'EW090800345')
There was an error parsing the query. [ Token line number = 2,Token line offset = 1,Token in error = WHERE ]
IF EXISTS(SELECT * FROM JOB WHERE JOB_NUMBER = 'EW090800345')
BEGIN
INSERT INTO CUSTQUOTE (QTE_ID) VALUES (1)
END
There was an error parsing the query. [ Token line number = 1,Token line offset = 1,Token in error = IF ]