Michael,
From your sample code it looks like you're only setting the key field as updatable but you're not setting any field as the key. You probably need to set the key field as updatable and the key and all the other fields as updatable.
If that doesn't do it, after TABLEUPDATE() returns .F., use AERROR() to check the error returned. That might help you narrow down the problem.
>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