Text only | Text with Images

PxPlus User Forum

Main Board => Discussions => ODBC => Topic started by: Thomas Bock on May 22, 2024, 06:57:37 AM

Title: count distinct not working
Post by: Thomas Bock on May 22, 2024, 06:57:37 AM
I receive an error 15 with
Code Select

select count(distinct columnName) from table

msg(-1)=37000: [PxPlus][SQL ODBC Driver]Expected lexical element not found: <identifier>

How can I count distinct column values using ODBC 7.0.3?
Text only | Text with Images