Bug 52571 - BASE VBA DELETE COLUMN OR TABLE DOESN'T CHANGE THE SURFACE
Summary: BASE VBA DELETE COLUMN OR TABLE DOESN'T CHANGE THE SURFACE
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-07-27 06:49 UTC by Stefan Lindel
Modified: 2013-02-07 18:36 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Stefan Lindel 2012-07-27 06:49:02 UTC 
When I delete a Column in VBA with a SQL Statement. THe Suirface don't refresh the information of a Table. The same Problem can be reproducible for delete a Table.
Comment 1 Robert Großkopf 2012-08-03 06:01:23 UTC 
Which database do you use? The internal DB? This DB is cached. So it could be, that every changes of a table in SQL were not shown in the GUI.
If you change the tables in the internal HSQLDB you could use the command "CHECKPOINT" in SQL to see the changes. 
CHECKPOINT closes the database files, rewrites the script file, deletes the log file and opens the database. (Description HSQLDB-Guide)
If this also works for you please close this bug.
Comment 2 Jochen 2012-08-30 08:54:40 UTC 
Hi Stefan,

please answer comment 1
Comment 3 Alex Thurgood 2012-08-30 09:29:31 UTC 
@Stefan : in addition to what Robert has said, you also need to form.reload() your form in Basic, otherwise the changes to the resultset will not be refreshed.


Alex
Comment 4 Robert Großkopf 2012-10-17 18:41:16 UTC 
@Stefan,
you have reported this bug more than 2 months ago. There were some questions from other person, because the informations in your report aren't so good, that we could understand them.
If the problem has gone it would be good, when you give us a little feedback. So we could close this bug.
Comment 5 Robert Großkopf 2013-02-07 18:36:18 UTC 
No reaction by the reporter since over 7 months. Nobody else could confirm this bug.
I close this bug as "Resolved" and "Worksforme".