Below is a typical result set from an MS-ACCESS Database table.
Considering the following ODBC SQL statement embedded within a Perl
script.
Notice the top two group counts. 11 null and 2 blank IssueCategory
column
Values. If you try to load this data to a PERL associative array as
key/
Value pairs, the null key won't load to the associative array. So you
Thus loose this grouping if you later try to load that group to a GUI
ListView. Just wanted to bring this to everyones attention since it
Is an issue that goes undetected until you try and balance the
individual
Group counts to a total count.
SELECT IssueCategory, COUNT(*) AS Cnt
FROM Tracker
GROUP BY IssueCategory
ORDER BY IssueCategory;
RESULT SET
----------
11 #-- NULL
2 #-- BLANK i.e. Empty
Adding a Trading Partner 2
Adding Data 1
AP export error 1
Bill Manager 18
Can't Load 36
Charges in Wrong Table 43
Data Entry 3
Data Error 1
Eric Hansen
Dallas, Texas USA
