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