
ADO CE 3.1 SQL Query and Order By
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