Contents
Articles
Behaviors
Books
Director News
Director Web Sites
FAQ
Games
Mailing Lists
News Groups
Project Examples
Reviews
Software
Tools
Useful Web Sites
Utilities
Xtras

Don't miss these
AnimCap
Dialogs - Tell Me Something
DirectInteraction Xtra.
3DPI
Blur Rollover-Alphamania
Preload within Markers v.BETA
All_In_One Button Hue Shift
TaskXtra
Import Quicktime Movies
Wait for explode to finish
 

 

 

FAQ Creating Records - Valentina

Added on 4/4/2001

 

Compatibilities:

Required Xtras:
Valentina

This item has not yet been rated

Author: Thomas (website)

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

 


Contact

MMI
36 South Court Sq
Suite 300
Newnan, GA 30263
USA

Send e-mail