SQL Update in Valentina Xtra

[Gregoire William]

look at SQLExecute

-----Message d'origine-----
De : valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net]De la part de Bub
Envoye : jeudi 9 septembre 2004 17:00
A : 'Valentina Developers'
Objet : SQL Update in Valentina Xtra



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.

_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina