Ask Your Question
0

How can I access to Table Views in Base - Firebird embedded?

asked 2019-05-07 20:02:18 +0200

Rolandvl gravatar image

On the User Interface (Tasks) there is a possibility to Create View... Then you can make a design of a view (like a query) and then at the end Save that view. Returning back to the main User Interface, I do not see this saved View. Nothing found

How to access, edit or view, a saved views?

This is with an embedded Firebird- database with Base Libreoffice Version: 6.1.5.2 (x64) on Windows 10. And this is not a migration from HSQLDB

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2019-05-08 11:17:20 +0200

ebot gravatar image

If you saved the view with a name, the view should be available in "Tables".

edit flag offensive delete link more

Comments

Yes, but only after saving, closing and reopening the odb-file.

Rolandvl gravatar imageRolandvl ( 2019-05-08 12:02:11 +0200 )edit

For me, saving the view ranges. Try the next higher LO version

ebot gravatar imageebot ( 2019-05-08 14:31:41 +0200 )edit
1

Should only need to refresh the tables list. On main screed select Tables section. Then from menu View->Refresh Tables.

Ratslinger gravatar imageRatslinger ( 2019-05-09 20:01:56 +0200 )edit

That was it! Refresh tables...but.... You cannot edit a view definition in the graphic environment of Base. Therefore I created and saved a Query. Then with the "Queries-list" , I right-click on the saved query and then "Create as view". LibreOffice system gives me a warning: "No table format could be found", but I go on; when I click on Tools (Table Filter) I find that view as hidden. Finally: checked it (un-hide), then Refresh tables...and of course after each step: save.

Rolandvl gravatar imageRolandvl ( 2019-05-10 10:59:38 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-05-07 20:02:18 +0200

Seen: 75 times

Last updated: May 08