Consultor Eletrônico



Kbase P102502: How to exclude records from a ProDataSet FILL operation ?
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   30/03/2005
Status: Unverified

GOAL:

How to exclude records from a ProDataSet FILL operation ?

GOAL:

How to filter records when filling a ProDataSet ?

FACT(s) (Environment):

OpenEdge 10.0x

FIX:

There are two ways to accomplish this:

1. When using a query-based data-source, one can set up a BEFORE-FILL event procedure that prepares the query with an appropriate WHERE clause.

2. For both DB buffer and query based data-sources, a BEFORE-ROW-FILL event procedure can be used that rejects the row by using RETURN NO-APPLY.