controller.loadRecords("SELECT <tablepk> FROM <table>)
Function loadRecords(pkdataset) Description Loads the specified form with the primary key's column data as the foundset. Requires a dataset with only the primary key's column data from the table the form is based on. NOTE: This function will work best when the dataset that is retunred is approximately 200 rows (records). This function should not be used if the returned dataset is too large (as in thousands of rows). Example var query = 'select orderid from orders where orderid in (10300,10301,10302);var pkdataset = databaseManager.getDataSetByQuery(controller.getServerName(),query,null,100);controller.loadRecords(pkdataset);
while(controller.recordIndex < controller.getMaxRecordIndex())
{
controller.recordIndex = controller.getMaxRecordIndex()
}
Return to Programming with Servoy
Users browsing this forum: No registered users and 13 guests