Hi i have a problem with a SQL-Query and ADO CE3.1

It looks like this:

Public objConn, objRecTables, objRecFields, strActiveConnection, strSQL

Private Sub Test
  Set objConn = CreateObject("ADOCE.Connection.3.1")
  Set objRecTables = CreateObject("ADOCE.Recordset.3.1")
  objConn.ConnectionString = "provider=cedb;data source=\test.cdb;"
  objConn.Open
    objRecTables.Open "select customer from table1", "\test.cdb"
    objRecTables.MoveFirst
    While Not objRecTables.EOF
      cb.AddItem (objRecTables.Fields(0).Value)
      objRecTables.MoveNext
    Wend
    objRecTables.Close
  objConn.Close
End Sub

This works fine.

But when i use:

objRecTables.Open "select customer from table1 group by customer",
"\test.cdb"

i get an error.

Is Group By not supported in ADO CE 3.1?

Thanks

Timo

No aggregate functions are supported. Missing functions include:
DISTINCT
MAX
MIN
AVG
GROUP BY

Some of the functions can be found in Sql Server 2000 for CE.

Keld Laursen