Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Circumventing 2GB Limit?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00856128
Message ID:
00856374
Vues:
15
>Handy piece of code - you'll probably want to update it so it handles the newer data types (it hung up on a DateTime data type when I ran it on one of my tables, but I think it'll handle my client's data file fine).
>
>Thanks very much for sharing it!

Change:
If Type( "aStatistics[ 1 ]" ) == "D" Then
into:
If Type( "aStatistics[ 1 ]" ) $ "DT" Then

In the mean time I am going to rewrite it so that it does the analysis in a single pass, with the option to add details (on a per field basis, or all fields) of a SELECT Distinct - which answers the question: for a particular column, how many different values are there?

Any chance you can share your results?
censored.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform