https://bugs.documentfoundation.org/show_bug.cgi?id=89523
Bug ID: 89523
Summary: EDITING: Formdesign: Push-Buttons should get a
possibility to exceute direct SQL-code
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Base
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: rob...@familiegrosskopf.de
Created attachment 113570
--> https://bugs.documentfoundation.org/attachment.cgi?id=113570&action=edit
Show where to integrate the SQL-Code in general properties of a push-button.
For many little SQL-tasks in LO-Base you need to execute a macro. It would be a
good enhancement to get this possibility directly in a push-button without any
knowledge of tricky macros.
Examples
1) Many people use separate filter-tables to search for the right data in
subforms. The fields in the tables should be set to NULL for showing all data.
You could delete the content in every field, save the form and refresh the
other form. Better you will set
UPDATE "Filter" SET "F_1" = NULL;
UPDATE "Filter" SET "F_2" = NULL;
UPDATE "Filter" SET "F_3" = NULL;
UPDATE "Filter" SET "F_4" = NULL
and refresh the other form - all by pressing one push-button.
2) All content of a table, which is older than 100 days, should be deleted:
DELETE FROM TABLE "TABLE1" WHERE DATEDIFF ('dd', DATUM,CURRENT_DATE) > 100
You could add the code every time directly to Tools → SQL and have to remember
every time. You could add this code to a macro. Or you would add this code to a
push-button and it would be executed there.
It would be great to get a possibility to save SQL-code in a button and to
execute this code if it is needed.
There should be added a field for SQL-native and also an Action "Execute SQL →
Refresh Form".
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
