General discussion on OpenOffice Base and its databases.
I'm attempting to modify the data in OO Base by the UPDATE statement in the query and I've got only the error message that inform me, that only SELECT statements are available to use in OO Base. A'm using the last version of the OO.
Is this error message correct ? If this is so, then OO Base is fully useless.
- Posts: 28
- Joined: Tue Mar 25, 2014 6:27 am
The query editor in Base is designed to display resultsets and isn't intended for other uses.
For general SQL statements (where you don't need to see resultsets), Follow the steps:
1. Go to the menu
3. SQL and a window will pop up that will execute all your non-SELECT SQL statements, including UPDATE.
I hope this will helps you
- Posts: 26
- Joined: Tue Mar 25, 2014 6:25 am
Return to OpenOffice.org Base
Who is online
Users browsing this forum: No registered users and 1 guest