General information
Title:
Problem with cursoradapter
Environment versions
Network:
Windows Server 2012 R2
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")
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only