Hi, I am using Delphi, and I am filling in a database grid with a rather complicated query that looks like this:
SELECT b.Account_No, b.NTSELECT, MAX(b.Tot_Score) as Tot_Score, MAX(b.Tot_Hits) as Tot_Hits, MAX(a.Today_Hit) as Today_hit, MAX(b.TransDt_Dt) as TransDt_Dt, MAX(b.Posting_Dt) as Posting_Dt, MAX(a.FraudLevel) as FraudLevel,MAX(b.Short_Name) as Short_Name, MAX(b.TaxId_Ind) as TaxId_Ind, MIN(b.CollectBal) as CollectBal, MAX(b.DTOpen_Dt) as DTOpen_dt, MAX(b.CurLdgrBal) as CurLdgrBal, MAX(b.AverageBal) as AverageBal FROM R0_Red b, ACCTSUMM a
WHERE a.Account_No = b.Account_No AND b.BankBranch = 4
AND b.Ball = 'T' AND b.Posting_dt = '28-OCT-2002'
GROUP BY b.Account_No, b.NTSELECT
ORDER BY b.Account_No ASC
Now, the trouble is the fields b.NTSELECT. This query worked fine, and gave us a fully functional read-only data grid before this field was added. It has now been requested that we allow the user to update a boolean field, NTSELECT, in the R0_Red table on the fly.
Right from the beginning, I am uneasy about using being able to update records in a source dataset (R0_Red) by playing around on the screen with the true/false value of a boolean field sitting in the RESULT data set. However, I probably don't need to worry about that YET, as the query above simply *does not work*. NTSELECT is a logical (boolean) field defined in R0_Red. If I remove those two references to it, everything works fine, when I add them, I get back an ODBC/SQL error that says "TOO FEW PARAMETERS - EXPECTED 1".
Does anyone have any idea how to do this?
Many thanks to anyone who can help,
Rusty