Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Really Big File
Message
From
14/10/1998 21:58:48
 
 
To
14/10/1998 17:35:16
Bob Lucas
The WordWare Agency
Alberta, Canada
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00146908
Message ID:
00146960
Views:
38
>I am looking for a really big data file to use in a VFP demo. I wanted something with a few hundred thousand records, like street names or postal codes or something like that I could run queries on both using DBF files and also with the data transfered to SQL Server. If someone has a file they'd like to share, or a routine that builds a big file (a few hundred megs, a few million records!) I would appreciate it.
>
>Or if you can point me to somewhere on the web where i can grab a big text file I can convert into to DBF that would be useful too.

Just build a routine that loops and appends records into a file.

CREATE CURSOR myCursor (cfield C(10), nfield i)
FOR i = 1 TO 1000000
INSERT INTO myCursor Values (SYS(2015), i)
ENDFOR

You could get as creative as you want with random values.
Erik Moore
Clientelligence
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform