General information
Category:
Coding, syntax & commands
>I'm running a select that I need to be updatable. This is the code:
>
>
>SELECT inventory.stocknum AS stocknum;
>FROM Tomparco!inventory AS inv_this_trans;
>INTO CURSOR inv_this_trans;
>WHERE inv_this_trans.trans_id = trans_num; &&trans_num is a variable
>ORDER BY inv_this_trans.stocknum
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>if I run the following, I get the error "cannot update the cursor"
>
Hi. You can't to make SQL SELECT cursor updatable..
Solution.
1) Use updatable Local view
2) SELECT .... ;
INTO TABLE c:\mytable.dbf
Select will create updatable vfp table. But you can't update base data source without custom code.
3) Wait for VFP7. I hear updatable cursors will standart feature for VFP7 ;)
Denis
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