Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to make a cursor updateable ?
Message
De
20/02/2001 15:32:36
 
 
À
20/02/2001 15:15:49
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00477642
Message ID:
00477759
Vues:
22
>
>In 5 or 6, if you do it the 'use again' way, does the temp table created by use again get cleaned up, disappear, when the cursor closes, i would think so/hope so.

Yes it does.

BTW, I make cursor updatable a lot and got tired of retyping these commands.

So I wrote the following tiny utility:
**cursupdt.prg
**Reused the current alias again with the same name. If done to a cursor
**created with the noFILTER command makes updatable
* Just select the workarea of the cursor you want to be updateable,
* and then issue the command "cursupdt()" or "Do cursupdt"
LOCAL lc_alias,lc_old_alias
lc_old_alias=ALIAS()
lc_alias=SYS(2015)
USE DBF() AGAIN IN 0 ALIAS (lc_alias)
USE IN (lc_old_alias)
SELECT (lc_alias)
USE DBF() AGAIN IN 0 ALIAS (lc_old_alias)
USE IN (lc_alias)
SELECT (lc_old_alias)
RETURN .T.
Thanks

Gar W. Lipow
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform