SQL - why does this not work?

[ZeitenWanderer]

Wanted to change the value in an MSAccess-field, but despite that no error message shows up, this minimum task does not do the job. Any idea anybody?

Code: Select all

Let>constr=provider=Microsoft.Jet.OLEDB.4.0;Data Source=DARP_DB.mdb
DBConnect>constr,dbH

UPDATE tblbuchdaten SET DataSelected = REPLACE(DataSelected,"0","1");

DBClose>dbH

[Marcus Tettmar]

You need something like:

Let>QRY=UPDATE tblbuchdaten SET DataSelected = REPLACE(DataSelected,"0","1")
DBExec>dbH,QRY,qResult