To all,
I'm experiencing a TABLEUPDATE problem and I need a little help. I've looked at this problem for two days and need to move on. Background:
Remote View:
CREATE SQL VIEW vwPendingApprovals;
REMOTE ;
CONNECTION CONVERCONN ;
SHARED ;
AS SELECT * FROM APPROVALS ;
WHERE 1 = 2
BUFFERING and other PROPERTIES:
= DBSETPROP( 'vwPendingApprovals', 'VIEW', 'WhereType', 3 )
= DBSETPROP( 'vwPendingApprovals', 'VIEW', 'SendUpdates', .T. )
= DBSETPROP( 'vwPendingApprovals.cpkeyid', 'FIELD', 'Updatable', .T. )
= DBSETPROP( 'vwPendingApprovals.dsubmitted','FIELD', 'DataType', 'D')
= DBSETPROP( 'vwPendingApprovals.ddoapprove','FIELD', 'DataType', 'D')
= DBSETPROP( 'vwPendingApprovals.droapprove','FIELD', 'DataType', 'D')
= DBSETPROP( 'vwPendingApprovals.dnoapprove','FIELD', 'DataType', 'D')
= DBSETPROP( 'vwPendingApprovals.dapproved','FIELD', 'DataType', 'D')
llRetVal=CURSORSETPROP( "Buffering", 5, 'vwPendingApprovals' )
Add data via:
INSERT INTO vwPendingApprovals FROM MEMVAR
TABLEUPDATE command:
llTableUpdateOk = TABLEUPDATE( 1, .F., "vwPendingApprovals", laError )
I consistently get a FALSE returned!!
I have changed the INSERT INTO to an APPEND BLANK and REPLACE, but to no change.
WHAT AM I DOING WRONG HERE? IS THIS A VFP BUG?
Michael Haggerty
amkhag@erols.com
haggertym@bluemt.com
haggertm@pwba.dol.gov