this SQL Query seems to work on SQL2000 but can not get it to work on SQLCE?

  • Thread starter Thread starter jayderk
  • Start date Start date
J

jayderk

I put this in the query analyzer and can not get it to work.

IF NOT EXISTS (SELECT customer_id FROM customer WHERE customer_id =
'testid') INSERT INTO customer(customer_id,event_id) VALUES('testid','TEST
EVENT')


NOTE: the insert statement works great on its own..

regards,
Jay
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

question about how to handle if row exists 1
Query works, query based on it fails. 2
Append query works, but doesn't... 2
SqlCe Insert / Replace NText Problem 0
Sql query not working 6
Possible corruption? Listbox based on query not populating, yet works manually 1
SQLCE performance from .NET CF v2.0 8
Exception with SQLCe on Emulator 4

Back
Top