Hello.
Currently, we are trying to get a new SQL query to function within DB Connect. The SQL query runs against a Postgres database. Although the SQL query runs fine in batch mode, it is not running so well when setting up the same in rising mode. Attached is a screenshot of the error message we are receiving.
We tried setting the rising column as "created_at". Also, we tried adding the following lines to the SQL query:
- AND created_at > ?
- ORDER BY created_at ASC
But we receive error messages:
- org.postgresql.util.PSQLException: No value specified for parameter 1.
- org.postgresql.util.PSQLException: The column index is out of range: 1, number of columns: 0.
Can someone suggest the best approach to resolving this?
Regards,
Max
