Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Obtaining row count of select
Message
De
20/06/2003 11:26:29
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00802220
Message ID:
00802235
Vues:
23
Wayne,

< update...just saw you are using SQLEXEC...>

I was going to suggest _tally...

>I am new to client/server stuff so I am trying to learn on the fly. So am asking questions that are probably no-brainers to many of you. After you run a pass through "Select" query using SQLEXEC creating a result cursor, what is the best way to obtain the number of records selected from the Server immediately afterwards. I know there is a SQL Server function called "SQLRowCount" but I don't know how to access it from VFP 7. I know I could do a Reccount() on the cursor created by my select statement but I am looking for alternative methods.
>
>How do you run functions and obtain the values of variables only available on the SQL server side and not native to VFP anyways? I only figured out how to access the tables & run SQL queries against them as of now.
>
>I want to use VFP and not ASP or PHP
Steve Gibson
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform