Mike Yearwood
Toronto, Ontario, Canada
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement