Leemi
Tue Sep 21 09:35:55 CDT 2004
Hi Cowboy:
I really cannot add much to Stefan's excellent answer. But is here a post
from FoxWiki that discussed views and SQL-SELECT commands that you might
find useful:
http://fox.wikis.com/wc.dll?Wiki~VfpViews~VFP
I hope this helps.
This posting is provided "AS IS" with no warranties, and confers no rights.
Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell
*-- VFP9 Public Beta Now Available!! --*
Download the VFP9 beta here:
http://msdn.microsoft.com/vfoxpro/
*-- VFP8 HAS ARRIVED!! --*
Read about all the new features of VFP8 here:
http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp
Purchase VFP8 here:
http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518
Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003
>Views are reusable SQL statements stored persisitently in the DBC
>and behave quite like tables. They can present multiple tables and
>contain calculated columns
>You can USE them, have "parameters" in the Where clause / filter.
>They can be read-only, or fully or partly updatable if you want.
>If the latter, you can TableUpdate() and TableRevert() them.
>When you use a view as grid.RecordSource, you don't need to care for
>"grid reconstruction", as you would have when using temporary cursors.
>The first paragraph also applies to query.qpr's, as produced by the
>Query Designer, but that's it and I think they are quite rarely used.
>hth
>-Stefan
>"Cowboy" <Cowboy@discussions.microsoft.com> schrieb im Newsbeitrag
>news:9FE58D97-20B5-49EE-B0B2-0BB03319E641@microsoft.com...
> Can anyone lead me to a discussion of views and query's. I don't fully
> understand the difference and when to use which in VFP 80
> --
> TIA
> Cowboy