Search found 19 matches: appe

Return to advanced search

Padron de IIBB

Hola buenas tardes, desde hace mucho en mi sistema cargo el padron desde el txt con appe from "padron.txt" sdf y funcionaba perfecto.

El tema es que ahora solo carga el primer registro, puede ser que venga sin el 0D 0A?

Como lo solucionaron?

SAludos.
Jorge
by jpcavagnaro
Mon Dec 13, 2021 10:50 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Padron de IIBB
Replies: 1
Views: 315

Faster way then append from SDF

... I extract information then I need into another table. It's working fine, but the process take a while. I found out, that only read the file with 'APPE FROM .... SDF take more than 30sec. I the a faster way to read the information, and check the content of each line? Thanks
by Marc Vanzegbroeck
Thu Feb 14, 2019 8:02 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Faster way then append from SDF
Replies: 11
Views: 2168

Re: calculate days

... "periodi.dbf", aFields, "DBFCDX" )USE PERIODI.dbf NEW VIA "DBFCDX"// generate periods for pricelist 1appe blankfield->check_in:=ctod("17/05/2018")field->check_out:=ctod("27/06/2018")field->guest="BASSA"field->rooms_id="01"appe ...
by Silvio.Falconi
Thu Jan 10, 2019 8:33 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: calculate days
Replies: 7
Views: 1182

xbrowse to excel problem (numeric field with decimal)

... "N", 9,0}) AADD(aDbf,{ "SALARIO2", "N", 9,2}) DBCREATE("CUSTO", aDbf) USE CUSTO NEW ALIAS (cAlias) APPE BLANK REPLACE nome with "Rossi Mario",salario1 with 1234,salario2 with 1234.56 DEFINE dialog ownd TITLE "Test" FROM 0,0 TO ...
by Romeo
Thu Dec 11, 2014 3:59 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: xbrowse to excel problem (numeric field with decimal)
Replies: 2
Views: 620

xbrowse to excel

... "N", 9,0}) AADD(aDbf,{ "SALARIO2", "N", 9,2}) DBCREATE("CUSTO", aDbf) USE CUSTO NEW ALIAS (cAlias) APPE BLANK REPLACE nome with "Rossi Mario",salario1 with 1234,salario2 with 1234.56 DEFINE dialog ownd TITLE "Test" FROM 0,0 TO ...
by Romeo
Tue Dec 09, 2014 11:46 am
 
Forum: All products support
Topic: xbrowse to excel
Replies: 6
Views: 1664

Re: Daniel - Cambios para tDolphin

realmente no ha entrado a producción la appe, aun esta en desarrollo, pero para evitar esto es necesario hacer un timer que cada 30 o 60 segundos verifique la conexion, y en caso de caída re-conecte. PROCEDURE Main()   LOCAL ...
by carlos vargas
Fri Feb 28, 2014 7:37 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Daniel - Cambios para tDolphin
Replies: 3
Views: 801

Re: APPE FROM ...DELIMITED date-format question.

Hi solved it with a workaround by first reading the file into a memofield and remove all '-' with a STRTRAN, and save it again.

Marc
by Marc Vanzegbroeck
Fri Sep 07, 2012 12:03 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: APPE FROM ...DELIMITED date-format question.
Replies: 3
Views: 649

Re: APPE FROM ...DELIMITED date-format question.

Thanks for the reply, but the problem is that I can't change this, because it's a CSV-file created by an SQL-command.
I can't find how how to change the format in MySQL in an 'INTO OUTFILE' command.
So I need to solve this with Harbour..

Regards,
Marc
by Marc Vanzegbroeck
Fri Sep 07, 2012 11:16 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: APPE FROM ...DELIMITED date-format question.
Replies: 3
Views: 649

Re: APPE FROM ...DELIMITED date-format question.

Dear Marc Vanzegbroeck,

Try use numeric for date with format YYYYMMDD ,

like :

11795129,20120731,42,9,"","Laadbrug",8,1,0,0.00


Thank

kok
by kok joek hoa
Fri Sep 07, 2012 11:12 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: APPE FROM ...DELIMITED date-format question.
Replies: 3
Views: 649

APPE FROM ...DELIMITED date-format question.

Hi, I want to add CSV-files like into a DBF like this 11795129,"2012-07-31",42,9,"","Laadbrug",8,1,0,0.00 11795130,"2012-07-31",42,10,"","Ret.oude ketting",8,1,0,0.00 11795131,"2012-07-31",42,11,"","",8,1,0,0.0...
by Marc Vanzegbroeck
Fri Sep 07, 2012 10:35 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: APPE FROM ...DELIMITED date-format question.
Replies: 3
Views: 649

Re: Como mostrar un Archivo Texto Plano

... con un solo campo de caracter con un ancho de 140 Luego el DBF mostrarlo en un browse algo asi: USE REPORTE ALIAS REPORTE NEW EXCLUSIVE ZAP APPE FROM LISTADO.TXT SDF El browse DEFINE DIALOG oDlg FROM 0,0 TO 800,600 PIXEL TITLE "Vista Preliminar de: LISTADO.TXT" oBrw1 := TXBrowse():New( ...
by acuellar
Wed Jul 22, 2009 6:55 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Como mostrar un Archivo Texto Plano
Replies: 18
Views: 5078

Re: DBF - índice no detecta un campo

... registro se tiene que hacer los siguiente: .USE PRUEBA .COPY TO DBFCOPIA .35153 record copied .GO 35155 .COPY NEXT 14845 TO DBFOTRA .USE DBFCOPIA .APPE FROM DBFOTRA .COPY TO PRUEBA Y listo tu DBF quedo corregida sin el registro duplicado.. Espero que me haya explicado bien y si no escribeme a mi ...
by MauroArevalo
Fri Jul 17, 2009 12:51 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: DBF - índice no detecta un campo
Replies: 14
Views: 3932

Re: How to connect FiveWin with Mysql

Hi,

In's maybe a stuppid question, but is it possible to use MySQL and still use the same commands as for DBF-file (APPE, REPL , INDEX,...) or do we need to use SQL commands?

Thanks,
Marc
by Marc Vanzegbroeck
Sun Feb 22, 2009 1:42 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: How to connect FiveWin with Mysql
Replies: 16
Views: 3980

... Save( i, k ) LOCAL cCodigo cCodigo := DTOC( ( k - 1 ) ) + aMat[ i, 1 ] Use OreD DbSeek( cCodigo ) IF found() oreD->Mensaje := aMat[ i, k ] ELSE Appe Blank oreD->Codigo := cCodigo oreD->Mensaje := aMat[ i, k ] ENDIF RETURN NIL
by Silvio
Sun Jun 08, 2008 5:53 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: SomeOne can help me ?
Replies: 6
Views: 1275

Problema con un memo

... hay entre el CDX del CLIPPER y el que utiliza PROMETHEUS?¿alguien lo sabe? Otra solucion sería intentar recuperar el FTP, con COPY STRU y APPE FROM no funciona. ¿alguna sugeremcia? Mil Gracias. Saludos
by antolin
Mon Jun 25, 2007 7:18 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Problema con un memo
Replies: 3
Views: 854
Next

Return to advanced search