FiveTech Software tech support forums

... ; PORT 3306 ; FLAGS 0; DATABASE 'test' oQry := oServer:Query('SELECT p.chave as chave, p.data as data, c.nome as nome FROM ped AS p LEFT JOIN cli AS c ON(c.codigo=p.codigo) ORDER BY p.chave') DEFINE DIALOG oForm TITLE "MGA" FROM 05,10 TO 42,100 @ 00,00 XBROWSE oBrw DATASOURCE oQry; ...

... a enviar en espera de darle al botón de envío Seria interesante poder comunicar en modo 'silencioso' sin abrir el programa Existen varios whatsapp-CLI pero para Python y Go

LOCAL xPath := "C:\PDF\" * --- Elimina File che Iniziano con CLI_...PDF AEVAL(DIRECTORY(xPath + "CLI_*.PDF"),{|aFile|FERASE(xPath + aFile[F_NAME])} ) nel tuo comando : cFILE := ALLTRIM( aDIR[i][1] ) fai un display della variabile cFILE se comprende il path completo + \ , es. c:\m...

Time from start: 10 hours 50 mins 45 secs Error occurred at: 09/19/2023, 18:31:36 Error description: Error BASE/1002 No existe el alias: CLI Stack Calls =========== Called from: => DBSETRELATION( 0 ) Called from: FUENTES\GESTION\INVENTARIOS\FACTELEC.PRG => ENVIAFEL( 593 ) Called from: ...

... MAIN( 17 ) Time from start: 3 hours 18 mins 13 secs Error occurred at: 09/18/2023, 18:47:05 Error description: Error BASE/1002 No existe el alias: CLI Stack Calls =========== // como comente anteriormente ... en este punto esporádicamente se da el error ( puede suceder después de miles de pasos ...

Hola gente, en la versión 23.07 me da este error, cosa que en la 22.12 no. Me falta agregar alguna librería? Este es parte del código: *----------------- DEFINE WINDOW oWndChild MDICHILD OF oWnd FROM 0, 0 TO 24, 79TITLE "Carga Informe de Auditoría " font oFont11 DEFINE DIALOG princfac RESO...

... UTF8-Editor and not when create a "new" DBF it was from some (40 Year old) DBF, start with 7-Bit C/PM under Dbase ]} over. Dbase III+. Cli*pper, Xbase++, HMG and now Fivewin these DBF (still) have OEM "Umlaute" not ANSI "Umlaute" but there is no OEMtoUTF8() Function ...

Hi All how do you create an index with multiple fields in Maria Db and then also the seek command with DBF Es. Index ON COD_CLI + STR(COD_NUM,2) ... with MARIA DB .......................... CLIENT->(dbseek(COD_CLI+str(COD_NUM,2))) with MARIA DB oRS:seek(COD_CLI, COD_NUM) correct ? tia We are thi...

Hi All how do you create an index with multiple fields in Maria Db and then also the seek command with DBF Es. Index ON COD_CLI + STR(COD_NUM,2) ... with MARIA DB .......................... CLIENT->(dbseek(COD_CLI+str(COD_NUM,2))) with MARIA DB oRS:seek(COD_CLI, COD_NUM) correct ? tia

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

Hola, necesito hacer una pantalla con 4 folders de las cuales 3 tienen listbox, el problrma que tengo es que no muestran los datos, muestra un solo registro, a persar de que los datos se graban bien en las dbf. DEFINE WINDOW oWndChild MDICHILD OF oWnd FROM 0, 0 TO 24, 79TITLE "Carga Informe de ...

Perhaps, if you are using pellesC, you need to "remove" the SORT variable in the combobox as NO.

Maybe:
ON Change := cTipo_Cli[ oCbx:nAt ]

Regards, saludos.

Hello
I have a COMBOBOX ( in a RC file with Sort = Yes )

aTipi := {'Paolo', 'Gianni','Andrea' 'Cesare' }

I set cTipo_Cli = 'Gianni'

REDEFINE COMBOBOX oCom Var cTipo_Cli ITEMS aTipi ID 4009 OF oDlg

but when I open the dialog on the combobox I have 'Cesare' and not 'Gianni'

Thanks

... DEFINE DIALOG oDlg FROM 00,00 TO 260,520 TITLE "T E S T E" ; COLORS CLR_WHITE,CLR_WHITE PIXEL FONT oFont @ 05,05 LISTBOX oBrw FIELDS CLI->COD,CLI->NOME ; HEADERS "Codigo","Nome" FIELDSIZES 40,60 ; ALIAS "CLI" OF oDlg SIZE 180,100 PIXEL ACTIVATE ...

MI estimado, prueba asi: cQuery := "SELECT " cQuery += "Cli.rif_cliente, " cQuery += "Cli.razon_social_cliente, " cQuery += "Fac.numero_documento, " cQuery += "Fac.fecha_documento, " cQuery += "Fac.fecha_vencimiento, ...