[Solved] Can't "create query in SQL view"

Creating tables and queries
Post Reply
rstaad
Posts: 2
Joined: Thu Dec 24, 2015 3:34 am

[Solved] Can't "create query in SQL view"

Post by rstaad »

I'm new to OpenOffice and have only used Access in regard to SQL experience and at a very basic level.

I recently purchased Sams Teach Yourself SQL in 10 minutes. In the book, the advise to get OpenOffice. You are provided a file to start with.

I have followed the directions, which direct me to open the file and then open the "Create Query in SQL View" to type in a SELECT statement. However, every time I click on this, nothing happens.

Am I missing something here? Should a window open up? Should the prompt be moved to the lower right box in the Queries window?
Last edited by Hagar Delest on Fri Feb 26, 2016 10:43 pm, edited 1 time in total.
Reason: tagged [Solved].
- Ross
OSX 10.11.2
OpenOffice 4.1.27
F3K Total
Volunteer
Posts: 1038
Joined: Fri Dec 16, 2011 8:20 pm

Re: can't "create query in SQL view"

Post by F3K Total »

Hello,
just a guess: You have to store the file to your harddrive, then open it from there.
R
  • MMove 1.0.6
  • Extension for easy, exact positioning of shapes, pictures, controls, frames ...
  • my current system
  • Windows 10 AOO, LOLinux Mint AOO, LO
User avatar
charlie.it
Volunteer
Posts: 417
Joined: Wed Aug 21, 2013 2:12 pm
Location: Italy

Re: can't "create query in SQL view"

Post by charlie.it »

Uninstall the OO 4.1.2 version, Base don't work in Mac OSX. Install version 4.1.1. viewtopic.php?f=13&t=80059
charlie
Italian AOO Admin
macOS 14 Sonoma M1: Open Office 4.1.15 - LibreOffice 7.5.7.1

http://www.charlieopenoffice.altervista.org
rstaad
Posts: 2
Joined: Thu Dec 24, 2015 3:34 am

Re: Can't "create query in SQL view"

Post by rstaad »

4.1.1 fixed the issue. Thanks charlie.it.
- Ross
OSX 10.11.2
OpenOffice 4.1.27
Post Reply