>>Report used in the followng code is available at
>>
www.eetasoft.ee/reporttoascii.zip>>This is very simple report containing only three fields
>>having plenty of empty space.
>>
>>To reproduce, run the following program:
>>
>>CREATE TABLE test ( f1 c(1), F2 C(1), F3 C(1) )
>>APPEND BLANK
>>
>>FOR i=1 TO 20
>> COPY TO t
>> APPEND FROM t
>> ENDFOR
>>
>>REPLACE ALL f1 WITH TRANSFORM(RECNO()%10), ;
>> f2 WITH TRANSFORM((RECNO()+1)%10), ;
>> f3 WITH TRANSFORM( (RECNO()+2)%10)
>>
>>REPORT FORM test TO FILE test ASCII
>>CREATE TABLE test1 ( f1 c(10) )
>>APPEND FROM test.txt SDF FOR !EMPTY(F1)
>>
>>MESSAGEBOX( 'Expected '+TRANSFORM(3*RECCOUNT('test')) + CHR(13)+ ;
>> 'Actual ' +TRANSFORM(RECCOUNT('test1')) )
>>
>>
>>Observed result:
>>
>>Expected: 3145728
>>Actual: 2752428
>>
>>
>>Expected result:
>>
>>numbers in message box must be same.
>>
>>
>>Is it possible to fix this problem so that data loss does not occur ?
>
>Andrus,
>Why should they be the same ? Report definition has an impact on it. Sounds like you have a report where detail band has 3 lines (f1,f2,f3 per line) so you wait at least 3*recco() ?
Yes. I have a report (
www.eetasoft.ee/reporttoascii.zip) containing three fields in detail band:
f1
f2
f3
There are no other objects in this reports.
Andrus