SQL Update in Valentina Xtra

[Bub]

Hi,

I'm having problems using the SQL UPDATE function. I can use SELECT no
problem, using the following syntax:

dbcursor = new( xtra "VCursor", GetRef(gShops), "SELECT * FROM shops",1,1,2)
shops = getRecords(dbcursor)
setBlank(dbcursor)

However, the following code fails, reporting error 600:

dbcursor = new( xtra "VCursor", GetRef(gShops), "UPDATE shops SET location =
'test' WHERE id = '100'",1,1,2)
shops = getRecords(dbcursor)
setBlank(dbcursor)

Any ideas?

Regards,

bub.