since I migrated an old app developped with PB 7 to PB 2019, I have a big problem with some SQL queries from my Datawindows when executed on a database under Oracle 11g. I get this message : 1722 - select Error : SQLstate = 22005.
But the same queries work fine when run on the same database under MS SQL Server. I am developing my application with an MS SQL Server database. And the application works on a database under Oracle at my client's. it always worked well until the migration to PB 2019.
There is my query :
(Select c.adherent_actif from ce_cotisation c where c.id_personne = ce_personnel.int_id and c.id_budget = ? and c.adherent_actif = '1') as adherent_actif,
(select q.num_tranche from ce_vue_qf_adherent q where q.id_personnel = ce_personnel.int_id and q.id_budget = ?) as num_tranche_qf
ORDER BY ce_personnel.nom ASC,
Thank you for helping me !