| View previous topic :: View next topic |
| Author |
Message |
UnknownFear
Newbie
Joined: 23 Aug 2011
Posts: 2
|
 Posted: Tue Aug 23, 2011 12:50 pm Post subject: Selecting from Database |
 |
|
I am following along in a SQL book I bought and it says to select from a database, but when I try and select from a table, it gives me an error saying there is no table:
SELECT * FROM myTable;
It says Table not found in statement [SELECT * FROM "myLibrary"]
However, when I type the statement in all capitals, it works. I want to be able to enter the SQL statement without having to capitalize everything.
Also, when I do run a select statement, nothing comes up with the updated table. How do I see the changes made when I run a SQL statement? |
|
| Back to top |
|
 |
probe1
Moderator
Joined: 18 Aug 2004
Posts: 2465
Location: Chonburi Thailand Asia
|
| Posted: Tue Aug 23, 2011 1:09 pm Post subject: Re: Selecting from Database |
|
|
Welcome to the forum.
| UnknownFear wrote: | | It says Table not found in statement [SELECT * FROM "myLibrary"] |
SQL syntax depends on the DB you use - which is it? See status bar of ODF
To find out if you have to use double quotes, single quotes or back ticks, just use the query designer to create one and then switch to SQL mode
| UnknownFear wrote: | | How do I see the changes made when I run a SQL statement? |
Changes of content in table view are updated immediatly in the table. This should show in your query.
How you do a content change?
And please state with every question here which OOo version you are using? Which operating system?
_________________
Cheers
Winfried
My Macros
DateTime2 extension: insert date, time or timestamp, formatted to your needs |
|
| Back to top |
|
|
UnknownFear
Newbie
Joined: 23 Aug 2011
Posts: 2
|
| Posted: Tue Aug 23, 2011 2:50 pm Post subject: Re: Selecting from Database |
|
|
| probe1 wrote: |
To find out if you have to use double quotes, single quotes or back ticks, just use the query designer to create one and then switch to SQL mode |
I'm not sure where this option is. I'm rather new to using OpenOffice, however, I am using LibreOffice.
| probe1 wrote: | | And please state with every question here which OOo version you are using? Which operating system? |
LibreOffice 3.3.4 Final (2011-08-17)
Mac OSX Lion |
|
| Back to top |
|
|
RPG
Super User
Joined: 24 Apr 2008
Posts: 2696
Location: Apeldoorn, Netherland
|
|
| Back to top |
|
|
|
