Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Obtaining row count of select
Message
From
20/06/2003 11:26:29
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00802220
Message ID:
00802235
Views:
22
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform