Publish date: 2004-10-21
Work with transactions through SQL commands (VB)
dim src set src=CreateObject("ADODB.Connection") src.open "file name=d:\database\employee.ibp" dim cmd set cmd=CreateObject("ADODB.Command") cmd.ActiveConnection=src cmd.CommandText="SET TRANSACTION WAIT" cmd.execute cmd.CommandText="select count(*) from employee" dim rs set rs=cmd.execute MsgBox rs(0) cmd.CommandText="COMMIT" cmd.execute