Creating Records - Valentina

 

Compatibilities: Required Xtras: Valentina

This item has not yet been rated

How do I create new records in a table in Valentina?

This is a way of adding new records to 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) -- Create a new record vRS.SetBlank() -- Add data vRS.SetField("fieldname1", "value") vRS.SetField("fieldname2", "value") .... -- Save the record vRS.AddRecord() -- Close the recordset vRS = 0