Hi

I'm looking to parse a unique ID into an SQL stored procedure, then return the number of records that match that criteria. On my SQL server I have the following stored procedure:

CREATE Procedure [ApplicationUserFind(Primary)]
@UserID numeric
Output as select * from [ApplicationUser] where [User_ID] = @UserID
GO

What would the command be from VFP to parse the user ID into the stored procedure, then return the number of records (or a dataset thereof)? I can create the SQL connection handle fine, it's the syntax of SQLExec() that I'm interested in.

Regards

Derek