Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create and Updatable Cursor
Message
From
03/03/1998 09:02:19
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00082148
Message ID:
00082263
Views:
31
>How would you create an Updatable Cursor.
>
>My application need to create this temporary cursor, then change some data.
>
>Thank you,
>Marco


Select * from someTable;
Where .t.;
into cursor tmp

Noter: Use the .t. to assure you have a true cursor, and
not a pointer back to your master table.

In the debug window:
dbf(alias()) or dbf('tmp') - Will show where the cursor is comming from.

select 0
use dbf('tmp') again alias updCursor

Now you can perform any calculations on any field
in the 'updCursor'

I.E.
Replace all pcnt with (accepted/totsubmit)

Russ
Previous
Reply
Map
View

Click here to load this message in the networking platform