Bill,
I'm not actually creating a stored procedure through VFP...basically, I'd have a pre-defined stored procedure in SQL Server that would do something like the following...
SELECT * FROM InvoiceDetail ;
JOIN AccountList ON InvoiceDetail.Account = AccountList.Account ;
JOIN ItemList ON InvoiceDetail.Item = ItemList.Item
The 'issue' is that the contents of AccountList and ItemList is set at runtime as part of the report selection process. A user could select one account, ten accounts, or hundreds. Same deal on the item side. Basically what I'm trying to figure out is how to 'get' that list of accounts and items that the user has selected into SQL Server so that the stored procedure can query against it.
Someone else responded that the VFP front-end could append to a temporary table in SQL Server with the list of selected accounts/items, just prior to calling the stored procedure. That seems like it would make sense, although there could be dozens of users running reports at the same time, so I'd need to figure out how to build a temp table that's specific to each user, and have the SP know which temp table to use.
(It's probably obvious from my questions that I'm really struggling with the paradigm shift!)
Kevin