Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Really Big File
Message
De
14/10/1998 21:58:48
 
 
À
14/10/1998 17:35:16
Bob Lucas
The WordWare Agency
Alberta, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Divers
Thread ID:
00146908
Message ID:
00146960
Vues:
42
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform