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.stocknumCursors created with a SELECT ... INTO CURSOR are not updatable.
If the cursor doesn't have too many records,immediately after you can do this, though:
AFIELDS(laFields)
CREATE CURSOR cu_updatable_trans_items FROM ARRAY laFields
APPEND FROM (DBF("trans_items"))
Otherwise, you can create a view in the database for this.
HTH
Insanity: Doing the same thing over and over and expecting different results.