FiveTech Software tech support forums

wfecha:=Dtos(Ctod('07/11/2024')) Text Into cSql SELECT m1.tropanumero AS tropa, m1.correlativo, ani.descripcion, m1.inac AS INACUR,ROUND( t.kilosen1 / t.cabezas , 2) AS KEnPie, m1.kilos + isnull(m2.kilos,0) AS KClasif, m1.precioen2 ...

... oDbf:GoTop()          xbrowser odbf        oDbf:SetFilter(cFilter)        oDbf:GoTop()     xbrowser odbfreturn nil the index 1 is on DTOS(DATA)+CONCORSO before the filter I see all archive https://i.postimg.cc/hP46tBY8/before.png the filter seems good https://i.postimg.cc/XYYbmF3b/filtro.png ...

Hello Rao , in a select when I search for a date I use SELECT * FROM customer WHERE HIREDATE= " +DTOS(DATE()) How do I use the date search with locate? I tried cLocate := " HIREDATE = '" + DTOS(DATE()) + "'" But I have this error Error occurred at: ...

Hi Marco
not only how many tags but its formula for that single tag
e.g.: dtos( gio_drg) + str(gio_num,9) + str(gio_riga,3)
I often made too complex indexes which often slowed down the browse,
I would like to know if the slowness you see is on loop type : ' do while .. enddo '
or on a browse
Bye

... ) ) ) ) // esto anda if( dtoc(ATail( oDlg:aControls ):Cargo) == '17/06/2024', CLR_BROWN,CLR_BLACK ), CLR_CYAN ) ) ) ) // if( feriados->(DbSeek(DToS(ATail( oDlg:aControls ):Cargo))), CLR_BROWN,CLR_BLACK ), CLR_CYAN ) ) ) ) if ATail( oDlg:aControls ):Cargo == dDate ATail( oDlg:aControls ):lPressed ...

... Adaptando el MSGDATE a mis necesidades me topo con este problema. Agregue una dbf de FERIADOS cuyo indice es dtoc(fecha) (tambien prove con dtos(fecha)) con el objeto de mostrar en otro color los dias feriados. lo hago de esta forma: .... ATail( oDlg:aControls ):nClrText = if(nCol=1,CLR_HRED, ...

... fields in a record I also write user code and date time For instance REPLACE field->utemodi WITH "001" , ; field->datmodi WITH DTOS(DATE())+STRTRAN(TIME(),":","") Very very useful for many things I can do that I'm not here to write. You can imagine it. I ...

Buenos dias. Tengo una DBF que muestro con un xBrowse. la DBF tiene 2 indices, uno de los cuales es combinado de NOMBRE+DESCEND(dtos(FECHAPAGO)) . El problema es que con el primer indice muestra perfecto los datos y me puedo mover por ellos sin problemas, pero cuando paso al indice mencionado ...

... cCMDVAL := cCMDVAL+"'"+cFileG +"', " cCMDVAL := cCMDVAL+"'"+cFILE +"', " cCMDVAL := cCMDVAL+"'"+DToS(PROGFEC)+"'," cCMDVAL := cCMDVAL+"'"+Str(PROGTAM) +"'," cCMDVAL := cCMDVAL+"'"+PROGHRS+"' );" ...

... las ideas aportadas y el uso de codeblock para resolver el problema. En la tabla informes contiene el campo rutainforme = "inf1_" + Dtos( dFecha ) + "-" + Substr( whoraini, 1, 2 ) + Substr(whoraini, 4, 2 ) + "-" + Substr( whorafin, 1, 2 ) + Substr(whorafin, 4, ...

...    //linea 14     RETURN nil Este código se ajusta mas a lo que hago. el contenido de oRs:RutaInforme es: "inf1_" + Dtos( dFecha ) + "-" + Substr( whoraini, 1, 2 ) + Substr(whoraini, 4, 2 ) + "-" + Substr( whorafin, 1, 2 ) + Substr(whorafin, 4, ...

... como una fórmula en un campo de texto que llamaremos oRs:RutaArchivo oRs:RutaArchivo contiene esta fórmula tal cual: ".\XLSX\inf1_" + Dtos( dFecha ) + "-" + Substr( whoraini, 1, 2 ) + Substr(whoraini, 4, 2 ) + "-" + Substr( whorafin, 1, 2 ) + Substr(whorafin, 4, ...

Hi all,
I would like to know how to remove an index on a MySql MariaDatase table.
To create an index, the 'UNIQUE' clause is used. How to delete an index?

how to build compound index INDEX ON CLI_COD + STR(CLI_FAT,12,2) + DTOS(date())
TIA
Maurizio Menabue

... TO IND003 DBSETINDEX("IND003") SELECT 4 USE (cSERVER + "ARQBOLET.DBF") NEW //SHARED INDEX ON COD_AVUL+COD_EMPRES+MES_REF+DTOS(DT_BOLETIM) TAG TAG_004 TO IND004 TEMPORARY DBSETINDEX("IND004") SELECT 5 USE (cSERVER + "ESOCEVEN.DBF") NEW //SHARED INDEX ...

hi Silvo, why do you "just" use DOW() and not DTOS() which give you "more" Information you can ad "more" to DTOS() like Postcode of City to compare (use Number) lottery drawings in Italy are drawn every week and precisely ...