>>>Is there a way to execute a procedure from within a SQL select?
>>>Such as this sample:
>>>
>>>
>>>
>>>select
>>>name,
>>>(exec dbo.GetAccountBalance customer.AccountNumber) as AccountBalance
>>>From customer
>>>
>>>
>>
>> Mike why not,
>>
>>what_you_want = ...
>>SQLEXEC(sqlHandler,[EXEC your_sp @first_param]= what_you_want,[sql_cursor])
>>In your Stored Procedure
>>
>>SELECT name,....
>>from...
>>...
>
>this is a SQL procedure not VFP
Yes, I know and You ??? You can prepare the cursor in SQL Stored Procedure and retrieve in VFP.
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst