CAstaDataList

The CAstaDataList is an efficient DataStructure that handles rows and columns much like a database table. To request a DataList from a remote server you must create an CAstaParamlist and fill it with the following values:

AstaPLSetString(AstaLibRef, params, 0,'Select * from Customer', "PalmSelect");
AstaPLSetLongInt(AstaLibRef, params, 1, 10000, "RowCount");

Param 0: the Select SQL as a String
Param 1 : the maximum rowcount

The DataList basically contains a List of ParamLists that contain data natively, stored very efficiently, wthout duplicating paramnames, like the CAstaNestedParamList does. Each row can be retrieved into a ParamList with the option of bring the Param or "FieldNames" also by calling AstaDLGetAsParamList.

AstaDLCreate AstaDLDestroy AstaDLGetAsParamList AstaDLGetField AstaDLGetFieldByName AstaDLGetFieldByNo AstaDLGetFieldCount AstaDLGetFieldName	AstaDLGetFieldNameC AstaDLGetFieldNo AstaDLGetFieldOptions AstaDLGetFieldType AstaDLGetIndexOfField AstaDLGetRecordsCount AstaDLIsEmpty
Click on the property or method to see description