Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 1.03 » View Incident Report |
Serious |
Reported By: Michael Fullerton Reported On: 5/30/2007 For: Version 1.03 Build 1 |
procedure TForm1.Button1Click(Sender: TObject); begin EDBDatabase1.Open; EDBDatabase1.StartTransaction; try with EDBQuery1 do begin Close; SQL.Text:='DELETE FROM TimeHist WHERE LoginID=''Mike Fullerton'' AND StartTime '+ 'BETWEEN TIMESTAMP ''2007-05-28 00:00:00'' AND TIMESTAMP ''2007-06-03'''; ExecSQL; end; with EDBQuery1 do begin SQL.Text:='INSERT INTO TimeHist (LoginID,ClientID,ProjectID,TaskID,StartTime,EndTime,Comments) '+ 'VALUES(''Mike Fullerton'',''Acme Piping'',''test'',''testt'', TIMESTAMP ''2007-06-01 00:00:01'', '+ 'TIMESTAMP ''2007-06-01 00:18:00'','''')'; ExecSQL; SQL.Text:='INSERT INTO TimeHist (LoginID,ClientID,ProjectID,TaskID,StartTime,EndTime,Comments) '+ 'VALUES(''Mike Fullerton'',''Acme Piping'',''test'',''testt'', TIMESTAMP ''2007-06-02 00:00:01'', '+ 'TIMESTAMP ''2007-06-02 01:00:00'','''')'; ExecSQL; end; EDBDatabase1.Commit; ShowMessage('Done'); except on E:exception do begin ShowMessage(E.Message); EDBDatabase1.RollBack; end; 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 |