Recordset handling predefined procedures and functions

TNext ( t )

 

This procedure goes to the next record of recordset t.

 

TPrior ( t )

 

This procedure goes to the prior record of recordset t.

 

TFirst ( t )

 

This procedure goes to the first record of recordset t. Recordset is a query or table.

 

TLast ( t )

 

This procedure goes to the last record of recordset t.

 

TEOF ( t )

 

This function returns (1) if the "end of file" of recordset t has been reached.

 

TBOF ( t )

 

This function returns (1) if the "begin of file" of recordset t has been reached.

 

TPrepare ( q )

 

This procedure prepares the query q for execution.

 

TRecordCount ( t )

 

This function returns the count of records of the recordset t.

 

TRecNo ( t )

 

This function returns the record number (starting from 1) of the recordset t.

 

TGetFldTbl ( t, fieldname )

 

This function returns the value of the field fieldname of the recordset t. The field value comes directly from the physical table.

 

TGetFld ( t, fieldname )

 

This function returns the value of the field fieldname of the recordset t.

 

TSetFldTbl ( t, fieldname, fieldvalue )

 

This procedure sets the value of the field fieldname as fieldvalue. The change is executed to the physical table.

 

TSetFld ( t, fieldname, fieldvalue )

 

This procedure sets the value of the field fieldname as fieldvalue.

 

TEdit ( t )

 

This procedure sets the current record of recordset t in editing mode.

 

OpenApplTable ( tablename )

 

This function returns the recordset of the tablename. Be careful this is a server side call, tables are not allowed to open in clients.

 

QueryByName ( qname )

 

This function returns the handle of the query with name qname.

 

RunEmbSQL ( qname, p1, p2, ..., p12 )

 

This procedure executes the query with name qname. The parameters p1,..p12 are optional, in case the query is a parameterized query.

 

SeekUIndex ( t, uvalue )

 

This function returns (1) if the seek to recordset t with unique key value uvalue is successful. Otherwise returns (0).

 

TSeek ( t, indexname, val )

 

This function returns (1) if the seek to recordset t with indexname value uvalue is successful. Otherwise returns (0).

 

TSetParam ( q, param, val )

 

This procedure sets to the parameter param of the query recordset q the value val. This in case we have a big number of parameters (over 10).

 

TExecute ( q )

 

This procedure executes the query with handle q. Parameters can be set by TSetParam.  

 

FreeEmbSQL ( qname )

 

This procedure closes and frees the query with name qname.

 

TAppend ( t )

 

This procedure sets the table recordset t in appending a new record mode.

 

TPost ( t )

 

This procedue posts all the changes of the previous TAppend or TEdit procedures with the corresponding TSetFld calls.

 

TDelete ( t )

 

This procedure deletes the current record of table t.

 

TSetUniqueField

TSetDataEvents

TCreateClientStart

TAddFld

TCreateClientEnd

TSetName

TFreeClientDataSet

TAddIndex

TMoveData

TEmptyData

TIndexName

TGotoCurRow

ExportTable

ImportTable

ExportSchema

ExportSysSchema

ImportSchema

TGetCurRow

SaveToClientDataSet

ParamsEmbSQL

PrepareEmbSQL

OpenConnTable

OpenClientTable

TableByName

CloseEmbSQL

NameEmbSQL