Procedure does not return the entire column

Question

Procedure does not return the entire column

Navigation

#1 by (0 votes)

0

I created a procedure with ibexpert, does commit correctly, but at the time of running procedure , I get the error:

multiple rows in singleton select.

My intention is to list all the values in the city column of the target table. When I run select in a normal query , it returns all the values in the column, it just does not do the same in procedure , being same way.

The following is the code below:

create or alter procedure VER_TODOS_DEST  
returns (CIDADES char(20))  
as  
begin  
  select cidade from destino  
  into :cidades;  
  suspend;  
end

sql select firebird

asked by anonymous 01.12.2017 / 06:56

1 answer

I need to update my acces database (.mdb) from an external computer How to use Android.Hardware.Camera2 in Xamarin

score 0 · Answer 1

Within procedure or trigger the command select can only return 1 record.

To do what you want you need to use for select as below.

create or alter procedure VER_TODOS_DEST
returns (
    CIDADES char(20))
as
begin
  for
      select
          CIDADE
      from
          DESTINO
      into
          :CIDADES
  do
    suspend;
end