Subject | Dumb calc fields question |
---|---|
Author | Robert martin |
Post date | 2006-02-07T20:24:20Z |
Hi
I am using the TIB_Query component and have defined a calc field.
In the Oncalc event I have the following code, which returns results but
not the correct results !
if (AField.FieldName = 'ETA') then begin
AField.AsDateTime :=
ARow.Statement.FieldByName('NextShipDate').AsDateTime;
end;
Do I need the 'if (AField.FieldName = 'ETA') then begin '. Is this
code run once per row or once for each column in the row?
ARow.Statement.FieldByName('NextShipDate').AsDateTime; Is not returning
the correct date. (no date at all). What is the correct way to access
other field data?
--
Rob Martin
Software Engineer
phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com
Wild Software Ltd
I am using the TIB_Query component and have defined a calc field.
In the Oncalc event I have the following code, which returns results but
not the correct results !
if (AField.FieldName = 'ETA') then begin
AField.AsDateTime :=
ARow.Statement.FieldByName('NextShipDate').AsDateTime;
end;
Do I need the 'if (AField.FieldName = 'ETA') then begin '. Is this
code run once per row or once for each column in the row?
ARow.Statement.FieldByName('NextShipDate').AsDateTime; Is not returning
the correct date. (no date at all). What is the correct way to access
other field data?
--
Rob Martin
Software Engineer
phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com
Wild Software Ltd