Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data loss using REPORT TO FILE ASCII
Message
From
14/01/2003 12:43:33
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Data loss using REPORT TO FILE ASCII
Miscellaneous
Thread ID:
00741527
Message ID:
00741527
Views:
59
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
Next
Reply
Map
View

Click here to load this message in the networking platform