Hi,
> Query Analyzer" perfectly.
> e.g.
> SP1: (works)
> CREATE PROCEDURE SP1 AS
> insert into mytable values(...)
> select * from mytable
Only one result set.
>
> SP2: (doesn't work)
> CREATE PROCEDURE SP2 AS
> select * from mytable
> select * from mytable
Two result sets
>
> SP3: (
I am almost crazy now after playing with these codes
over 10 hours.
I don't expect to call sybase_query() one by one for
executing sql batch. It just doesn't work for me like
what I said yesterday. Now I try to make a stored
procedure for these sql batch. So I can call
sybase_query() only once. B