I've discovered a problem that seems to stem from the Office 2010 version of MS Query's interaction with the ODBC.
A basic full table grab will not return att rows if certain fields ar included in the query. Remove those and att rows are returned. I tried adding a "where <required field> is not null" clause and get the same results 3k of 14k rows. The same query via user tool brings back all the rows as expected. Kinda messes up reporting. On Wed, Aug 3, 2011 at 9:47 AM, Elry <[email protected]> wrote: > ARODBC Can return odd things if there is no "WHERE" clause. > > Even if the "WHERE" clause returns all entries. > > > On Aug 2, 8:42 am, Jonas Stumph stevnsvig <[email protected]> wrote: > > Hi again, I'll try not to hit ctrl+enter again... sorry for the triple > > posts. > > > > 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) to be able to correct and experiment faster than waiting for the GUIs > in the ODBC system in excel to refresh. > > > > I have tried several different variations of where clauses, as previously > suggested (eg. WHERE Incident_Number<> 'ThisOldString') but to no avail. > > > > BMC support is misunderstanding me, and thinks that I am trying on > different databases, wih different numbers of records, so I have tried to > clarfy my query to them. > > > > Does anyone else have any ideas of what else I can try? > > > > Best regards, Jonas Stevnsvig > > > > ********** 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 atwww.arslist.org > > attend wwrug11www.wwrug.comARSList: "Where the Answers Are" > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
