Stephen, I would check the ownership of the tables and its objects.. maybe it has lost the dbo role and assumed the role aradmin? This change of roles often happens on MS-SQL under certain circumstances after a DB restore from a backup..
Cheers Joe ________________________________ From: Stephen <[email protected]> To: [email protected] Sent: Mon, August 9, 2010 3:57:47 PM Subject: ARS 7.5 "Ambiguous column name 'C1'" Hey List! I am in the process of upgrading a ARS 6.3 system to ARS 7.5p6. Windows Server 2003. SQL Server 2005. In a number of active links I use for generation of various reports I push a new record to a command form, filters generate a file which gets attached to the command form. The AL then retrieves the newly generated file from the command form. This has worked fine for years with ARS 6.3. Now, anytime I try to retrieve an attachment in this scenerio ARS generates the following SQL backened query, which results in "Ambiguous column name 'C1'" error. SELECT T382.C1,convert(varchar(15),B382.CO536880912)+';'+convert(varchar(15),B382.CC536880912)+';'+B382.C536880912 B382C536880912 FROM T382 LEFT OUTER JOIN B382 ON (T382.C1 = B382.C1) WHERE (T382.C1 = 'ACT000003779282') ORDER BY C1 DESC The is in the ORDER BY section. It should be ORDER BY T382.C1 instead of ORDER BY C1. This appears to be a bug within ARS when the attachment table is joined. Has anything experienced this error? Is there a workaround? Thanks. Stephen Heider Remedy Skilled Professional _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
