>>Hi all,
>>wanting using store procedure, the code:
>>

>>=sqlexec(nhandle,'myprocedure')
>>

>>do not work. The .dbc is open. I saw the VFP examples and I do not understand why: launching the same procedure (do myprocedure) from the command window it works.
>>Any idea?
>>Thanx in advance
>
>try
>
>

>=sqlexec(nhandle,'myprocedure()')
>

I do not understand why the statement:

select myprocedure() from anytable where 1=0

or

myprocedure()

work fine from the command window, instead this:

?sqlexec(nhandle,'select myprocedure() from anytable where 1=0')

do not work. The nhandle is correct, because

?sqlexec(nhandle,'select anyfield from mytable','anycursor')

does the job.