SELECT LEFT(SUBSTR(Inventory.p_descript,1,AT("$",Inventory.p_descript,2)+8),50) AS memotxt, Inventory.item_status,;
Inventory.trans_id, Inventory.stocknum;
FROM tomparco!inventory ;
INTO CURSOR trans_items ;
WHERE Inventory.trans_id = trans_num ;
ORDER BY Inventory.stocknumbrow
use dbf('trans_items') again in 0 alias myupdatableview
use in trans_items
Happy Updating of: "myupdatableview" !!!
Note there may or not be a link back to the original table. Test this as VFP does something funky if the original query returns all rows from the original table. I that case is seems to skip actually making a cursor and the changes in myupdatableview are automatically reflected back into the original table; if you retrieved a subset of the rows in tomparco!inventory you will have to post the changes to myupdatableview back into tomparco!inventory yourself.
Robert Baker
>This is my view:
>
>SELECT LEFT(SUBSTR(Inventory.p_descript,1,AT("$",Inventory.p_descript,2)+8),50) AS memotxt, Inventory.item_status,;
> Inventory.trans_id, Inventory.stocknum;
> FROM tomparco!inventory ;
> INTO CURSOR trans_items ;
> WHERE Inventory.trans_id = trans_num ;
> ORDER BY Inventory.stocknum
>
>when I try to change a value in it, "the record is readonly" shows up in my taskbar msg.
>
>I remember using the View Designer, there is a checkbox for 'SendUpdates'. Is there a property for a cursor or view like the one above that I might be able to adjust? Should it be done programmatically?
>
>Thanks
>JD
Robert - Zxytek