FiveTech Software tech support forums

Lo que está creando el conflicto es el INNER JOIN: cSQL := "SELECT s.id, s.Codigo, s.Codbarra, s.Descri, s.Precio_vta, s.Cantid, s.Cantid1, s.Cantid2, s.Cantid3, s.Cantid4, s.Rubro, s.Descri1, s.Marca, s.Costo, s.Minimo, s.Lote, s.Porc_iva, s.Gravado, s.Fec_alta, " + ; " s.Fec_modi, s...

Hola gente, tengo un xbrowse de esta consulta: cSQL := "SELECT s.Codigo, s.Codbarra, s.Descri, s.Precio_vta, s.Cantid, s.Cantid1, s.Cantid2, s.Cantid3, s.Cantid4, s.Rubro, s.Descri1, s.Marca, s.Costo, s.Minimo, s.Lote, s.Porc_iva, s.Gravado, s.Fec_alta, " + ; " s.Fec_modi, s.Descu1, s...

I have a field as oDbf:prov on Report if I made AAdd(oRep:aGroups,trGroup():New({||oDbf:prov},{||""},{||"Total"},{|| 1 },.t.,oRep)) run ok but I not ...

... use Tdatabase oDbf:=TComuni():New() oDbf:setorder(1) oDbf:Gotop() local aCols := { ; { "COMUNE", "Comune" ,, 120, },; { "PROV", "Provincia",, 70, },; { "CAP", "Cap" ,, 50, },; { "CODREG", "Regione" ,, 80, } } @ 110,10 ...

... the tree could do for example with the archive above in the dialog the tree can be created if all the records have the same province ( FIELD->Prov) or in an article archive I could make the tree for the category and for another type of data for example on archive you see on picture I can order ...

Silvio, tiene que ser igual igual? O sea, diferencia entre mayusculas y minusculas? Y tiene 2 caracteres?
Sino has la prueba con for oDbf:prov=cSigla

after select the cSigla value I made on Report class ACTIVATE REPORT oReport FOR oDbf:PROV == cSigla why it not run ok ? oDbf:Prov is 2cr as cSigla Function Report_Comuni(oGrid,oParent,odbf)   local oRep   local nRecno   := odbf:Recno()  ...

... de recordset, el cual se construyo en base a un query, luego de actualizar me arroja error cSql:="SELECT D.*,DP.NOMBRE AS DPTO, PR.NOMBRE AS PROV,DI.NOMBRE AS DIST "+; "FROM DIRECCION D "+; " LEFT JOIN DEPARTAMENTO DP ON D.CODDEP=DP.CODDEP "+; " LEFT JOIN PROVINCIA ...

I wish create a filter on a xbrowse fill with a Dbf ( I have a dbf with 61.819 records) I wish search these fields ABI CAB ISTBAN CAP LOCALITA PROV https://i.postimg.cc/Gp8DZVdL/bank.png I saw the Nages samples use array data but not dbf directly I insert oBrowse:uBarGetVals := ...

... (alias_tablas) ),; Vertabla( "CLA" + (alias_articu)->ar_clase, (alias_tablas) ),; (alias_articu)->Ar_Prove,; ((alias_proveedo)->( dbSeek( (alias_articu)->Ar_Prove) ),(alias_proveedo)->Nombre),; dtoc( (alias_articu)->Ar_F_Uco),; (alias_articu)->Ar_P_Med,; ...

... IF( !substr(oBrw1:aCols[2]:Value,1,3) = " ", oFont, oWnd:oFont) ,) } ya que al final al llegar a la cuenta 2020-000-000-000 PROV PEND POR PAGAR me pinta todo de negritas en lugar de cuentas acumulativas, desde las primeras cuentas de mayor no hay problema, porque son de 4 ...

... IF( !substr(oBrw1:aCols[2]:Value,1,3) = " ", oFont, oWnd:oFont) ,) } ya que al final al llegar a la cuenta 2020-000-000-000 PROV PEND POR PAGAR me pinta todo de negritas en lugar de cuentas acumulativas, desde las primeras cuentas de mayor no hay problema, porque son de 4 ...

... nNumEmp, cDescrEmp, Mes_Per, Ano_Per, nStation,EjeMAIn//------------------------------------------------------------------------------FUNCTION C_PROVCLIE() LOCAL oItem:=oMOpc,oWChld, nW, nH,xEmp LOCAL aDatos1, aDatos2, oBrw1, oBrw2,lSalir LOCAL aGradBarSelFocus:= { ...

Richard Have a look at this website and make sure you have the correct OldDb client ( as enrico suggests ) .. As far as your code and connection string, it appears syntactically your code should work .. ( I would remove #Include Ado.ch" ). https://cherrycitysoftware.com/CCS/Providers/ProvMySQL....

... oFrmImportaBanche Valid SearchBanche(cProvincia,oBrwImportaBanche,8) Function SearchBanche(ctext,oBrw,n) FIELD ABI,CAB,ISTBAN,FILBAN,CAP,LOCALITA,PROV local cCond:="", bCond DO CASE CASE n= 6 INDEX ON CAP TO TMP FOR ! deleted() cCond := "CAP = Upper(alltrim('" + ctext + "' ...