databaseManager.getDataSetByQuery and Servoy 2019.12
Posted: Wed Mar 11, 2020 4:48 pm
Hi all,
not sure if this is an issue in Servoy or with the driver or whatever;
If you have a query where you have an unnamed column, caused by simply using a constant as a placeholder, databaseManager.getDataSetByQuery may not return the result.
fails even if there are people records that satisfy the criteria. Changing it to
works. Both version work when executed outside of Servoy, directly in PostgreSQL 12.
not sure if this is an issue in Servoy or with the driver or whatever;
If you have a query where you have an unnamed column, caused by simply using a constant as a placeholder, databaseManager.getDataSetByQuery may not return the result.
- Code: Select all
SELECT person_id, 0 FROM people WHERE person_name ILIKE ?
fails even if there are people records that satisfy the criteria. Changing it to
- Code: Select all
SELECT person_id, 0 as zero FROM people WHERE person_name ILIKE ?
works. Both version work when executed outside of Servoy, directly in PostgreSQL 12.