|
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> wrote:
You need to share the actual code and the actual file layouts.
*From:* jerry ven <jerryven95@xxxxxxxxx>
*Sent:* Friday, July 1, 2022 2:24 PM
*To:* Therrien, Paul <ptherrien@xxxxxxxxxxx>
*Cc:* Midrange Systems Technical Discussion <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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.