> Dear Exprets,
>
> I am trying to convert my account software from vfp/sql server 2000 to
> vfp/Oracle 10g express edition.
>
> I have created database on backend (oracle 10g express) and successfully
> connected to it. I sucessfully call the procedure from front end VFP 9.
>
> same way I created a function on oracle 10g express but unable to successfully
> call it from front end VFP 9. I am using the same as I use to call store Procedure.
>
> I have created following fuciton and connect through ODBC.
>
> create or replace function get_maincode(ac IN Varchar2,mt IN OUT Varchar2)
> return Varchar2 is
> begin
> select main_title into mt from chart
> where acc_code=ac;
> return mt;
> end;
>
> I call this function from vfp as below.
> sqlexec=consql,"(call get_maincode (?ac,?@mt)}"
>
> if I create procedure than it run successfully but not as function.
>
> function created successfully on oracle end.
>
> any tip??
>
> Regards,
> Abdul Aqeel
does it work in this way:

=sqlexec(consql,"select get_maincode(?ac,?@mt)","crsResult")

-----------------------------------------------------------------------------------------------
Regards
Surinder Singh
Email: sur200@indiatimes.com
Check my blog for details: http://weblogs.foxite.com/sur200
----------------------------------------------------------------------------------------
*Everything is possible but everything is not required to be happy..