Hi Dorin,

Thanks for the helpful information!

Tracy

>Hi
>I'm using it and I don't have problems.
>There is a difference between calling a stored procedure with output parameters (selectable) and calling a stored procedure without output parameters (nonselectable).
>In first case is
>

>SQLEXEC(nHandle, [SELECT * FROM {my_sp(input_parameters)}])
>

>and in second case is
>

>SQLEXEC(nHandle, [EXECUTE PROCEDURE {my_sp(input_parameters)}])
>

>Also is perfectly valid to join rows returned by two selectable stored procedures.
>
>
>
>>Thanks! Have you been using it long with VFP? Any problems?
>>
>>
>>>Hi Tracy
>>>
>>>Try this driver:
>>>http://www.ibphoenix.com/downloads/SetupOdbcJdbcBeta2.exe
>>>
>>>This is the latest one that I know of.