Changing records - Valentina

 

Compatibilities: Required Xtras: Valentina

This item has not yet been rated

How do I change existing records in a table in Valentina?

This is a way of changing records in a table in Valentina: -- Open the database if not already open vDB = new(Xtra "VDatabase") vDB.OpenDatabase("databasename.vdb") -- vTable is the table to add a record to vTable = "tablename" -- Open the recordset for that table vRS = new(Xtra "VCursor", vDB.getRef(), "SELECT * FROM " & vTable) -- Change data vRS.SetField("fieldname1", "value") vRS.SetField("fieldname2", "value") .... -- Update the record vRS.UpdateRecord() -- Close the recordset vRS = 0