Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hi Shaheer,
What i normally do is: include the remote views at the data environment of my form, and change the BUFFERMODE property to 5 (table buffering) and change the NODATA property to true; you can do this by code, doing:
USE myView NODATA
CURSORSETPROP('Buffering', 5)
This way, my forms load very quickly, because no data is requested to the server. When my user click NEW i just do an APPEND to my view; when my user asks for a record and make a REQUERY to the view (since my views are "parametrized", it means, my WHERE clause has a condition -- in my case, i have the primary key).
Normally, i don't have junk at my views... i don't know if this philosophy is the best, but it's been working!
Hope it helps!
Say something,
Ricardo
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