Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursoradapter and requery()
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00725734
Message ID:
00726005
Views:
15
CursorRefresh does not call CursorFill. AFAIK, there really is only one major difference between what these 2 methods do. The CursorFill creates the cursor schema AND retrieves the data. CursorRefresh just requeries the source without rebuilding the cursor schema. The problem in the bata, in specific instances, is if your SelectCmd looks something like:

select * from customers where cust_id = ?cCust_ID

and you change the value of cCust_ID before you call the CursorRefresh, cCust_ID is NOT re-evaluated by the CursorAdapter so you only get back the data for the first cCust_ID specified.

I am doing some more digging on this so hang in there and I will get back to you on this. When the final release comes out in first quarter of next year, all this should be working as advertised.

>Hi Mark,
>probably I've used the wrong verb (my english)... what I meant to say was:
>"how CAN it works" (not how does it)
>If CursorRefresh doesn't work but Requery() does,
>Requery() must use different "mechanism" than CursorRefresh to retrive data
>This is a curios thing, isn't it?
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform