<< Click to Display Table of Contents >> Navigation:  The Vo2Ado RDD > Basics > Basic Usage

The VO2ADO RDD should be used just like any other RDD. So the following syntax is possible:

 

USE TITLES VIA "VO2ADO"

 

you can also use the following syntax:

 

RDDSETDEFAULT("VO2ADO")

USE TITLES

 

or

 

oSrv := DbServer{"TITLES"}

 

This will open the Table Titles in a VO Workarea. You can then perform all the usual operations on the workarea, such as:

•Record movement

         GO TOP

         GO BOTTOM

         SKIP

         GOTO

 

•Read and Write field values

 x := oFIELDGET(1)

 y := FIELDGETSYM(#TITLE)

 FIELDPUT(10, "Jones")

 FIELDPUTSYM(#OrderDate, TODAY())

 

•Setting relations between tables

 

 RDDSETDEFAULT("VO2ADO")

 USE TITLES NEW

 USE AUTHORS NEW

 SET INDEX TO AU_ID

 SELECT TITLES

 SET RELATION TO AU_ID INTO AUTHORS

 

•Add and delete records

 APPEND BLANK

 DELETE

 ZAP

 

•Batch operations

 USE AUTHORS VIA "VO2ADO"

 COPY TO AUTHORS.TXT DELIMITED

 APPEND FROM AUTHORS2 VIA "DBFNTX"