Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View with a Running Total
Message
From
07/12/2003 10:31:39
 
 
To
07/12/2003 09:22:29
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00856515
Message ID:
00856696
Views:
17
> I was unable to create a Readwrite cursor- Is it because I'm using VFP 6?

Yes, the READWRITE modifier was introduced in VFP7. It is a great help - in earlier versions we had to jump through a quite few hoops to achieve a similar effect.

The easiest workaround for VFP6 is to re-use the temporary DBF underlying the cursor in a different work area:
use dbf([QueryResult]) shared again alias UpdatableAlias in select([UpdatableAlias])
but in that case it is vitally important to add the NOFILTER modifier to the original SELECT statement.

If the NOFILTER is missing then Fox could give you a filtered view of the original data instead of creating a temporary DBF. The danger is only with certain types of queries but it is a good idea to add NOFILTER whenever you intend to modify the result cursor.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform