https://bugs.documentfoundation.org/show_bug.cgi?id=101399
--- Comment #7 from Gerhard Schaber <[email protected]> ---
It seems to work now with 5.3.0.0.alpha0+.
Test macro:
Sub Main
oDBSource = ThisComponent.DataSource
oConn = oDBSource.getConnection( "" , "" )
oStatement = oConn.createStatement()
sql = "CREATE TABLE ""testtable"" (id int not null primary key, txt
varchar(50))"
oResult = oStatement.executeQuery(sql)
'sql = "COMMIT"
'oResult = oStatement.executeQuery(sql)
sql = "INSERT INTO ""testtable"" values (1, 'test')"
oStatement.executeQuery(sql)
End Sub
Quick question, are transactions are supposed to work?
sql = "begin tran"
oResult = oStatement.executeQuery(sql)
sql = "INSERT INTO ""testtable"" values (1, 'test')"
oStatement.executeQuery(sql)
sql = "COMMIT tran"
oResult = oStatement.executeQuery(sql)
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
