Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 5 of 5 total |
error in Transaction + Update Sql Statement |
Mon, Mar 5 2007 8:57 AM | Permanent Link |
MNosuhi | hi
when i was working to dbisam , there was a problem for me. i start a transaction , then use a SQL Update Statement to modify a group of records , but when use Apply function , my program locked. what must i do? My Code : ///////////////// procedure TForm1.Button1Click(Sender: TObject); var s:TStrings; begin try s:=TStringList.Create; s.Add('ser'); try DBISAMDataBase1.StartTransaction(s); DBISAMQuery1.sql.Clear; DBISAMQuery1.SQL.Add('Update "'+ExtractFileDir(Application.ExeName)+'\d\ser'+'"'); DBISAMQuery1.SQL.Add('Set SCCode='+Trim(Edit1.Text)); DBISAMQuery1.SQL.Add('where SCode<='+Trim(Edit2.Text)); DBISAMQuery1.ExecSQL; DBISAMDataBase1.Commit; except DBISAMDataBase1.RollBack; ShowMessage('Tr Erroe'); end; finally s.Free; end; ///////////// Operating system : xp (media center) Development environment :delphi7 Product and version: DBISAM VCL ver 4.19 |
Mon, Mar 5 2007 9:59 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | << when i was working to dbisam , there was a problem for me. i start a transaction , then use a SQL Update Statement to modify a group of records , but when use Apply function , my program locked. >> I'm looking at this issue that you sent via email today. I will let you know what I find out. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Mar 6 2007 3:52 AM | Permanent Link |
MNosuhi | <<I'm looking at this issue that you sent via email today. I will let you
know what I find out.>> what must i do? Are There Any answer for my question? |
Tue, Mar 6 2007 1:00 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | << what must i do?
Are There Any answer for my question? >> See my email yesterday - you needed to associate the TDBISAMUpdateSQL component with the table that you were updating in order to make sure they were both using the same session, and subsequently the same transaction. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Mar 6 2007 3:43 PM | Permanent Link |
MNosuhi | <<See my email yesterday - you needed to associate the TDBISAMUpdateSQL
component with the table that you were updating in order to make sure they were both using the same session, and subsequently the same transaction.>> Really very thanks |
This web page was last updated on Friday, April 26, 2024 at 06:09 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |