FiveTech Software tech support forums

... ; [FIELDS <fieldNames,...> ;] [<Scope> ; ] [WHILE <lWhileCondition> ;] [FOR <lForCondition> ;] [VIA <rddName>] [SDF | DELIMITED [WITH BLANK | TAB | PIPE | <xDelimiter> ] ] [CODEPAGE <cCodePage>] ; DELIMITED WITH <xDelimiter> The WITH option specifies ...

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

... Build date May 27 2020 05:53:35 Compiler Microsoft Visual C 19.26.28805 (64-bit) Capabilities RDD DBF, DBFFPT, DBFNSX, SIXCDX, DBFCDX, SDF, DELIM, DBFBLOB, DBFNTX Version Harbour 00 HB_VERSION_HARBOUR Harbour 3.2.0dev (r2004201301) 01 HB_VERSION_COMPILER Microsoft Visual C 19.26.28805 ...

... Build date Jun 23 2020 16:45:39 Compiler Microsoft Visual C 19.26.28806 (64-bit) Capabilities RDD DBF, DBFFPT, DBFNSX, SIXCDX, DBFCDX, SDF, DELIM, DBFBLOB, DBFNTX Version Harbour 00 HB_VERSION_HARBOUR Harbour 3.2.0dev (r2004201301) 01 HB_VERSION_COMPILER Microsoft Visual C 19.26.28806 ...

... Build date Jun 23 2020 16:45:39 Compiler Microsoft Visual C 19.26.28806 (64-bit) Capabilities RDD DBF, DBFFPT, DBFNSX, SIXCDX, DBFCDX, SDF, DELIM, DBFBLOB, DBFNTX Version Harbour 00 HB_VERSION_HARBOUR Harbour 3.2.0dev (r2004201301) 01 HB_VERSION_COMPILER Microsoft Visual C 19.26.28806 ...

Can't you use copy to SDF? no I wish create a source code i wish insert this source code into my application because I not want use that dbf I could write it by hand but it would take me a lifetime I don't have to print that array I ...

Can't you use copy to SDF?

Hola Foro: Genero un archivo txt con la sentencia: Copy To &cNomArch2 SDF Y me piden lo siguiente: "En el Refresh deben agregar en el registro final los caracteres 0d0a" Estos caracteres son de final de archivo? No los agregar por defecto la sentencia ...

... Even these 2 seconds time can be reduced further: 1) The function was written for variable length records. Because you are using APPEND FROM .. SDF, I guess the records in the text file are all of a fixed length. If we modify the program to fixed length records of known record length, the reading ...

I don't know exactly what you doing with the new file you are creating, but if you are just processing it, then you can just use the original file indexed.

The original file is a text file. Not a dbf file.
Do you think we can create an index on the text file?

Marc, The problem was not going through the database, but reading the text-file. Otherwhise the condition index was a good idea. Well, I was thinking that you could eliminate the export/import and just use the original file with the index set. I don't know exactly what you doing with the new file yo...

Marc Here is a snipit from a Find and replace file utility I wrote that opens any text file you like .... hope you get the gist on how to use .. Rick Lipkin Do While .not. Eof()       cFILE := ALLTRIM( A->FileName )   If ( nHANDLE := Fopen( cFILE )) > 0   Else  ...

Roa, Your example is very fast :lol: Only 2sec :shock: I tested the loop without the line AAdd( aLines, { nLine, cLine } ) With this line it take 138sec :shock: :shock: :shock: . So the aadd() take a lot of time. That's no problem, because I can direcly do the content check, and on...

Maybe you could create a conditional index containing only the records you need. Then you don't even have to move the records to another file. Time required to get the records you want, zero.

Just thinking outside the box.

Will you please try this also? #include "fivewin.ch"#define BUFSIZE   64000#define EOLCHR    CRLF#define EOLLEN    2static cBuf    := ""static nStart  := 1static lEof    := .f.//----------------------------------------------------...