valmorel
General User
Joined: 15 Jul 2008
Posts: 35
Location: UK
|
 Posted: Tue Aug 19, 2008 10:00 pm Post subject: View?Query?[solved] |
 |
|
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 |
|
Sliderule
Super User
Joined: 29 May 2004
Posts: 2474
Location: 3rd Rock From The Sun
|
| Posted: Tue Aug 19, 2008 10:40 pm Post subject: |
|
|
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.
- 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.
- 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.
- 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.
- 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. 
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 |
|
