How to get the total record in SQL table

[dickylam]

I am using SQL Server database
I am using also ADO as basic connection, update...etc actions

however, in ADO propertites, a recordcount is used to show the total number of records in that table, but this is long variable type, in VFP, how to create such type of variable and hold this result.

Thanks

 

[frebev]

Maybe I don't understand your question in full but if you want to count only specific records, use

count to x for fieldname="what you want to lookup in fieldname"

If you want to count the number of record in a table:
x= recco()

success and regards,

wilfredo

 

[1oldfoxman]

FoxPro does not allow for declaring variable types explicitly (at least through v6), but rather assigns data type implicitly based on the first value assigned to the variable at it's creation. frebev's code above will create a numberic type variable with the record count as it's value.

I, too, am not exactly sure what you are asking for, however.