RE: Problem w/SQL

[CWilt@xxxxxxxxxxxx]

No,

I do that all the time.


Ok, so the one you're using in the fetch is global.

Is it redefined anywhere else?

Basically, the precompiler treats all symbols as global.  If you have local
variables someplace else with the same name as the global you're trying to
use in the SQL it can cause this IIRC.

Charles

> -----Original Message-----
> From: mwalter@xxxxxxxxxxxxxxx [mailto:mwalter@xxxxxxxxxxxxxxx]
> Sent: Wednesday, July 28, 2004 9:03 AM
> To: RPG programming on the AS400 / iSeries
> Subject: RE: Problem w/SQL
> 
> 
> 
> I'm just thinking here. Is it because the cursor is declared 
> and opened  in
> one sub-procedure and the fetch is in another.
> 
> Thanks,
> 
> Mark
> 
> Mark D. Walter
> Senior Programmer/Analyst
> CCX, Inc.
> mwalter@xxxxxxxxxx
> http://www.ccxinc.com
> 
> 
> --
> 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.
>