OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

[SOLVED] create view option disabled

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
Philip Marlowe
Power User
Power User


Joined: 15 May 2011
Posts: 94

PostPosted: Wed May 23, 2012 8:44 am    Post subject: [SOLVED] create view option disabled Reply with quote

i've connected openoffice base with an informix database through jdbc: why can't i create a view? there's not icon to start writing the sql!
_________________
Libreoffice Base HSQLDB not Embedded


Last edited by Philip Marlowe on Wed May 23, 2012 10:57 am; edited 1 time in total
Back to top
View user's profile Send private message Send e-mail
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Wed May 23, 2012 10:46 am    Post subject: Reply with quote

A view belongs to the database backend. It should be created with your preferred data definition tool for that database.
The command line in Base (Tools>SQL) is the one and only tool which can be considered as safe regarding the database backend.
Does Informix support views?
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
Philip Marlowe
Power User
Power User


Joined: 15 May 2011
Posts: 94

PostPosted: Wed May 23, 2012 10:57 am    Post subject: Reply with quote

i made it! i created the view from tools-->sql. once i restarted libreoffice i could see the view i created in the table list among others
_________________
Libreoffice Base HSQLDB not Embedded
Back to top
View user's profile Send private message Send e-mail
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Wed May 23, 2012 11:29 am    Post subject: Reply with quote

Instead of restart: View>Refresh Tables
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group