SendTable
This function executes the SQL statement locally and copies the results to an existing table on the remote server.
Group: Server Extensions
Syntax: [bOK =] Server.SendTable(sSQL, sRemoteTable, [vKeyFields])
bOK (Boolean) Optional – is a return value; a value of True means the SQL statement processed normally.
sSQL (String) is the SQL statement to be sent to the database. As this is a pass through statement, its syntax must be understood by the database, as no pre-processing will occur.
sRemoteTable (String) is the name of the table already created on the mobile device.
vKeyFields (Variant) Optional – is one or more key fields to represent a unique record. One key would be represented by “PartNo” and multiple keys look like “PartNo,Onhand”.
Example:
Dim bOK as Boolean
bOK = Server.SendTable("Select * from Inv2", "Inventory", "PartNo")