Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread error in Transaction + Update Sql Statement
Mon, Mar 5 2007 8:57 AMPermanent 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 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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 AMPermanent 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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 PMPermanent 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
Image