RE: SQL in free form work-around (was: Free form code suggestion )

["Chevalier, Rick" <Rick.Chevalier@xxxxxxxxxxxxxxx>]

I have been following this discussion with some interest as I do the same
thing with subroutines.  I decided to try the procedure method on my current
project and there are no problems compiling but trying to debug has been a
disaster.  Whenever the program gets to an SQL statement it skips way down
in the source then comes back.  It's like I have the source before the
pre-compiler did any work.  How do you get around this?

Rick

-----Original Message-----
From: Mackie, Roger L. (Precision Press) [mailto:RLMackie@xxxxxxxxxxxxx]
Sent: Thursday, July 10, 2003 2:27 PM
To: 'RPG programming on the AS400 / iSeries'
Subject: RE: SQL in free form work-around (was: Free form code suggestion )

Eric,

I seem to remember that, too. That's why I put the subprocedures in the
order I did. So far no worries in testing. If no bugs spoil the ointment, it
won't remove but might relieve the PITA somewhat. At least we won't be
stumbling over unnecessary tags.

Thanks,
Roger Mackie


-----Original Message-----
From: DeLong, Eric [mailto:EDeLong@xxxxxxxxxxxxxxx]
Sent: Thursday, July 10, 2003 14:10
To: 'RPG programming on the AS400 / iSeries'
Subject: RE: SQL in free form work-around (was: Free form code
suggestion )
<snip>

...as I recall, the problem was that you must keep the procedures
in a specific order within your source member so the pre-compiler would not
think that you're running the fetches before the declare cursor, and so on.
It was idiotic stuff like this that makes SQL and ILE a PITA.
<snip>
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.