Re: embedded sql, procedure, and report output

   Thanks Scott,

   I had moved things around so much today "trying things" that my code was
   messed up.  I do in fact have everything global.  I also just received
   this message:

   Gina M Whitney wrote:

 Duane,
  Put a blank C spec line before you start your O specs.

         Fprt198    o    F  198        PRINTER OFLIND(*INOF) usropn
          **********************************
          * Procedure Prototypes Copy Book *
          **********************************
          /include rtlavgftpr
          **********************************
          * Output Specs for Detail Report *
          **********************************
         C
         Oprt198    e            heading     3



   tried the suggestion and guess what?  It worked, why I do not really
   understand but at least it worked and I can now test.  Thanks for your
   help, much appreciated.

   Scott Klement wrote:

         Thanks and sure Scott the section of code in question is
       below(ignore
         formatting issues caused by copy/paste).

     I glanced over your code, and nothing jumped out at me that would cause
     an error about the statements being out of sequence.

     Is it possible that the error is in the /include member?

     There were two other things that did jump out at me, however:

     a) You're setting *INLR in a NOMAIN module. (which won't have any
     effect, and may serve to confuse someone later)

     b) You have fields that are defined in a subprocedure, but you're
     attempting to use them in your output specs. Since O-specs are global,
     fields that are in them also have to be global.

     But, again, I don't see why this would cause an error about the
     statements being out of sequence.

   --

   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