https://bugs.documentfoundation.org/show_bug.cgi?id=103333
--- Comment #3 from [email protected] ---
(In reply to libreoffice from comment #2)
> BUT: No result is shown when I write a simple sql-statement and have it
> handled by this mysterious SQL-Button. While clicking the
> execute-query-button gives the expected result.
> No "output of the query at this place" is presented.
This SQL-button is a special button for executing a command directly to the
database, not controlled by Base. There are some commands that wouldn't work,
if the button isn't pressed.
USER()
or
CASE v1 WHEN v2 THEN v3 [ELSE v4] END
for example doesn't work in GUI, but work with the internal HSQLDB and direct
SQL.
If you use the SQL-button you could save a query with SQL-comments. You could
also format a query by returns.
If you have pressed the SQL-button there is one disadvantage: You couldn't add
or change data in a executed query. So direct SQL isn't usable for forms to
input new data, because this function must be controlled by Base.
Should we set this bug to Resolved and Worksforme?
--
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
