Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Incident Reports » Incident Reports Addressed for Version 4.18 » View Incident Report |
Serious |
Reported By: Helmut Schiefer Reported On: 2/13/2005 For: Version 4.17 Build 1 |
Query: ====== Table1 and Table is form Ole's DBBench SELECT a.T1_KEY, a.T1_SFLD1, a.T1_SFLD2, b.T2_SFLD1 FROM TABLE1 a INNER JOIN TABLE2 b ON (a.T1_KEY = b.T2_KEY1) WHERE (a.T1_KEY BETWEEN :P_START AND :P_STOP) AND (b.T2_SFLD1 IS NULL) Test Procedure: procedure TFormTest.Button1Click(Sender: TObject); Var i : Integer; begin Try Query.Params.ParamByName('P_START').AsInteger := 4600; Query.Params.ParamByName('P_STOP').AsInteger := 4690; Query.Prepare; Try For i := 0 to 9 do Begin Query.Active := False; Query.Active := True; End; Except on E: Exception do MessageDlg('I='+IntToStr(i)+' '+E.Message, mtError, [mbOK], 0); End; Finally Query.Close; End; 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 |