Re: embedded sql, procedure, and report output

Duane,

Do you have the SQL functions in the right order (top to bottom in the source)? 

It should be: DECLARE, PREPARE, OPEN, FETCH, CLOSE (IIRC).

May have forgotten some.

Regards,
Carel Teijgeler 

*********** REPLY SEPARATOR  ***********

On 26-10-05 at 10:43 Duane Kehoe wrote:

>No this is not the main procedure, in fact this source has the 'H' spec of
>   NOMAIN.  I also have everything(except output, variable defs, and
>   procedure start/end) in free.  I should mention that if I remove all
>   references to the output I can get the procedure to compile.  Thanks
>
> Is this a main procedure?  If so the "C" specs have to come before the
> "O" specs.  The only time that "C" specs come after the "O" spec is when
> using internal procedures(not subroutines).