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

<< 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

<<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?

<< 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

<<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