General information
Category:
Forms & Form designer
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only