Kbase P26832: ServerSendRows does not return the correct number of records
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/4/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1x
SYMPTOM(s):
ServerSendRows does not return the correct number of records.
When following the whitepaper "Using SmartObjects from Outside the ADM" or using the sample code in DLC\src\samples\open4gl\SDO\4gl\runSDO.p, the call to ServerSendRows is incorrect. This means that the number of returned records are not correct.
CAUSE:
The starting position is needed to empty the RowObject temp table.
FIX:
Call ServerSendRows specifying a start position of 'FIRST' in the second parameter, i.e.
RUN serverSendRows IN hSdo
(0 /* no particular start row */,
"FIRST" /* or starting RowId */,
no /* no need to do a NEXT after getting the first row */,
iBatch /* maximum number of rows to batch*/,
OUTPUT iRows /* actual number of rows returned */,
OUTPUT TABLE RowObject).