Hi again.
I am still fiddling with this problem, concering ARODBC and the number
of records to be returned.
I and querying the incident form on a server with 12000 records, and
getting very big variations in how many records are being returned. I
started in excel, and moved to VBscript to 1) ascertain whether it was
an excel or ARODBC error. and 2)
********** SELECT with approximately 60 records returned, of 12000 total
SELECT
*
FROM
HPD_Help_Desk
ORDER BY
Incident_Number DESC
********** SELECT with approximately 1000 records returned, of 12000 total
SELECT
Incident_Number,
Product_Categorization_Tier_1,
Product_Categorization_Tier_2,
Product_Categorization_Tier_3,
First_Name,
Last_Name,
Site,
Status,
Priority,
Assignee,
Assigned_Group,
Assignee_Login_ID,
Categorization_Tier_1,
Categorization_Tier_2,
Categorization_Tier_3,
Corporate_ID,
Reported_Source,
Service_Type,
Submit_Date,
Submitter
FROM
HPD_Help_Desk
ORDER BY
Incident_Number DESC
********** SELECT with approximately 9500 records returned, of 12000 total
SELECT
Incident_Number,
Product_Categorization_Tier_1,
Product_Categorization_Tier_2,
Product_Categorization_Tier_3,
First_Name,
Last_Name,
Site,
Status,
Priority,
Assignee,
Assigned_Group,
Assignee_Login_ID,
Categorization_Tier_1,
Categorization_Tier_2,
Categorization_Tier_3,
Corporate_ID,
Reported_Source,
Submit_Date,
Submitter
FROM
HPD_Help_Desk
ORDER BY
Incident_Number DESC
********** SELECT with 12000 records returned, of 12000 total
SELECT
Incident_Number,
Product_Categorization_Tier_1,
Product_Categorization_Tier_2,
Product_Categorization_Tier_3,
First_Name,
Last_Name,
Site,
Status,
Priority,
Assignee,
Assigned_Group,
Assignee_Login_ID,
Corporate_ID,
Reported_Source,
Submit_Date,
Submitter
FROM
HPD_Help_Desk
ORDER BY
Incident_Number DESC
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"