FiveTech Software tech support forums

This is a great discovery

Thanks for the reply. I have installed the driver from the following address: https://www.microsoft.com/en-us/download/details.aspx?id=32602 I have tried with the connection string: oC:Open('Provider=vfpoledb;Data Source='+cPath+';Collating Sequence=general;') and the result ...

Please try
VFPOLEDB
oledb for foxpro

Hola a todos. Estoy intentando trabajar con tablas DBF pero mediante consultas SQL pero me encuentro con un problema cuando los campos CARACTER son superiores a 256 caracteres. He probado hacer las consultas mediante la función que provee Fivewin FW_DbfSqlQuery(), también mediante la conexión con AD...

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.

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: SELECT STATE,SALARY FROM CUSTOMER GROUP BY STATE ORDER BY STATE Some Databases like MySq...

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.

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=f53d23555351938b779f35d03fac...

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: Function Main()   TEXT INTO cQuery      SELECT CODIGO, NOMBRE, COD_PRO       FROM ARTICULO      GROUP BY COD_PRO   ENDTEXT   oRs := FW_D...

hi Marc,

Marc Venken wrote:I have seen code that uses DBF in combination with SQL
http://forums.fivetechsupport.com/viewtopic.php?f=3&t=26873&p=149080&hilit=FW_DBFSQLQUERY#p149080

Aha, using ADO

Thx for Link

Jimmy wrote:hi,

Question : can FiveWin use SQL Syntax for DBF like FoxPro or Xbase++ v2.x

I have seen code that uses DBF in combination with SQL

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

Please try adding WHRE NOMBRE IS NOT NULL This code work's fine: cQuery := 'SELECT TOP 10 CODIGO,NOMBRE FROM ARTICULO WHERE NOMBRE IS NOT NULL ORDER BY NOMBRE ASC'oRs := FW_DbfSqlQuery( '.\DBF\', cQuery,,.t.)xBrowse( oRs, 'RecCount:' + Str( oRs:RecordCount() ) ) result: https://i.ibb...

Please try adding WHRE NOMBRE IS NOT NULL

Hola. Estoy realizando pruebas para trabajar con ADO los ficheros DBF y me está funcionando todo salvo la combinación de TOP y ORDER BY ASC El siguiente código funciona bien ya que el RecordCount del RecordSet devuelve 10 que es el TOP que se le indica: oRs := FW_DbfSqlQuery( '.\DBF\', 'SELECT T...

This sample code is working for me as expected, include nAvgSalary.
Please check if the folder "c:\fwh\samples\" really exists on your computer.
Note: This may not work with 64-bit applications.