Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remark to FAQ #541 (updateable cursor)
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Remark to FAQ #541 (updateable cursor)
Miscellaneous
Thread ID:
00250699
Message ID:
00250699
Views:
55
Hi Evan.

A remark to your advice to make a cursor updateable (FAQ #7830).

Usually a VFP cursor refers to a DBF in the temp directory. Using this DBF again won't lead to any problems.

If the cursor is the result of a SQL-SELECT which queried one table solely without the use of restraining clauses like DISTINCT or GROUP BY, it will refer to the source table of the query. So DBF("cCursor") delivers the full name of the table you queried, and to manipulate the cursor that was used again means to manipulate the original table.

That might get you in some trouble - at least it got me!

Check it out!
I've acquired quite a taste for a well-made mistake... [Fiona Apple]
Next
Reply
Map
View

Click here to load this message in the networking platform