http://forums.method.me/cs/forums/13.aspxAsk technical support questions, how do I? Questions... Or anything else you want to know from the Method Team and other Method users.enCommunityServer 2007.1 SP2 (Build: 31113.47)http://forums.method.me/cs/forums/thread/25349.aspxTue, 20 Jan 2015 19:00:23 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:25349BLCPA0http://forums.method.me/cs/forums/thread/25349.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=25349<p><span style="overflow:hidden;" id="mce_0_start">Great, thank you Justin.&nbsp; This worked!</span></p>http://forums.method.me/cs/forums/thread/25329.aspxMon, 19 Jan 2015 18:29:40 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:25329Method_Justin0http://forums.method.me/cs/forums/thread/25329.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=25329<p><span id="mce_0_start" style="overflow:hidden;">Hi BLCPA,</span></p> <p><span id="mce_0_start" style="overflow:hidden;"></span>Try replacing the full&nbsp;<em>viewTable.FieldName&nbsp;</em>with just the&nbsp;<em>FieldName</em>. I was able to get it to function this way.</p> <p>Let me know if that helps.</p> <p>- Justin</p>http://forums.method.me/cs/forums/thread/25320.aspxSat, 17 Jan 2015 05:34:16 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:25320BLCPA0http://forums.method.me/cs/forums/thread/25320.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=25320<p>I am creating a screen based on the Customer table and have a grid.&nbsp; I want to have multiple fields in a single column, so am trying to use a SQL override.&nbsp; I copied the same code that is in the Contact List:</p> <p>&#39;&lt;b&gt;&#39; + ISNULL(viewContacts.AssignedTo,&#39;&#39;) + &#39;&lt;/b&gt;&lt;br /&gt;&#39; + &#39;&lt;i&gt;&#39;&nbsp; + ISNULL(viewContacts.SpecialType,&#39;&#39;) + &#39;&lt;/i&gt;&lt;br /&gt;&#39; + ISNULL(viewContacts.Title,&#39;&#39;)</p> <p>I made the following modifications:</p> <p>&#39;&lt;b&gt;&#39; + ISNULL(viewCustomer<span style="overflow:hidden;" id="mce_0_start"></span>.FullName<span style="overflow:hidden;" id="mce_1_start"></span>,&#39;&#39;) + &#39;&lt;/b&gt;&lt;br /&gt;&#39; + &#39;&lt;i&gt;&#39;&nbsp; + ISNULL(viewCustomer.<span style="overflow:hidden;" id="mce_6_start">AssignedTo</span><span style="overflow:hidden;" id="mce_2_start"></span><span style="overflow:hidden;" id="mce_4_end"></span>,&#39;&#39;) + &#39;&lt;/i&gt;&lt;br /&gt;&#39;&nbsp;<span style="overflow:hidden;" id="mce_7_start"></span></p> <p><span style="overflow:hidden;"><br />Seems like the code is identical.&nbsp; I have verified the table and field names are accurate.&nbsp; However, when I publish and load the page, I get an &quot;Error Generating Grid&quot; message.</span></p> <p><span style="overflow:hidden;"><br />Can you tell me where I am going wrong on this?<br /></span></p>