[RESOLVED] update databse sql every records

[ksuwanto8ksd]

objconnection.Execute "update table1 set Field1 = field1-1 where field2 = " & val(me.text1)

this code should be "update FROM table1 "
but it is not doing anything to the records, anyway thanks for response

[szlamany]

In MS SQL Server...

UPDATE TABLE SET COLUMN=NEWVALUE WHERE CONDITION=SOMETHING

...is valid

Your WHERE clause must not be finding anything.

And the suggestion to use an ACTION query .EXECUTE'd against the DB is a good one. Using the RS to UPDATE the table is not required.