Posted on 2003-02-28
i have a problem with this sql :
SELECT count(ado_persons.lastname), ado_persons.firstname, ado_persons.country, ado_persons.grade
WHERE (ado_persons.grade = 'Architect')
I work with delphi5, ado tables and ado query, connecting to an MDB ACCESS 97 database. The problem is with the reserved word COUNT. When i use it alone that work, but when i insert COUNT, SUM or other operator with other fields in the SELECT statement nothing work !
Where is a documentation for using SQL syntax with ADO and MDB database on delphi 5?