Questions in VFP7OLEDBExampleVB sample

  • Thread starter Thread starter Bogdan Zamfir
  • Start date Start date
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select with Sybase OleDb provider 0
Problem with queries. Call for help. 3
Error message puzzle "da.Fill(ds, "Assets") " 2
Why ExecuteNonQuery() cannot execute UPDATE command 6
VB6 Component Issue with TDBGRID 0
Invalid Column Name Sql-Error :Executing a stored procedure 1
Error : External table is not in the expected format..???? 0
Cannot pass Null value for parameter ??? 3

Back
Top