SQL - complicated query

[M.D.]

Hi,

suppose i have a table with a single column. And i wanna do query that does the following:

if table is empty
insert value x into the table
else // here in this case the table will have one row ONLY
update the only existing row to value x
end

is it possible to do something like "insert or update" query?

[faulkner132]

Here is some psuedocode you could use in your program:

recordset = "SELECT Count(*) AS NumRecords FROM TableName"

if recordset(NumRecords) > 0 then
   //record already exists, delete it
   RunSQL("DELETE FROM TableName")
end if

//the table is empty, insert the new
RunSQL("INSERT INTO TableName VALUES(" + Value + ")"

This will delete the value if it already exists and then insert the value you want. It is best not to have 2 different queries (an Insert and Update) to modify a single value if you can avoid it.

[M.D.]

tnx

i will do:

count rows
if rows > 0
update
else
insert
end

tnx alot