General information
Category:
Coding, syntax & commands
Title:
Make a cursor updatable
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"
DBSETPROP('inv_this_trans','view','tables','Tomparco!inventory')
DBSETPROP('inv_this_trans','view','SendUpdates','Tomparco!inventory')
DBSETPROP('inv_this_trans.stocknum','field','keyfield',.T.)
DBSETPROP('inv_this_trans.stocknum','field','updatename','inventory.memotxt')
DBSETPROP('inv_this_trans.stocknum','field','updatable',.T.)
if I run the following instead, I get the error "Property invalid for table cursors" on sendupdates
CURSORSETPROP('sendupdates',.T.,'inv_this_trans')
CURSORSETPROP('keyfieldlist','stocknum','inv_this_trans')
CURSORSETPROP('tables','Tomparco!inventory','inv_this_trans')
CURSORSETPROP('updatenamelist','memotxt','inv_this_trans')
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
APPEND BLANK IN inv_this_trans
Because of the errors, I'm wondering if I should be using DBSETPROP() or CURSORSETPROP(), and just what I need to do to make this select updatable? All advice is welcomed.
Thanks
JD
Next
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