Records, Introduction

4D - Documentation   Français   English   German   4D Open for 4D, Command Theme List   4D Open for 4D, Command Alphabetical List   Back   Previous   Next

version 1.5


To modify a record, create a new record, or load the data from a current record, you create a bind and establish a link between the server fields and the local fields or variables in which the data will be displayed and/or modified.

The following graphic describes the steps involved in creating and defining a bind so that you can eventually manipulate the data from the 4D Server database.

The following routines allow you to manipulate records:

OP Set access mode - sets the access mode of a table by setting a table to read/write or to read-only mode.

 OP Goto selected record - goes to a specified record in the current selection and makes it the current record. This function optionally loads the field data.

 OP Load record - after you have set a current record by using OP Goto selected record or OP Goto record or by querying, this loads the field data with the fields that you have defined in your bind.

OP Unload record - unloads a record.

OP Update record - to modify the current record with the fields that you have defined in your bind, specify the data to use and call this routine.

 OP New record - to create a new record with the fields that you have defined in your bind, specify the data to use and call this routine.

OP Sequence number - to assign a sequence number to a new record, assign the number returned by this routine.

 OP Delete record - deletes the current record.

OP Goto record - makes a record the current and only record in the selection.

OP Get record numbers - gets the record numbers for the current selection of records. The numbers returned can be passed to OP Goto record to make the specified record the current and only one in the selection. This function optionally loads the field data.

OP Current record number - returns the number of the current record.


4D - Documentation   Français   English   German   4D Open for 4D, Command Theme List   4D Open for 4D, Command Alphabetical List   Back   Previous   Next