Re: embedded sql, procedure, and report output

   Carel,

   Yes, in fact if I take all references to the output('O' specs and excepts)
   I can get the module to compile(and work correctly if you call a report
   module that does not create a report working correctly), and the section
   of code is almost identical to another program.  Thanks

   Carel Teijgeler wrote:

 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

   --

   Weyco Group -             
                             
       Florsheim, Brass Boot, Nunn Bush, Stacy Adams
   Duane Kehoe                       Phone # 414.908.1814 
   EC / Programmer / Analyst           Fax # 414.908.1601 
                             Email: dkehoe@xxxxxxxxxxxxxx