>Alejandro,
>
>It might be best to run the GENDBC program on your view, then take a peek at the code that is generated for the view definition. If you need help interpreting the results, post the snippet of the resultant program here and we'll help you sort things out.
>

The snippet is pretty long. Not wishing to impose on the kindness of all here, I'm posting something that I think is typical about the view in question. If you need more I will be glad to add.

FUNCTION MakeView_V_PLSIS
***************** View setup for V_PLSIS ***************

CREATE SQL VIEW "V_PLSIS" ; 
   REMOTE CONNECT "coneccion" ; 
   AS SELECT *     FROM dbo.plsis

DBSetProp('V_PLSIS', 'View', 'UpdateType', 1)
DBSetProp('V_PLSIS', 'View', 'WhereType', 1)
DBSetProp('V_PLSIS', 'View', 'FetchMemo', .T.)
DBSetProp('V_PLSIS', 'View', 'SendUpdates', .T.)
DBSetProp('V_PLSIS', 'View', 'UseMemoSize', 255)
DBSetProp('V_PLSIS', 'View', 'FetchSize', 100)
DBSetProp('V_PLSIS', 'View', 'MaxRecords', -1)
DBSetProp('V_PLSIS', 'View', 'Tables', 'PLSIS')
DBSetProp('V_PLSIS', 'View', 'Prepared', .F.)
DBSetProp('V_PLSIS', 'View', 'CompareMemo', .T.)
DBSetProp('V_PLSIS', 'View', 'FetchAsNeeded', .F.)
DBSetProp('V_PLSIS', 'View', 'FetchSize', 100)
DBSetProp('V_PLSIS', 'View', 'Comment', "")
DBSetProp('V_PLSIS', 'View', 'BatchUpdateCount', 1)
DBSetProp('V_PLSIS', 'View', 'ShareConnection', .F.)

*!* Field Level Properties for V_PLSIS -- ALEX: This is the primary key.  It is an identity column.
* Props for the V_PLSIS.id_plsis field.
DBSetProp('V_PLSIS.id_plsis', 'Field', 'KeyField', .T.)
DBSetProp('V_PLSIS.id_plsis', 'Field', 'Updatable', .F.)
DBSetProp('V_PLSIS.id_plsis', 'Field', 'UpdateName', 'dbo.plsis.id_plsis')
DBSetProp('V_PLSIS.id_plsis', 'Field', 'DataType', "I")
* Props for the V_PLSIS.npla field. -- ALEZ: This is a typical updateable field
DBSetProp('V_PLSIS.npla', 'Field', 'KeyField', .F.)
DBSetProp('V_PLSIS.npla', 'Field', 'Updatable', .T.)
DBSetProp('V_PLSIS.npla', 'Field', 'UpdateName', 'PLSIS.NPLA')
DBSetProp('V_PLSIS.npla', 'Field', 'DataType', "N(8,0)")

Thanks,

Alex


>>I have a remote view to a table with only one record with row buffering. I do a GATHER MEMVAR and then REPLACE a few fields followed by TABLEUPDATE(.T.,.T.) buth the base table doesn't seem to be updated.
>>
>>I have set send updates =.T., sql where to primary key only (table has a primary key), and set update using sql update.
>>
>>What am I doing wrong?
>>
>>TIA,
>>
>>Alex