No database that I know of :) The "flat file" database was dropped some time ago. I expect it would not have worked on it.
View Names can be different in different databases and are given by the "ViewName" column of arschema (since 7.1). For an algorithm to get the view names prior to 7.1 for all databases, look at the sample script ArSchema-Report <http://www.softwaretoolhouse.com/product/SthMupd/scriptlib/scr_Rpt-arschema.html> (also available in the Script Library). Cheers Ben -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Dale Hurtt Sent: August-29-12 15:57 To: arslist@ARSLIST.ORG Subject: Re: driver.exe, row counts... > It might be faster, but it is direct SQL and may not work on any database... > > select count(*) from HPD_Help_Desk Does Remedy support a database where the above ANSI SQL won't work? I suppose if ARS implements view names for their tables differently in another database, it would not be "HPD_Help_Desk", but does anyone know of which database that would be? Just curious because the above works on Oracle and SQL Server. Dale Hurtt _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at <http://www.arslist.org> www.arslist.org attend wwrug12 <http://www.wwrug12.com> www.wwrug12.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
smime.p7s
Description: S/MIME cryptographic signature