FiveTech Software tech support forums

... cTabCon:="Diario" aFil:=oCn:Execute("select cdo_cuenta from "+cTabCon+" where substring(cdo_cuenta,1,2) = '70'") aCol:=oCn:Execute("select cdo_auxil2 from "+cTabCon+" where cdo_auxil2 != ''") XBROWSER oCn:PivotArray( cTabCon, aFil, aCol, "monto_habe" ...

Jose Camilo: Y si cambias los oCol por aCol con su subindice? //1) "Articulo", 2)"ArtFor->Detalle", 3)"ArtFor->Abrevia", 4)"Cantidad", 5)"Desde", 6)"Hasta", 7)"DesdeNew",8)"HastaNew" ...

I want to exchange the bitmap which is shown when I have a xBrowse column with nEditType EDIT_BUTTON. My try was WITH OBJECT oBrw:aCols[ 1 ]      :oBtnElip:SetText( "" )      :oBtnElip:LoadBitmaps( "find16" )      :nEditType  := EDIT_BUTTON    ...

aCol := {"StrZero(Productos->Codigo,8,0)","Productos->Descrip","StrZero(Productos->Rubro,4,0) + "-" +Traetabla("Rubros","Indi1","Rubros",Productos->Rubro)[2]","Productos->Precio1","Productos->Precio2"} ...

... then the result is 3 and pressing again on day 9 then the result is 2. on xbrowse I have to calculate the row bCalcRow := { || (oBrowse:aCols[ 6 ]:VarPut( oBrowse:aCols[ 4 ]:Value * oBrowse:aCols[ 5 ]:Value ),;                      oBrowse:aCols[ 9 ...

Sorry for the mistake.
Please change :aCol[ as :aCols[
I edited my posting and corrected it now.

... values are not displayed. Added by GNRao. No need to use @Z        END        // Settings for Totals and Count        WITH OBJECT oBrw        :aCol[ 5]:bFooter       := { || Len( oBrw:aSelected ) }       // this line produces the error         WITH OBJECT :aCol[ ...

Thanks Again...

Hey, Just didn't find this probably easy issue : When developing, the browse is changing because I add/change fielnames and colums from position. If I put a value of [15] then I have to alter the source every time I change something in the coloms oBrw4:aCols[ 15 ]:bLClickHeader := { |r,c,f,oCol| hea...

... sinxtax at ALTER TABLE and the condition to execute both fail. FW provides SQL ALTER TABLE <tbl> <cop:ADD,MODIFY,ALTER> [COLUMN] <acol> => FW_AdoAddModiColSQL( <(tbl)>, <acol>, <"cop"> ) I asked Harbour and xHarbour developers help about Filters. ...

Mr Rao, I followed your suggestion, I return values are:
oBrw: aCol [6]: nWidth = 80, oBrw: aCol [6]: cEditPicture = "Z 999,999.99" and oBrw: aStretchInfo not seem to be an array, if I VALTYPE (oBrw: aStretchInfo) == "U". Will this error here ??? Thank you for your help.

regards

... is true, button's lTransparent also was being changed to .t.. Now fixed. * New: AdoFuncs.prg: New functions FW_AdoAddCol( oCn, cTable, aCol ) --> lSuccess FW_AdoModifyCol( oCn, cTable, aCol ) --> lSuccess aCol is column spec in DBF style. * New: DATA lBmpTransparent in TBtnBmp ...

... * ENhancement: Some changes on Class TBar regarding the 2013 style support. * New: function FW_AdoAddModiColSQL( cTable, aCol, cAddOrModi ) --> cSql in fwh\source\function\adofuncs.prg. Returns SQL statement approapriate to the ADO connection opened through FW function ...

... nTotalCol recibe el valor oBrw:Monto es la columna donde usas el maketotal,, puede ser el header de la columna o el numero, ejemplo aCol[n] nTotal contiene el valor resultante de maketotal espero sea lo que necesitas, saludos...