As I am trying to update from 3.5.x to 5.1.3 I keep running against subtle differences.
In 3.5 is the following getDataByQuery query.
- Code: Select all
var query_pk = "SELECT donation_detail_id FROM donation_detail WHERE donation_detail_id IN " + "(SELECT (donation_detail_id) FROM donation_detail WHERE detail_date = ? GROUP BY detail_query_totals)" + "ORDER BY detail_query_totals asc";
In 5.1.3 it throws the following error,
SQL Anywhere Error -149: Function or column reference to 'donation_detail_id' must also appear in a GROUP BY
Thanks in advance for all your assistance.