FiveTech Software tech support forums

... loads about 100,000 records, is it possible that the BackUp has a clause (WHEN) to condition the process?, as well as: BackUp( [source], [dest], [bProgress], [cCondition], [nRecsInBatch], [nMaxBufperSQL] ) where cCondition := "WHERE year(fecha_doc) > 2023", something like that. Thank ...

... loads about 100,000 records, is it possible that the BackUp has a clause (WHEN) to condition the process?, as well as: BackUp( [source], [dest], [bProgress], [cCondition], [nRecsInBatch], [nMaxBufperSQL] ) where cCondition := "WHERE year(fecha_doc) > 2023", something like that. Thank ...

... 3) conversion from storico.dbf to lotto.dbf for the procedure 2 and 3 I use the same meter (oProgress) for procedure 1 local nPos := 1 local bprogress := { || (oProgress:Set( npos++ ),; //oProgress:SetPos( npos++ ),; oSay[3]:SetText(ltrim(str(npos))),; oSay[3]:refresh(),; SysRefresh() ) } ...

... , cPath+"STORICO", "DBFCDX", .T. ) SET DELETED ON olotto2:setorder(0) oLotto2:gotop() //FW_ArrayToDBF( aData, cFieldList, bProgress, lOverWrite, lRecallDeleted, bTrigger ) oLotto2:fw_ArrayToDBF( aData,,bProgress) // how insert conditions ? I need to create it because when ...

... valor de la variable, si ésta indica que deseo con Calc, entonces después de definir XBrowse debo indicar: If lQuieroCalc bDummyBloc := { | oBrw, bProgress, nGroupBy, aCols | ( oBrw:bToExcel := Nil, oBrw:ToCalc( bProgress, nGroupBy,,, aCols ), oBrw:bToExcel := bDummyBloc ) } oMiwBrowse:bToExcel ...

When I make a conversion I use local bprogress := { || ( oProgress:SetPos( npos++ ),; SysRefresh() ) } oProgress:SetRange( 0, (len(aData)/1000) ) oProgress:SetPos( 0 ) oLotto2:fw_ArrayToDBF( aData,,bProgress) aData is big https://i.postimg.cc/d3Zc418S/gg.png ...

When I convert from a csv file to an array, the fw_ArrayToDBF (aData ,, bProgress) function inserts me an empty record, how do I avoid this   local  csvfile:=".\csv\file.csv"   local  cSymbol := ","   local  cText := StrTran( MemoRead( ...

... line of the csv file I have the database fields and I was able to delete with adel (adata, 1) but later when I use oDbf: fw_ArrayToDBF (aData, , bProgress) to save aData in the dbf archive, the procedure inserts a first empty record and then in any case inserts all the other records for a sample ...

... line of the csv file I have the database fields and I was able to delete with adel (adata, 1) but later when I use oDbf: fw_ArrayToDBF (aData, , bProgress) to save aData in the dbf archive, the procedure inserts a first empty record and then in any case inserts all the other records for a sample ...

... line of the csv file I have the database fields and I was able to delete with adel (adata, 1) but later when I use oDbf: fw_ArrayToDBF (aData, , bProgress) to save aData in the dbf archive, the procedure inserts a first empty record and then in any case inserts all the other records for a sample ...

If I delete a record on aData then I must save the aData on dbf from yunus.prg I saw there is //FW_ArrayToDBF( aData, cFieldList, bProgress, lOverWrite, lRecallDeleted, bTrigger ) if ! Empty( oBrw:aDeleted )            AEval( oBrw:aDeleted, { |a| a[ 9 ] := -a[ ...

... * Mejora: En la función FW_ExcelToDbf( oRange, cFieldList, lHasHeaders, bProgress ) Ahora el parámetro cFieldList puede ser también una matriz de dos dimensiones: El primer elemento de cada ítem contiene el nombre del campo ...

... * Enhancement: function FW_ExcelToDbf( oRange, cFieldList, lHasHeaders, bProgress ) Now cFieldList can also be a two-dimensional array: First element of each item contains the field name and the second element contains the ...

No sé como lo haces para estar siempre tan atento!!! Muchas gracias!!!

bProgress recibe dos parámetros:

Eval( bProgress, 0, nRows )

el primero es siempre cero y el segundo parece ser nRows := oRange:Rows:Count

puedes revisarlo en source/function/dbffunc2.prg