Hello

I am trying to get a two part SQL query to work (D5, DBISAM)

If I run the two parts in Steve Peacock's "20 Queries", I get a result set: 
but if I run them in my app as follows there is no result set.  

What am I doing wrong?

TIA Mark

    SQL.Clear;
    SQL.Add('Select d.LogCode, d.ForCode, d.DockType, d.Comp,');
    SQL.Add('d.SpeciesCode, sum(TruckLoad) SpecTot');
    SQL.Add('into t1');
    SQL.Add('from dockets d');
    SQL.Add('where DocketDate between :StartDate  and :EndDate');
    SQL.Add('group by LogCode, ForCode, DockType, Comp, 
SpeciesCode;');

    SQL.Add('Select l.Logname, f.ForName,');
    SQL.Add('d.LogCode, d.ForCode, d.DockType, d.Comp, 
d.SpeciesCode,');
    SQL.Add('d.Grade, sum(d.TruckLoad) GradeTot, t1.SpecTot');
    SQL.Add('from Dockets d');
    SQL.Add('join Logger l on d.LogCode = l.LogCode');
    SQL.Add('join Forest f on d.ForCode = f.ForCode');
    SQL.Add('join t1 on d.LogCode = t1.LogCode');
    SQL.Add('and d.ForCode = t1.ForCode');
    SQL.Add('and d.DockType = t1.DockType');
    SQL.Add('and d.Comp = t1.Comp');
    SQL.Add('and d.SpeciesCode = t1.SpeciesCode');
    SQL.Add('where DocketDate between :StartDate  and :EndDate');
    SQL.Add('group by LogCode, ForCode, DockType, Comp, 
SpeciesCode, Grade');
    ParamByName('StartDate').AsDate := Date1;
    ParamByName('EndDate').AsDate := Date2; 
  Open;
---------------------------------------------------------------------------
    New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
                  Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED] 
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/

Reply via email to