RE: Query/400 converted to SQL

Share the query and sql code and we can try to find your mistake.Yours truly,Glenn Gundermannglenn.gundermann@xxxxxxxxx(416) 317-3144
-------- Original message --------From: Bill and Lisa Howie <blhowie66@xxxxxxxxxxx> Date: 2025-07-16 4:14 p.m. (GMT-05:00) To: midrange-l@xxxxxxxxxxxxxxxxxx Subject: RE: Query/400 converted to SQL So here's an interesting development on this....I tried both the methods suggested for converting a Query/400 query into SQL statements.  Plugged both SQL statements into Run SQL Statements in ACS, and in both cases got no results, where if I run the Query/400 query interactively I get 4 records of output.  Thoughts?Bill-- This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing listTo post a message email: MIDRANGE-L@lists.midrange.comTo subscribe, unsubscribe, or change list options,visit: https://lists.midrange.com/mailman/listinfo/midrange-lor email: MIDRANGE-L-request@lists.midrange.comBefore posting, please take a moment to review the archivesat https://archive.midrange.com/midrange-l.Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.