how to make query change value?

[kermanz]

Pls. help how to make query commands to change or replace specific value ...

example in rangame1>chainfo>chaface
I want to change all values of 2 to 1


Thanks

[MentaL]

[nitro+]

SQL = "Update ChaInfo Set Chaface = 1 where ChaName ='"&MyCharacterName&"'"
RanGame1.execute SQL

Something like that
Posted via Mobile Device

[denvee]

like this too

USE RANGAME1
Update [ChaInfo] set [ChaInfo].ChaOnline=0
Update [UserInven] set [UserInven].UserMoney=5
Update [ChaInfo] set [ChaInfo].ChaMoney=0

just a sample