Kbase P79807: Using buffer as ProDataSet data-source retrieves more than one record
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
22/11/2009 |
|
Status: Unverified
SYMPTOM(s):
Using buffer as ProDataSet data-source retrieves more than one record
Specific record read in buffer using FIND statement or FIND-* method
ProDataSet FILL method reads all records from table buffer is attached to
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
CAUSE:
Expected behavior.
Due to the self-contained architecture of the ProDataSet it ignores the contents of the buffer before the fill-operation, and when using a buffer as a data source no selection criteria (other than those implied by the data-relation) are applied, making it very likely that more than one record is added to the ProDataSet.
FIX:
To filter out a unique record and add that to the dataset:
Use a query with the appropriate where clause for the data-source
-or-
Set the fill-mode for the buffer to no-fill and manage it manually via the before-fill event-procedure.