Progress
ADM 2 Guide
Batch-mode Operations
In batch mode, you batch data in a Progress temp–table from a SmartDataObject and, when needed, back to the SmartDataObject. When a SmartDataObject is initialized and its database query opened, the object transfers rows from the query into the RowObject temp–table defined in the SmartDataObject. (By default, 200 rows are transferred at a time, but you can reset this with the setRowsToBatch function.) A non-Progress client application should run serverSendRows to receive this table; this function returns the RowObject temp–table, which can be browsed from the client as an SQL dataset. If you make updates, you must construct a RowObjUpd dataset with the RowNum, RowIdent, RowMod, and ChangedFields fields set for each modified row. To return this dataset to the SmartDataObject, run serverCommit, which accepts the temp–table and returns the same table with any additional fields that might have been set by database triggers (key values and so forth), along with OUTPUT parameters that contain any error messages and the RowIdent fields of any records that were not updated because of errors. The calling sequence for the fetchMessages function is described in the format of the error message string.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |