>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")
Your code doesn't tell much. Maybe it is better that you debug what happens at BeforeUpdate and AfterUpdate. And did you check with aerror()?