Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 1.04 » View Incident Report |
Serious |
Reported By: Abdulaziz Jasser Reported On: 6/23/2007 For: Version 1.04 Build 2 |
EDBDatabase1.StartTransaction; for i:=1 to 10 do begin sSQL := 'SELECT AccountNo,AccountBalance '+ 'FROM TB_AccountBalances '+ 'WHERE BranchSysNo = %d AND YearSysNo = %d AND '+ 'AccountNo IN %s'; sSQL := Format(sSQL, UserData.BranchSysNo, rUserData.YearSysNo, rAccounts.ParentAccounts]); GetRecord(qryAccounts,sSQL); while NOT qryAccounts.Eof do begin qryAccounts.Edit; qryAccounts['AccountBalance'] := qryAccounts['AccountBalance'] + rAccounts.DebitAmount; qryAccounts['AccountBalance'] := qryAccounts['AccountBalance'] - rAccounts.CreditAmount; qryAccounts.Post; qryAccounts.Next; end; end; //end for EDBDatabase1.Commit;
This web page was last updated on Tuesday, April 23, 2024 at 08:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |