Hi Cindy,
I think it's the same but I don't know much about .NET either.
>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?"
--sb--