B
Bogdan Zamfir
Hi all,
I try to run VFP7OLEDBExampleVB sample application on accessing VFP7 data
using OLE DB from ASP.NET app, and I have a problem.
Retriving data works OK, but the code give an error when try to update.
The error is in the line
Dim VFP7UpdateCommand As New OleDbCommand(strUpdateSelect, VFP7Connection)
' Execute the command
VFP7UpdateCommand.ExecuteNonQuery() ' <-------- Line with error
' Close the connection
VFP7Connection.Close()
And the error is "Cannot update cursor"
I checked the Update SQL statement, and it seems OK.
Does anyone have a clue about what is happening?
Thank you.
Bogdan
I try to run VFP7OLEDBExampleVB sample application on accessing VFP7 data
using OLE DB from ASP.NET app, and I have a problem.
Retriving data works OK, but the code give an error when try to update.
The error is in the line
Dim VFP7UpdateCommand As New OleDbCommand(strUpdateSelect, VFP7Connection)
' Execute the command
VFP7UpdateCommand.ExecuteNonQuery() ' <-------- Line with error
' Close the connection
VFP7Connection.Close()
And the error is "Cannot update cursor"
I checked the Update SQL statement, and it seems OK.
Does anyone have a clue about what is happening?
Thank you.
Bogdan