https://bugs.documentfoundation.org/show_bug.cgi?id=80084
--- Comment #7 from Gerhard Schaber <[email protected]> ---
To be more precise. When I create a statement before each executeQuery, it
works. Otherwise it does not.
Works:
oDBSource = ThisComponent.DataSource
oConn = oDBSource.getConnection( "" , "" )
oStatement = oConn.createStatement()
sql = "CREATE TABLE " & DBQuoteName("testtable", oConn) & " (id int not null
primary key, txt varchar(50))"
oResult = oStatement.executeQuery(sql)
oStatement = oConn.createStatement()
sql = "INSERT INTO " & DBQuoteName("testtable", oConn) & " values (1, 'test')"
oStatement.executeQuery(sql)
...
Does not work:
oDBSource = ThisComponent.DataSource
oConn = oDBSource.getConnection( "" , "" )
oStatement = oConn.createStatement()
sql = "CREATE TABLE " & DBQuoteName("testtable", oConn) & " (id int not null
primary key, txt varchar(50))"
oResult = oStatement.executeQuery(sql)
'oStatement = oConn.createStatement()
sql = "INSERT INTO " & DBQuoteName("testtable", oConn) & " values (1, 'test')"
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
