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 strongm 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
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

T
  • Locked
  • Question
long vs short filenames
2
Replies
20
Views
873
Joe Crescenzi
Joe Crescenzi
Steve Yu
  • Locked
  • Question
Data encryption at rest, VFP vs MS SQL 2
Replies
8
Views
289
Chris Miller
Chris Miller
AlastairP
  • Locked
  • Question
CHAR vs VARCHAR - no real difference size on disk 1
Replies
4
Views
193
AlastairP
AlastairP
wrgt9740
  • Locked
  • Question
I Don't Understand <>
Replies
15
Views
245
wrgt9740
wrgt9740
AlastairP
  • Locked
  • Question
data query speed difference with SET DELETED ON/OFF 1
Replies
8
Views
233
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top