We are working on a foxpro class that let access to a postgreSQL database. We are using cursoradapter, but i have problems when updating data on a selected record. It seems all is workin but when i update data these are not updated and i have no error messages...

If i make the same operation using a database with a remote view on the same tables i have no problems and data are updated...

What did i miss in the cursor adapter ? What can i check ?

Here is the code:

loData = Createobject("DbMngr.DbData")
loData.DataSource = loHandle.Handle
loAnag = loData.CaAnag
loAnag.DataSource = loHandle.Handle

loAnag.SelectCmd = loAnag.SelectCmd + " Where Id = ?loRecord.Id "
loAnag.CursorFill()
loAnag.CursorRefresh()
Gather Name loRecord
=TableUpdate(.T.,.T.,"crAnag")