Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Circumventing 2GB Limit?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00856128
Message ID:
00856374
Views:
16
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform