Re: AW: embedded sql session error in subfile

Those were ok, the only different was I hardcoded them in the interactive 
versus the returned values from the dspf.  They are coming across 
correctly.  I was able to determine the major problem and have I think fixed 
it....then another two problems surfaced which I am fixing now.


On Wed, 27 Jul 2005 10:42:25 -0400, Paul Morgan wrote
> Douglas,
> 
> What's different between the interactive and RPG version?  You 
> didn't use start and end date variables in the interactive version.  
> Have you checked the value and format of your STARTDATE and ENDDATE 
> program variables?  Maybe they don't contain what the SQL statement 
> requires for execution.
> 
> Paul
> 
> -- 
> Paul Morgan
> Senior Programmer Analyst - Retail
> J. Jill Group
> 100 Birch Pond Drive, PO Box 2009
> Tilton, NH 03276-2009
> Phone: (603) 266-2117
> Fax:   (603) 266-2333
> 
> Douglas wrote
> 
> > I used the exact same select statement in the interactive as I had in the
> > program and it ran ok....
> >
> > I know its going to be something very simple that I am screwing up....
> >
> > Douglas
> 
> -- 
> 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.


If you bought, it was hauled by a truck - somewhere, sometime.