Thanks for your help. I'll give your suggestions a try and see if they work. If I need more help I'll be back.
-cjh
>My guess here is that you are looking for a way to capture the value of Output Parameters. Consider this stored proc:
>
>CREATE PROCEDURE CustOrderHist @CustomerID nchar(5), @numberofrows integer OUTPUT
>AS
>Declare @retval bit
>SELECT ProductName, Total=SUM(Quantity)
>FROM Products P, [Order Details] OD, Orders O, Customers C
>WHERE C.CustomerID = @CustomerID
>AND C.CustomerID = O.CustomerID AND
> O.OrderID = OD.OrderID AND
> OD.ProductID = P.ProductID
>GROUP BY ProductName
>Set @numberofrows = @@RowCount
>If @numberofrows > 0 Set @retval = 1
>
>Return @retval
>
>
>The following VFP code not only gets the return value, but the value of the Output Parameter as well:
>
>mVar = 0
>SQLExec(nhandle,"{CALL CustOrderHist ('ALFKI',?@mvar)}",'test') > 0
>?mVar && the number of rows returned by the Output Parameter...
-cjh