Subject | RE: [ib-support] SP returning result sets? |
---|---|
Author | Doug Chamberlin |
Post date | 2001-11-22T03:21:12Z |
Paulo Gaspar wrote:
FOR...SELECT...INTO...DO...SUSPEND so I take it that he finds this syntax
burdensome and thinks that it should simply be SELECT * FROM someTable
WHERE someCondition...;
Sorry, but I don't buy it. If that's all that the complaint is then I'm
dismissing it as noise.
>What I really miss is being able to return result sets ( = a set ofTo which I replied:
>rows = the result of some SELECT) from inside a Stored Proc.
> Maybe I don't understand the details of what you are suggesting but I selectTo which Paulo replied:
> result sets provided from stored procedures all the time in Interbase!
> I meant a la SQL Server, which is a bit simpler.I replied:
> Which means what, exactly? I don't know SQL server very well. How is itPaulo replied:
> simpler?
> For context take a look at my previous posting. But basically it meansthat doing:
> SELECT * FROM someTable WHERE someCondition...;From other postings I see that Paulo knows about
> will return a resultset.
FOR...SELECT...INTO...DO...SUSPEND so I take it that he finds this syntax
burdensome and thinks that it should simply be SELECT * FROM someTable
WHERE someCondition...;
Sorry, but I don't buy it. If that's all that the complaint is then I'm
dismissing it as noise.