Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DBF('MyCursor') gives uncorrect result?????
Message
From
04/04/2000 08:58:24
Mike Yearwood
Toronto, Ontario, Canada
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00354449
Message ID:
00354907
Views:
22
Hi Nadya

Don't create a remote view. Do File New: click View then click New File. You don't need a remote view unless you are using SQL Server or Oracle or Access.

>>set filter to MyFilterCondition
go top

It runs very slowly...<<

There has been a lot of discussion about GO TOP vs LOCATE. The LOCATE command without any clauses is what you should use after setting a filter. GO TOP doesn't optimize. Just add a comment in your code to explain to others why you used LOCATE.

>>I thought, that view could be more convenient and runs faster, but I haven't much experience with views.
<<

They are much more convenient. In this case, you should create a parameterized view. The second app will open the view (in whatever manner you prefer) and you will pass parameters to the second app for it to pull the records it needs.

Mike
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform