https://bugs.documentfoundation.org/show_bug.cgi?id=131238
Max Fritzler <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |UNCONFIRMED
Ever confirmed|1 |0
--- Comment #11 from Max Fritzler <[email protected]> ---
I was requested to test the test macro in HSQL format. I uploaded two test
databases, one in HSQL and one in Firebird. The macro works as expected in
both those formats, but fails for SQLite. Evidently, the processing of an SQL
string as shown below is done differently based on the attached database. Whis
is not really a surprise. Here's the statement that succeeds in embedded
databases, but fails with SQLite
Dim oStatement As Object
oStatement = ThisComponent.CurrentController.ActiveConnection.createStatement()
sql = "INSERT INTO TestEmoji (author, comment) VALUES ('test author',
'❤❤SWIFTIE❤❤')"
result = oStatement.execute(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
