Hi, sorry, no I am not running a stored procedure. I am using the SQL Query option in the Database command. The query I am running is the code I pasted above. It does the insert fine if the record didn't already exist (which is what it is supposed to do). It also does the SELECT 0 fine if the record did already exist. But it wont do the SELECT 1 after doing an insert.
When it does do the SELECT 0 it returns the record properly... so it is able to return the dataset... just not after doing an insert.
|