simpleDatabase Component Library

Help file
 

Index

TsDBTable: Methods

procedure Cancel
- cancels any changes to the current record made since the last Insert or Edit command.

procedure Create( AOwner : TComponent )
- creates a new instance of TsTable

procedure CreateTable( filename : string )
- creates a new dBase file. Filename must have the file extension .dbf

procedure Delete
- deletes the current record

procedure Destroy
- destroys the current instance of TsTable

procedure Edit
- places the table in tsEdit state so that changes can be made to the current record. Changes must be confirmed by calling the Post method.

function GetBooleanValue( field : TsField ) : boolean
- returns the boolean value of the field identified by field. If you know the name of the field its TsField value can be obtained by using the GetField function. If field is not a boolean field then GetBooleanValue will send an error message and return false.

function GetField( fieldname : string ) : TsField
- returns the TsField value of the field with the fieldname specified by fieldname. TsField is an object class used for internal data management within TsTable.

function GetIntegerValue( field : TsField ) : longint
- returns the integer value of the field identified by field. If you know the name of the field its TsField value can be obtained by using the GetField function. If field is not a numerical field then GetIntegerValue will send an error message and return zero.

function GetStringValue( field : TsField ) : string
- returns the string value of the field identified by field. If you know the name of the field its TsField value can be obtained by using the GetField function.

procedure Insert
- inserts a new record. The Post method should be called after entering any new data

procedure Last
- moves to the last record in the file

procedure Next
- moves to the next record in the file

procedure Post
- writes to file any changes made since calling the Insert or Edit methods

procedure Prior
- moves to the record preceding the current record

procedure SetBooleanValue( field : TsField : value : boolean)
- assigns the boolean value specified by value to field. If you know the name of the field its TsField value can be obtained by using the GetField function.

procedure SetFloatValue( field : TsField : value : double)
- assigns the floating point value specified by value to field . If you know the name of the field its TsField value can be obtained by using the GetField function.

procedure SetIntegerValue( field : TsField : value : longint)
- assigns the integer value specified by value to field. If you know the name of the field its TsField value can be obtained by using the GetField function.

procedure SetStringValue( field : TsField : value : string)
- assigns the string value specified by value to field. If you know the name of the field its TsField value can be obtained by using the GetField function.

procedure Edit
- places the table in edit mode so that changes can be made to the current record. Any changes must be confirmed by calling the Post method.