| View previous topic :: View next topic |
| Author |
Message |
Philip Marlowe
Power User
Joined: 15 May 2011
Posts: 94
|
 Posted: Wed May 23, 2012 8:44 am Post subject: [SOLVED] create view option disabled |
 |
|
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 |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Wed May 23, 2012 10:46 am Post subject: |
|
|
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 http://forum.openoffice.org |
|
| Back to top |
|
|
Philip Marlowe
Power User
Joined: 15 May 2011
Posts: 94
|
| Posted: Wed May 23, 2012 10:57 am Post subject: |
|
|
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 |
|
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Wed May 23, 2012 11:29 am Post subject: |
|
|
Instead of restart: View>Refresh Tables
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
|
