Update value in database(access-connectivity toolset )

[JTAG]

Hello,

I am using the database connectivity toolset and I am trying to change values of an existing database.
I used the "Update" command but i got an ERROR!!!.

"Exception occured in Microsoft JET Database Engine, Syntax error in UPDATE statement..  in Conn Execute.vi->...."????

What to do???

Regard's

Eyal.

[veddegjerde]

Hi

The shearch statement (after Where) shud be anather field than the field you are trying to change.

I am using defoult value on cursor type with sucsess.

I hope this will help you

Rune

[Brian_Beal]

I'm not sure about your statements, but you need to have a semi-colon at the end of the query.

[veddegjerde]

try sql query like " UPDATE TBLPASSWORD SET PASSWORD = 'DAVID' WHERE USERNAME='CECAR'  "