FiveTech Software tech support forums

In the sample program "pivotado.prg": Please locate this line of code:   aPivot   := FW_AdoPivotArray( oCn,  "PVTDATA", "REGION", "PRODUCT", "SALES", "SUM" ) // "SUM" optional/default  Please change this line as:   aPivot ...

We are looking into this.

... lInverted   := .f.   DEFINE FONT oFont NAME "TAHOMA" SIZE 0,-14   DEFINE DIALOG oDlg SIZE 980,300 PIXEL FONT oFont ;      TITLE "PIVOT TABLE"   @ 30,10 XBROWSE oBrw SIZE -10,-10 PIXEL OF oDlg ;      DATASOURCE aPivot AUTOCOLS  ;      CELL LINES FOOTERS NOBORDER   WITH OBJECT ...

1. Install the codec for HEIC (HEIF) images:
https://www.microsoft.com/en-us/p/heif-image-extensions/9pmmsr1cgpwg?activetab=pivot:overviewtab

2. HEIC image test:
https://nokiatech.github.io/heif/content/images/autumn_1440x960.heic

we continue the research...

... this App from Microsoft Store seems to used it https://www.microsoft.com/en-us/p/bluetooth-analyzer/9wzdncrdhhw6?activetab=pivot:overviewtab --- this Product look good. it seem like Tip from Antonio with NirSoft https://www.the-sz.com/products/bennett/

... Demuestra el pintado de xbrowse usando bPaintHeader, bPaintRow, bPaintFooter * adofuncs.prg - Mejora de la compatibilidad de las funciones "PIVOT" con MSSQL. - Funciónn FW_ValToSQL( cVar ): Solucionado el problema de compatibilidad con MSSQL donde cVal incluye doble comillas. * Función ...

... - new samples\xbruser.prg: Demonstrates painting of xbrowse using bPaintHeader, bPaintRow, bPaintFooter * adofuncs.prg - Improved compatibility of pivot functions with MSSQL. - function FW_ValToSQL( cVar ): Fixed compatibility issue with MSSQL where cVal includes double quotes. * function oWndFromhWnd( ...

... user defined computation of columns, group computations and other inbuilt computational capabilities - MakeTotals(). Programming considerations. - Pivot table browses and swapping. - Getbars and Seekbars - Built-in incremental seek/filters - Exporting data Excel, Calc, Report, Word, DBF, PDF - ...

... user defined computation of columns, group computations and other inbuilt computational capabilities - MakeTotals(). Programming considerations. - Pivot table browses and swapping. - Getbars and Seekbars - Built-in incremental seek/filters - Exporting data Excel, Calc, Report, Word, DBF, PDF - ...

... - Fastdraw - Auto-calculation of columns, user defined computation of columns, group computations and other inbuilt computational capabilities - Pivot table browses and swapping. - Getbars and Seekbars - Built-in incremental seek/filters - Forgotten and less known switches, methods and features ...

...  +  IFNULL( t.t01, 0 ),    m.qty    = m.qty     +  IFNULL( t.t02, 0 ),    m.sales  = m.sales   +  IFNULL( t.t03, 0 )  Pivot Table: Syntax: METHOD PivotArray( ; cTable, ; // table name or cSql cRowFld, ; // FieldName or SQL Expression for Rows cColFld, ; // FieldName ...

... ) --> oRowSet or nil if fail METHOD Execute( cSql ) --> nil / val / array METHOD Call( cStoredProc, params....... ) --? nil / rowset METHOD PivotArray( cTable, cRowFld, cColFld, cValFld, [cAggrFunc] ) METHOD Insert( cTable, caFields, aValues, [lUpdateIgnore] ) --> nInserted METHOD Update( ...

Thank you Marcelo, Now it's working! I have to move HAVING to the end, like this. SELECT    name,    ( max( if( PARAMETER = 'NTWKNUM' , inhoud , NULL ) ) ) AS 'NTWKNUM',    ( max( if( PARAMETER = 'NODENUM' , inhoud , NULL ) ) ) AS 'NODENUM',    ( m...

Hola, try adding HAVING SELECT     name,    ( max( if( PARAMETER = 'NTWKNUM' , inhoud , NULL ) ) ) AS 'NTWKNUM',     ( max( if( PARAMETER = 'NODENUM' , inhoud , NULL ) ) ) AS 'NODENUM',     ( max( if(...

Hi, This is not a FWH-question, but I use this query in my FWH-program :D I have a PIVOT query on a table with fields: NAME,PARAMETER,INHOUD,POINT_TYPE I use this query to show the result: SELECT     name,    ( max( if( PARAMETER = 'NTWKNUM' , inhoud ...