Re: [GENERAL] Catch multiple records when doing Select Into

2006-11-04 Thread SunWuKung
Hugh, that's a long way to do that. Thanks for the help. SWK Ketema wrote: > It would be easier if we could see the context in which you are doing > the select into. However I think this may help. Try putting the > select into in a loop: > > declare > _result record; > _rows integer; >

Re: [GENERAL] Catch multiple records when doing Select Into

2006-11-02 Thread Ketema
It would be easier if we could see the context in which you are doing the select into. However I think this may help. Try putting the select into in a loop: declare _result record; _rows integer; begin _rows := 0; for _result in select statement here loop in here p