Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Page frame and free tables
Message
From
31/10/2002 17:39:58
Irv Adams
MSC Managed Care, Inc.
Florida, United States
 
 
To
31/10/2002 15:10:22
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00716909
Message ID:
00717603
Views:
13
Agreed..and when you use a View the name (the Alias() ) will probably remain static...I had a case today where I used a Cursor to populate a Grid and added a column on the fly...the column added (although it had no ControlSource at all) came out as Readonly, which was perhaps because a Cursor is a readonly object...then I changed the Cursor to a temporary Table and the added column was ReadWrite...go figure...

The point is, I think Fox is doing things for us behind the scenes with Cursors vs. tables, that sometimes makes it more advantageous to use temporary Tables (unless you have Fox 7 and use the 'ReadWrite' option for Cursors...)

Just Rambling...

-Irv.

>Irv,
>
>That sounds pretty close to me. For instance, if you were to execute a select statement into a cursor, VFP will assign a unique filename each time the select statement is executed. If you were to instead use the requery() on a view, the same filename is probably used (guessing, but 80% certain). In the case of the view, it is probably simply emptied and refilled with new data (kinda like a ZAP with an append from...) Using a view to populate the grid instead of a simple cursor, would prove to be a better approach because refreshing is almost automatic.
>
>
>Gordon.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform