Below are the standard events supported by ASTA SkyWire™ Servers with the ParamList filled with values that the server is expecting according to the conventions defined below. The tokens are defined in constants.bas.
These calls are initiated on the PDA clients by creating an AstaParamList and optionally adding values to it and then sent to the server using a pre-defined token.
| PdaServerTime (1001) |
This will retrieve the server time and can be used to see if the server is active like a ping |
| PdaSimpleSQLSelect (1003) |
One String Param is passed to the server and it is executed as Select SQL with one row being returned with each Field as a ParamName and the Value of each field contained AsString. To use Native Data use the full featured DataList token PdaMultiSelect. |
| PdaPalmTables (1004) |
Retrieves a list of tables from the server database. Servers could be coded to support more than one database in which case the String sent to the server could specify a particular database. |
| PdaPalmExecSQL (1005) |
On the server, a transaction is started and each ParamItem is passed to an ExecSQL call. If all the ExecSQL's are successful, the transaction is committed, otherwise Rollback is called. |
| PdaPalmFieldDefs (1006) |
The server expects one string param that contains the name of the table. A list of fields will be returned in an AstaParamList. |
| PdaNestedSQLSelect (1010) |
Executes Select SQL at the server and returns an AstaNestedParamList |
| PdaMultiSQLSelect (1011) |
Executes Select SQL at the server and returns an AstaDataList |
| PdaMultiExecSQLParamList (1012) |
This allows for multiple parameterized queries handled by the server in a transaction so that blob and memo fields can be supported. Requires an AstaNestedparamList build since a ParamList must be sent along with each SQL Statement. Not currently implemented. |
| PdaGetFileFromServer (1050) |
Gets a file from a remote server where the string param is the remote file name. |
| PdaSendFileToServer (1051) |
This sends a blob to a remote server and contains the FileName in Param Zero and the Stream to be saved in Param One as a Blob |
