Hi Sergy,

I'm glad you found that - I didn't put the right combination of words in the search box to bring it up. It appears that the USE TableName is key here.

The problem is I don't know .NET well enough to be sure how an "updatable rowset on the server side" compares to a "server side cursor."


>I don't work with .Net but there's sample code in VFP8 help file under "Accessing Visual FoxPro Data in Visual Studio .NET" that shows how to use server side cursor.

.....
>*!* Updatable server cursors must use the USE <table name> command to
>*!* open the table, not a SELECT statement. Server cursor is updatable,
>*!* opened keyset, and lock optimistic......

>
>>I found this question about the new OLE DB data provider in a .NET newsgroup. Can anyone help me answer it?
>>
>>"It seems to that the provider doesn't support updateable rowsets at the server side. Why doesn't this provider support updateable rowsets at the server side?"