Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Activate fetching without a view or cursor
Versions des environnements
Hi all,
I have a sqldatabase with tables that are containing a large amount of information. Via my vfp7 program i manage this data. Now i have the following problem:
i want to query the big tables without downloading the hole result, yes i want to activat 'FetchAsNeeded'. The problem is that i don't have any views in my dbc and i want to keep it like this. In other words i work via sqlpassthrough.
I know i can activate fetching on a view via cursorsetprop('FetchAsNeeded',cTableAlias) but like a say i don't have any table or view in my container.
Is it possible to activate fetching on whatever sqlresult i get using sqlpassthrough. Can i tell to my connectionhandle that i want to fetch for ex by 100 records ?
Thnx
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