Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remark to FAQ #541 (updateable cursor)
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Remark to FAQ #541 (updateable cursor)
Divers
Thread ID:
00250699
Message ID:
00250699
Vues:
56
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]
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform