Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Incident Reports » Incident Reports Reported for Version 1.16 » View Incident Report |
Serious |
Reported By: Jon Lloyd Duerdoth Reported On: 10/7/1999 For: Version 1.16 Build 1 |
{ SQL Text } select * from "Accounts.dat" Accounts Left outer JOIN "contrecs.dat" Contrecs ON (Accounts."AccID" = Contrecs."AccID") where (Accounts.AccID <= "1999-006" and ContribOrReceipt = "C") or (ContribOrReceipt = "R") order by AccID, ContribOrReceipt, QuarterID, FundReportOrder, ContributionDate, FundID { Program statements } // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ procedure TForm1.Button2Click(Sender: TObject); var SQLstr : string; begin dbiqContRecs.close; SQLstr := 'select * from "Accounts.dat" Accounts ' + ' Left outer JOIN "contrecs.dat" Contrecs ' + ' ON (Accounts."AccID" = Contrecs."AccID") ' + 'where (Accounts.AccID <= "1999-006" and ContribOrReceipt = "C") ' + ' or (ContribOrReceipt = "R") ' + ' order by AccID, ContribOrReceipt, QuarterID, ' + ' FundReportOrder, ContributionDate, FundID '; dbiqContRecs.SQL.Clear; dbiqContRecs.SQL.Add(SQLstr); dbiqContRecs.open; end; // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This web page was last updated on Wednesday, March 20, 2024 at 07:22 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |