RE: Call Query

[Joel Fritz <JFritz@xxxxxxxxxxxxxxxx>]

Where's the GOTO? <g>

> -----Original Message-----
> From: Evan Harris [mailto:spanner@ihug.co.nz]
> Sent: Monday, October 23, 2000 10:55 PM
> To: RPG400-L@midrange.com
> Subject: Re: Call Query
> 
> 
> Dan
> 
> >Can't say I've seen a lot of list activity asking about 
> substringing numerics,
> >but I will opine here and say that if you have to substring a numeric
> >variable, then it shouldn't be a numeric variable.
> 
> I think Rob's referring to when you are trying to include numeric 
> comparison's in a QRYSLT string. I can recall seeing a few of 
> these float 
> through here and midrange-l.
> 
> All that substringing, concatenation and extra quote business 
> seems to 
> throw a few people. It made more sense to me after I unravelled the 
> mysteries of passing parameters into QMQRY (now there's a way 
> to get claw 
> marks on your head).
> 
> Perhaps a good idea would be to write a front-end RPG to pass a 
> pre-formatted string into a CL that would use OPNQRYF to 
> output the data 
> into a pre-formatted work file. Then it would be a simple matter of 
> formatting the report using Query.
> 
> To improve things even further you could output to a 
> multi-member file and 
> pass the member into the queries file name prompt. This would 
> allow many 
> users to run their queries at the same time.
> 
> Of course for the front-end RPG you'd have to create a 
> command so that the 
> numeric variables didn't fail due to not being passed 
> correctly on the 
> command line.
> 
> Let's see - CMD, RPG, CL, Query..... Nah, I think I'll just 
> write a report 
> in RPG using O-Specs and a do-until loop.......
> 
> :)
> 
> Cheers
> Evan Harris
> 
> P.S.I had one of those days too - this has helped
> 
> 
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---