Quote:
|
Originally Posted by streaker69
I may be wrong, but how does one do a WHERE on a Record that doesn't exist?
If you're inserting it, then you're creating the record, you can do a WHERE in the UPDATE, but I've never see one on a INSERT.
I could be wrong, never claimed to know everything about SQL.
|
I was thinking something else, basically a insert/select all in one using not Exist
Normally you'd open a connection to the table then use a select statement to return a true/false then perform an update/insert based on the conditions. There are more elequeont ways of doing this rather then they method you're using.