OnGetFieldValue event in JITPipeline

rbuser

The OnGetFieldValue event fires three times for each DBText field in the
report. Is this expected?

A simple test report with one DBText field in the detail band. JITPipeline
has one field defined.

the GetFieldValue function is as follows:
function TReports.ppJITPipeline1GetFieldValue(aFieldName: string): Variant;
begin
Result := inttostr(a);
inc(a);
end;

a is a private variable in the form.
JITPipeline.recordcount := 10;

The report shows 10 lines with the values of

2
5
8
11
14
17
20
23
26
29

I am trying to read a field from table1 and using that value select records
from table 2 and display statistical info about thoes records but with the
event firing three times for each line how do I know when to select the next
record from table1?

Thanks

nardmoseley

Use the master JITPipeline OnRecordPositionChange event to filter a detail
dataset.

The OnGetFieldValue event simply returns the field value for the current
record. It can fire any number of times. (This is the same concept of as a
dataset, when you are on a row of data you can check the value any number of
times. The data changes when you move to a different record. )

A couple of other approaches you might consider.

1. Linking Master/Detail with JITPipeline

http://www.digital-metaphors.com/rbWiki/Data_Access/JIT_Data/Master-Detail

2. Linking SQL queries

http://www.digital-metaphors.com/rbWiki/Data_Access/Database/Linking_SQL_Queries



--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com