× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Hi,

Ok, so if the record counts for (1. and 2. SQL Queries ( on file1) was too
less than compared to record count for (3. and 4. (SQL queries for record
count for view (V1) )
then is it fine or acceptable or is there any probability of Typos - bad
field names, transposed characters here which might cause this imbalance
in terms of record counts here?

I mean to ask, is it OK to say that a view can have more records compared
to the file on which it is based ?

or conceptually it's wrong here? ( considering my SQL queries and Views for
which I shared Queries in my last posts ( 1.,2.,3.,4.)

if it's right then I have equal records for my view and in the WRKQRY but
if it's wrong then my view and WRKQRY has too many more records compared to
the SQL queries ( on file1 SQL Queries 1. and 2.)


Thanks.





On Sat, 2 Jul 2022 at 00:05, Therrien, Paul <ptherrien@xxxxxxxxxxx> wrote:

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 thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.