FiveTech Software tech support forums

... "ftext,fnum", { "one", 1 } )   XBROWSER oCn:testinsert   FW_MEMOEDIT( oCn:CreateTableSQL( "testinsert" ) )   oCn:Close()return nil This is working well for me: https://imagizer.imageshack.com/v2/xq70/923/043Ca8.png ...

... no veo alguno de como pasar informacion de FWH a HTML, por ejemplo si quiero mostrar un grafico con las ventas anuales, debo hacer la consulta SQL y obtener los datos, eso esta claro, pero que es mejor, hacer la consulta desde FWH y pasar los arreglos con la informacion a mostrar a la TWebView2, ...

I get this error Error description: (DOS Error -2147352567) WINOLE/1007 [MySQL][ODBC 5.1 Driver][mysqld-5.1.53-community]Undeclared variable: oRsWrk (0x80004005): Microsoft OLE DB Provider for ODBC Drivers Args: [ 1] = C SELECT * INTO oRsWrk FROM oRsDet oRsWrk and oRsDet ...

... Hace lo que se supone debe hacer, pero tengo cada vez tengo este error entre los 5.000 y 6.000 archivos procesados Application Internal Error - C:\SQL\xNewAqua\xNewII.Exe Terminated at: 2024-03-20 16:18:46 Error irrecuperable 9009: hb_xrealloc no puede reubicar la memoria...... It fails in no specific ...

... Hace lo que se supone debe hacer, pero tengo cada vez tengo este error entre los 5.000 y 6.000 archivos procesados Application Internal Error - C:\SQL\xNewAqua\xNewII.Exe Terminated at: 2024-03-20 16:18:46 Error irrecuperable 9009: hb_xrealloc no puede reubicar la memoria...... It fails in no specific ...

... In case we need the structure, call this immediately aStruct := oCn:Execute() QueryResult This is an extension to Execute. if we use an sql like "select age from customer where id = 100" this function returns 58, instead of {{58}} That is ok, works fine.

... In case we need the structure, call this immediately aStruct := oCn:Execute() QueryResult This is an extension to Execute. if we use an sql like "select age from customer where id = 100" this function returns 58, instead of {{58}} As you indicated above, if we want to edit ...

... is reset to the next record. It is not a 100% correct solution but it works for me, since normally I will not use fields greater than 256 for the SQL queries that I will perform with ADO.

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(), ...

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

Please also give me the SQL to read the data from the 3 tables

:ActiveConnections is only for ADO recordsets. In fwmaria lib, it is oRs:oCn. To change the sql, please make a new RecSet object, set it to oBrw:oDbf and then close the old RecSet object You may try this sample and use similar logic #include "fivewin.ch"function ...

Como ser, quiero saber como saber la ultima consulta que que hizo (query)

Code: Select all  Expand view

? oCn:cLastSQL

Also you can view last 10 sql statements executed

Code: Select all  Expand view

XBROWSER oCn:aSQL

This works from FWH2102 onwards.

Got it working. It was a setting in MS-SQL. I had to enable both Windows Authentication and SQL user authentication.

Thanks again for the help.