Wait. Ignore that. Darn it. I thought I finially had a useful answer.

>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