I am getting different results when i run a SQL statement from a simple test program (via Test RPG Call) and when using the same statement in a (modified) AutoCode grid inquiry program.
One of the fields used to join with another table has a null value.
The simple program returns all records but the grid inquiry program stops when it encounters the record with the null value field and displays only the first 2 records.
This makes me think of the SQL to JSON issue i had and we discussed in a confcall last month.
I have attached the source code of the simple program.
(we use Valence version 3.0.20110527.0).
One of the fields used to join with another table has a null value.
The simple program returns all records but the grid inquiry program stops when it encounters the record with the null value field and displays only the first 2 records.
This makes me think of the SQL to JSON issue i had and we discussed in a confcall last month.
I have attached the source code of the simple program.
(we use Valence version 3.0.20110527.0).
Comment