Recordset handling predefined procedures and functions

This procedure goes to the next record of recordset t.



This procedure goes to the prior record of recordset t.



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



This procedure goes to the last record of recordset t.



This function returns (1) if we have reached the “end of file“ of recordset t.



This function returns (1) if we have reached the “begin of file“ of recordset t.



This procedure prepares the query q for execution.



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



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



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



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



This procedure sets the value of the field fieldname as fieldvalue. Then, we execute the change to the physical table.



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



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



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



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



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



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



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



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



This procedure executes the query with handle q. TSetParam can set parameters.



This procedure closes and frees the query with the name qname.



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



The above procedure posts all the changes of the previous TAppend or TEdit procedures. With all of the corresponding TSetFld calls.



This procedure deletes the current record of table t.

@hid1








TCreateClientEnd

TSetName

TFreeClientDataSet

TAddIndex

TMoveData

TEmptyData

TIndexName

TGotoCurRow

ExportTable

ImportTable

ExportSchema

ExportSysSchema

ImportSchema

TGetCurRow

SaveToClientDataSet

ParamsEmbSQL

PrepareEmbSQL

OpenConnTable

OpenClientTable

TableByName

CloseEmbSQL

NameEmbSQL

@hid2
















‘