RE: [EXTERNAL] records between two dates

Typos – bad field names, transposed characters.

Proof of concept? … everything you have written should work – so if it isn’t working then you have some bad code somewhere.

SQL works fine. QRY works fine.



From: jerry ven <jerryven95@xxxxxxxxx>
Sent: Friday, July 1, 2022 2:33 PM
To: Therrien, Paul <ptherrien@xxxxxxxxxxx>
Cc: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: [EXTERNAL] records between two dates

Hi,

But how would it make a difference? I just want to make a proof of concept for this. How does it matter whether the field name is field1 or 'x','y' 'z' etc.

Thanks

On Fri, 1 Jul 2022 at 23:56, Therrien, Paul <ptherrien@xxxxxxxxxxx<mailto:ptherrien@xxxxxxxxxxx>> wrote:
You need to share the actual code and the actual file layouts.


From: jerry ven <jerryven95@xxxxxxxxx<mailto:jerryven95@xxxxxxxxx>>
Sent: Friday, July 1, 2022 2:24 PM
To: Therrien, Paul <ptherrien@xxxxxxxxxxx<mailto:ptherrien@xxxxxxxxxxx>>
Cc: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>>
Subject: Re: [EXTERNAL] records between two dates

Hi,

I just changed field names and file name and library name here but on the actual file and field names when I replace these SQL queries with the actual file and field names then getting the same kind of results as I shared here.


Thanks.



filiate link: https://amazon.midrange.com