Commented by: fulvio (fulvio)

this is the image of results

Commented by: @asfernandes

The behavior of using the same variable as both input and output in the same command is undefined AFAIK.

Commented by: @dyemanov

Correct, it's dictated by the FB internals and thus can be considered "as designed". However, AFAIU it doesn't comply with the SQL specification. So I'm not sure what is better: close this ticket as "won't fix" or just downgrade its priority and keep it open until it's fixed some day.

Commented by: @hvlad

This is how it works from the day one.
I vote for closing this ticket with "won't fix" and, probably creating new feature request.

PS EMS, IBE, etc "debuggers" is just emulators, they can't work exactly same way as Firebird

Commented by: fulvio (fulvio)

and now, how to resolve this problem?

Commented by: @hvlad

Don't use the same variable as both input and output in the same command

Commented by: @dyemanov

temp_idarticolo = out_idarticolo;

for select
:out_id,
distintabase.idarticolo,
distintabase.idarticolodistinta
from distintabase where
distintabase.idarticolo=:temp_idarticolo
into
:out_idpadre,
:out_idarticolopadre,
:out_idarticolo

Commented by: fulvio (fulvio)

hi,

I've insert a tmp variable
I Don't use the same variable as both input and output in the same command

the result is always the same....

can you tell me whot is wrong?
can you help me?

thanks

CREATE PROCEDURE ARTICOLIFIGLI (
idarticoloin integer)
returns (
out_idarticolopadre integer,
out_idarticolo integer)
as
declare variable temp_idarticolo integer;
begin
/* Procedure Text */

for select
distintabase\.idarticolo,
distintabase\.idarticolodistinta
from distintabase where
distintabase\.idarticolo=:idarticoloin
into
out\_idarticolopadre,
out\_idarticolo
do
 begin
  temp\_idarticolo = out\_idarticolo;
  suspend;

    for select
    distintabase\.idarticolo,
    distintabase\.idarticolodistinta
    from distintabase where
    distintabase\.idarticolo=:temp\_idarticolo
    into
    out\_idarticolopadre,
    out\_idarticolo
    do
     begin
      temp\_idarticolo = out\_idarticolo;
      suspend;

        for select
        distintabase\.idarticolo,
        distintabase\.idarticolodistinta
        from distintabase where
        distintabase\.idarticolo=:temp\_idarticolo
        into
        out\_idarticolopadre,
        out\_idarticolo
        do
         begin
          temp\_idarticolo = out\_idarticolo;
          suspend;

            for select
            distintabase\.idarticolo,
            distintabase\.idarticolodistinta
            from distintabase where
            distintabase\.idarticolo=:temp\_idarticolo
            order by distintabase\.idarticolodistinta
            into
            out\_idarticolopadre,
            out\_idarticolo
            do
             begin
              suspend;
            end
         end

     end

 end

end

Commented by: @asfernandes

You used same variable in different nesting commands. When evaluating the outer ones, the variable will have changed and will be compared with something you assigned in the inner loops.

Please move this to support list, as the tracker is not for this.