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.