General information
Category:
Coding, syntax & commands
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only