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



Sun, 16 Jan 2005 16:13:21 GMT  
 ADO CE 3.1 SQL Query and Order By

Quote:
> Hi i have a problem with a SQL-Query and ADO CE3.1
> Is Group By not supported in ADO CE 3.1?

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



Sun, 16 Jan 2005 16:31:21 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. ADO 3.1 ,,, sql statement??????????

2. ADO 3.0 or ADO 3.1

3. QUERY: Win 3.1 Support in VB 5 Pro

4. Fields order in sql query

5. listbox ordering after an SQL query

6. ADO and SQL Server CE

7. Error #-2146824582 ADO could not find the specified provider Using SQL SERVER CE

8. ADO provider error Windows CE 2002 (sql)

9. Problem: Win 3.1 crashes with PB 3.1 programs

10. Netware 3.1 , Windows 3.1 and VB

11. SQL Functions in VBA for Excel 5.0 / Win 3.1

12. Using WINAPI 3.1 call FindExecutable on Windows 3.1

 

 
Powered by phpBB® Forum Software