Are you sure that the connection handle in use is 1? Try getting it from the cursorsetprop and making sure you are using the correct connection handle.

>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