stored procedures

[samantha72]

Hi again,

Thanks for all the replies. Tim said to call a stored procedure using the exec which
works fine as far as compiling is concerned but i am still not getting the results i want
this is what i need

name type desc
aaa 0 aaa
bb 1 bbb
cc 0 ccc

I need it to be displayed like this
aaa form aaa
bb memo bbb
cc form ccc
I did one stored procedure which does the first and another which does the second separately and then i called the second store procedure inside the first but i am still
getting the first one's results only.

how do i do this since my grid in vb is bound i cannot even manually change it there.

please help

thanks
samantha

 

[vechalapu]

Hi,
Comment the sql in the first procedure which generates the first output if it is not required. From my experience if you are calling second procedure in the first one, you should see both result sets.