I want to use the SQL query IF EXIST to update or insert data in a ms access table, but it doesn´t work

[picard2002]

Hi,
I want to use the SQL query IF EXIST to update or insert data in a ms access table, but it doesn´t work
(fault number -2147217900)
I want to search for a value in a ms access table , if it exist i want to update it, if not i want to insert a new row.

Working with LabView 7.1, database con. toolset.

Who can HELP?

Thanks a lot

Marco

[PauloM]

Hello,

I think that If exist is not a standar SQL command (I know it exists I think in Oracle and SQL server), MS access doesn't support it, so I think the best way to do it is first make a Select and then either an Update or an insert, sorry...

Paulo