Subject | Slow Posting becouse of calculated fields |
---|---|
Author | Burak OZLER |
Post date | 2001-12-25T17:05:14Z |
Hi all
Happy Christmas to everyone & Loves from Turkey...
My table includes 5 calculated field and I have this function
procedure TfrmCEK.qryCEKCalculateField(Sender: TIB_Statement;
ARow: TIB_Row; AField: TIB_Column);
begin
ARow.SetColumnValue('CARIAD',DataMod.FN_CariID2CariAD(ARow.GetColumnValue('C
ARIID'),ARow.GetColumnValue('CARI_SID')));
ARow.SetColumnValue('BANKAAD',DataMod.FN_BankaID2Ad(ARow.GetColumnValue('BAN
KAID'),ARow.GetColumnValue('BANKA_SID')));
ARow.SetColumnValue('HESAPNO',DataMod.FN_HesapID2HesapNo(ARow.GetColumnValue
('BHESAPID'),ARow.GetColumnValue('BHESAP_SID')));
ARow.SetColumnValue('PROJEDETAY',DataMod.FN_Proje_D_ID2PDetay(ARow.GetColumn
Value('PROJE_D_ID'),ARow.GetColumnValue('PROJE_D_SID')));
end;
what I don't under stand is why TIB_Query runs this function 14 times when
posting, any reason? any solution? are welcome
Regards
Burak OZLER
Happy Christmas to everyone & Loves from Turkey...
My table includes 5 calculated field and I have this function
procedure TfrmCEK.qryCEKCalculateField(Sender: TIB_Statement;
ARow: TIB_Row; AField: TIB_Column);
begin
ARow.SetColumnValue('CARIAD',DataMod.FN_CariID2CariAD(ARow.GetColumnValue('C
ARIID'),ARow.GetColumnValue('CARI_SID')));
ARow.SetColumnValue('BANKAAD',DataMod.FN_BankaID2Ad(ARow.GetColumnValue('BAN
KAID'),ARow.GetColumnValue('BANKA_SID')));
ARow.SetColumnValue('HESAPNO',DataMod.FN_HesapID2HesapNo(ARow.GetColumnValue
('BHESAPID'),ARow.GetColumnValue('BHESAP_SID')));
ARow.SetColumnValue('PROJEDETAY',DataMod.FN_Proje_D_ID2PDetay(ARow.GetColumn
Value('PROJE_D_ID'),ARow.GetColumnValue('PROJE_D_SID')));
end;
what I don't under stand is why TIB_Query runs this function 14 times when
posting, any reason? any solution? are welcome
Regards
Burak OZLER