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

View?Query?[solved]

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


Joined: 15 Jul 2008
Posts: 35
Location: UK

PostPosted: Tue Aug 19, 2008 10:00 pm    Post subject: View?Query?[solved] Reply with quote

What is the essential difference between a VIEW as created from the table dialogue, and a QUERY please?

Last edited by valmorel on Wed Aug 20, 2008 10:01 am; edited 1 time in total
Back to top
View user's profile Send private message
Sliderule
Super User
Super User


Joined: 29 May 2004
Posts: 2499
Location: 3rd Rock From The Sun

PostPosted: Tue Aug 19, 2008 10:40 pm    Post subject: Reply with quote

valmorel:

You asked:
valmorel wrote:
What is the essential difference between a VIEW as created from the table dialogue, and a QUERY please?

I would say . . . there are a few.
  1. A Query . . . is 'NOT' stored in the database itself. Rather, it is stored in the .odb file . . . but . . . NOT in the HSQL ( database ) part of the file.
  2. Therefore, a Query, may be changed at any point in time by the user, whereas, a VIEW ( a ' pseudo-table' -- it contains no data, merely instructions on how to get / retrieve data from another table or tables ) may not be 'changed'. A View may be 'deleted' and recreated, but the 'definition' of the View cannot be changed . . . at least . . . not as of this version of OpenOffice.
  3. Because a VIEW is part of the databaase engine . . . and . . . NOT a part of the OpenOffice system . . . this means, a Query may ( if the user decides ) include a Parameter Prompt . . . the part on the Criterion line, starting with a COLON ( : ) where the user is 'prompted' for one or more inputs.
  4. A View, which may include 'calcuations' ( unlike a table definition ), can be used by a Query, to combine ( join ) with other tables.
I hope this helps, and, is as clear as a foggy day in the Midlands. Surprised

Sliderule

- Edit -- changed this post ONLY to show the following:

Thanks to add [Solved] in your first post title (edit button) if your issue has been fixed / resolved.


Last edited by Sliderule on Wed Aug 20, 2008 9:17 am; edited 1 time in total
Back to top
View user's profile Send private message
valmorel
General User
General User


Joined: 15 Jul 2008
Posts: 35
Location: UK

PostPosted: Wed Aug 20, 2008 8:40 am    Post subject: Reply with quote

Thanks again Sliderule. I need to sit and digest this to see how I can use these differences to advantage
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