Hi Carlos,

Do you check return value from REQUERY? Does it report any error? What is it?

How do you set CursorAdapter(s) properties? Do you use Prepared=.T. for any CursorAdapter object or remote view which use that connection?

Do you call SQLPREPARE() for that connection anywhere in your code?

It sounds like you are able to reproduce the problem pretty consistently, could you provide a repro code?

Thanks,
Aleksey.


>Hi Aleksey
>
>Thanks for your answer. The problem is exactly the following:
>
>When I create parametrizised cursor in ODBC like my remote views:
>Select * from customers where ID like ?thisform.lcID
>
>requery works fine with your own connection, but when I share the connection with DE, I have to use cursorfill(), becuase requery doesn´t work.
>
>I download VFP8 SP1 and installed but the problem persits.
>
>Do you have another idea?.
>
>Thanks for your time.
>
>Carlos
>
>
>>Hi Carlos,
>
>>VFP8 SP1 resolves some issues with REQUERY() function, have you tried it? Do >you still see the problem? Could you provide more details about it?
>
>>Thanks,
>>Aleksey.
>
>
>
>>Hi everyone
>>
>>I´m working with cursoradapter to replace my remote views. But the requery seems not work properly, sometimes does sometimes doesn´t, so I replaced it with cursorfill and it works fine.
>>
>>Some body knows why?, the solution is not a problem for my, but is more easy to me write:
>>
>>select
>>customer
>>requery()
>>
>>than :
>>
>>thisform.dataenvironment,cursoradapter1.cursorfill()
>>
>>because the dataenvironment intellisense doesn´t work in the form.
>>If I would have intellisense it would be easy.
>>
>>Do you have a sussgestion?
>>
>>Thanks
>>
>>Carlos