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
Library dmm_xls for work with Microsoft Excel files
Generic behavior to create a Shortcut
Stream FlashMember (Frame Script,Cast member as Reference)
Sliding menu
Color Picker
Moka Xtra
example the filmloop
Inno Setup Pro
3D Groove
Color Picker
 

 

 

FAQ Changing records - Valentina

Added on 4/4/2001

 

Compatibilities:

Required Xtras:
Valentina

This item has not yet been rated

Author: Thomas (website)

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

 


Contact

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

Send e-mail