Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to make a cursor updateable ?
Message
From
20/02/2001 15:32:36
 
 
To
20/02/2001 15:15:49
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00477642
Message ID:
00477759
Views:
23
>
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform