Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Don't understand Query vs View

Status
Not open for further replies.
robmoors

robmoors

Programmer
Jan 10, 2001
24
0
0
Can someone please tell me the difference between a query and a view?
 
Sort by date Sort by votes
Basically Queries are read only (but can be change to read/write with a lot of work). Views are read/write.
 
Upvote 0 Downvote
To add to the first answer, Queries (updatable or not) are disconnected from the original data - changes (when possible) are only reflected in the resultant cursor/table/array. Views on the other hand, if any or all fields are defined to be updatable, and that data is changed in the view, then the original table(s) are updated.

Rick
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Steve Yu
  • Locked
  • Question
Data encryption at rest, VFP vs MS SQL 2
Replies
8
Views
170
Chris Miller
Chris Miller
AlastairP
  • Locked
  • Question
CHAR vs VARCHAR - no real difference size on disk 1
Replies
4
Views
100
AlastairP
AlastairP
wrgt9740
  • Locked
  • Question
I Don't Understand <>
Replies
15
Views
127
wrgt9740
wrgt9740
AlastairP
  • Locked
  • Question
data query speed difference with SET DELETED ON/OFF 1
Replies
8
Views
147
Chris Miller
Chris Miller
A_Radiolog_inFoxPro
  • Locked
  • Question
How to check that my query is empty ? or not empty ? 4
2
Replies
26
Views
301
TamarGranor
TamarGranor

Part and Inventory Search

Sponsor

Back
Top