On a dataset with several Fields "FieldKind=fkLookup' but without field" FieldKind=fkCalc'.

When the property "AutoCalFields = True"
= > Problem of performance.
When the property "AutoCalFields = False", => no problem of performance but the fields "FieldKind=fkLookup' are not refreshed in insertion mode!!

Is somebody has an explanation?




------------------
Christian Gincheleau

Perhaps one or more lookup tables are very large?

------------------
Marco Kalter
Allround Automations

[quote]Originally posted by mkalter:
Perhaps one or more lookup tables are very large?

[/quote]

No, lookup tables are not very large.

But which is the relationship between the property "AutoCalcFields"
and the fields of the type "FieldKind=fkLoopkup"
and why they are badly refreshed when the property "AutoCalcFields=False".

I am obliged to write the following code on the event "OndataChange"
of the "dataSource" connected to the "DataSet" :

procedure TAffaireDM.dsCdeLigneDataChange(Sender: TObject; Field: TField);
var
i : integer;
begin
if Assigned(Field) then
begin
if not Field.IsNull then
begin
for i := 0 to Field.DataSet.FieldCount - 1 do
begin
if Field.DataSet.Fields[i].FieldKind = fkLookup then
if Field.DataSet.Fields[i].KeyFields = Field.FieldName then
Field.DataSet.Fields[i].Value := Field.DataSet.Fields[i].LookupDataSet.FieldByName(Field.DataSet.Fields[i].LookupResultField).Value;
end;
end;
end;
end;


------------------
Christian Gincheleau

If AutoCalcFields = False, lookups are not automatically performed. This does not explain the actual performance problem of course.

------------------
Marco Kalter
Allround Automations