I have a search action that worked in 3.6 that fails with an ODBC error in T2000. It seems that Tango is adding alias names to columns when group by functions are used now, and the alias produced in this one case is not valid.
SUM(ServEnd-ServStart) AS SUM_ServEnd-ServStart I'd prefer to not use a DBMS action because of the nice way the search handles null arguments. Is there a way to tell tango searches not to add the aliases? Any suggestions? Thank, Chuck Lockwood ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ LockData Technologies, Inc. 309 Main Avenue, Hawley, Pa 18428 Phone: 570-226-7340 ~ Fax: 570-226-7341 Email: [EMAIL PROTECTED] ~ http://www.lockdata.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
