FiveTech Software tech support forums

Hola.
Estoy intentando hacer una consulta simple con la función FW_DBFSqlQuery pero cuando le añado GROUP BY me muestra error.

La consulta es la siguiente:

Code: Select all  Expand view

Function Main()

   TEXT INTO cQuery
      SELECT CODIGO, NOMBRE, COD_PRO
      FROM ARTICULO
      GROUP BY COD_PRO
   ENDTEXT
   oRs := FW_DbfSqlQuery( '.\DBF', cQuery,,.t.)
   xBrowse( oRs)

Return ( Nil )

la respuesta que obtengo es:


en cambio, en MySql sí que funciona:


si le quito GROUP BY
funciona correctamente


alguna idea?

He buscado la documentación de FW_DbfSqlQuery() pero no la encuentro.

Gracias!!

https://forums.fivetechsupport.com/viewtopic.php?f=3&t=26873&p=149080&hilit=FW_DBFSQLQUERY#p149080

https://forums.fivetechsupport.com/~fivetec1/forums/viewtopic.php?f=6&t=40578&p=242420&hilit=FW_DbfSqlQuery&sid=f53d23555351938b779f35d03fac7a38&sid=a5b57d6cfaff5a422202af74dbc3763d#p242420

https://forums.fivetechsupport.com/~fivetec1/forums/viewtopic.php?f=3&t=39116&p=233442&hilit=FW_DbfSqlQuery&sid=f53d23555351938b779f35d03fac7a38&sid=a5b57d6cfaff5a422202af74dbc3763d#p233442

https://forums.fivetechsupport.com/~fivetec1/forums/viewtopic.php?f=3&t=38577&p=230137&hilit=FW_DbfSqlQuery&sid=f53d23555351938b779f35d03fac7a38&sid=a5b57d6cfaff5a422202af74dbc3763d#p230137

https://forums.fivetechsupport.com/~fivetec1/forums/viewtopic.php?f=3&t=37033&p=221035&hilit=FW_DbfSqlQuery&sid=f53d23555351938b779f35d03fac7a38&sid=a5b57d6cfaff5a422202af74dbc3763d#p221035

https://forums.fivetechsupport.com/~fivetec1/forums/viewtopic.php?f=3&t=26873&p=149080&hilit=FW_DbfSqlQuery&sid=f53d23555351938b779f35d03fac7a38&sid=a5b57d6cfaff5a422202af74dbc3763d#p149080

https://forums.fivetechsupport.com/~fivetec1/forums/viewtopic.php?f=16&t=25975&p=142175&hilit=FW_DbfSqlQuery&sid=f53d23555351938b779f35d03fac7a38&sid=a5b57d6cfaff5a422202af74dbc3763d#p142175

Regards, saludos.

Thank's karniha
Before writing this post I have reviewed the forum content about fw_dbfSqlQuery() but I have not found any answer to my problem.

Syntax of SQL Query has nothing to do with FWH function.
It is for the programmer to know the correct syntax of SQL supported by Jet OLE/ACE ole

Normally GROUP BY clause is used for Aggregate functions.
Example:

Code: Select all  Expand view

SELECT STATE,SALARY FROM CUSTOMER GROUP BY STATE ORDER BY STATE

Some Databases like MySql support GROUP BY without aggregate functions.
But all providers /databases do NOT support GROUP BY clause without Aggregate functions like MSSQL.ORACLE, Jet,ACE, etc

While dealing with DBF, we are concerned with Jet Oledb/ACE Oledb/VFPOLEDB.
None of them support GROUP BY clause without Aggregate functions.

It is rare to find anyone using GROUP BY clause if not for finding GROUPED TOTALS/AVERAGES. ETC

Thanks for your reply.
Indeed, I have seen that the problem is the SQL syntax. I am very used to using MySql for web purposes. Now it's time to learn MSSQL to be able to advance in FiveWin Harbour.