Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Really Big File
Message
From
15/10/1998 11:13:56
 
 
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:
00147150
Views:
33
You can generate ALOT of data using a cross join against multiple tables. Create a table with 10 or 12 first names, another with 10 or 12 last names (they could be random character strings) and do the same for city, state. Cross join them and you'll get the dataset that you're looking for.

-Mike

>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.
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Reply
Map
View

Click here to load this message in the networking platform