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

Selecting from Database

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
UnknownFear
Newbie
Newbie


Joined: 23 Aug 2011
Posts: 2

PostPosted: Tue Aug 23, 2011 12:50 pm    Post subject: Selecting from Database Reply with quote

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
View user's profile Send private message
probe1
Moderator
Moderator


Joined: 18 Aug 2004
Posts: 2560
Location: Chonburi Thailand Asia

PostPosted: Tue Aug 23, 2011 1:09 pm    Post subject: Re: Selecting from Database Reply with quote

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
View user's profile Send private message Visit poster's website
UnknownFear
Newbie
Newbie


Joined: 23 Aug 2011
Posts: 2

PostPosted: Tue Aug 23, 2011 2:50 pm    Post subject: Re: Selecting from Database Reply with quote

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
View user's profile Send private message
RPG
Super User
Super User


Joined: 24 Apr 2008
Posts: 2697
Location: Apeldoorn, Netherland

PostPosted: Tue Aug 23, 2011 3:10 pm    Post subject: Reply with quote

Hello

I think you have also to study this tutorial. Learn clicking around in the query designer.

Learn all button there.

http://wiki.services.openoffice.org/w/images/3/3c/0108GS33-GettingStartedWithBase.pdf

Romke
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