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/29013.aspxTue, 22 Sep 2015 18:58:26 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:29013jsenick0http://forums.method.me/cs/forums/thread/29013.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=29013<p><span style="overflow:hidden;" id="mce_0_start">Using viewaccCustomer.fieldName was the answer you needed as discovered by <span style="overflow:hidden;" id="mce_2_start"></span><a title="SQL Override Table Name" href="https://www.method.me:443/cs/forums/p/5538/21006.aspx#21006">MikeH and confirmed by MethodGreg<span style="overflow:hidden;" id="mce_1_start"><span style="overflow:hidden;" id="mce_2_end"></span></span></a>.&nbsp; I just found this golden nugget of info.<span style="overflow:hidden;" id="mce_5_start"></span></span></p> <p></p> <p>James</p>http://forums.method.me/cs/forums/thread/18343.aspxThu, 18 Jul 2013 20:20:35 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:18343Method_Jason0http://forums.method.me/cs/forums/thread/18343.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=18343<p><span id="mce_0_start" style="overflow:hidden;">Andy,&nbsp;</span></p> <p>We don&#39;t have any written documentation. However, you can take a look at how our stock <span id="mce_2_start" style="overflow:hidden;"></span><em>Customer List <span id="mce_2_end" style="overflow:hidden;"></span></em>screen works to get an idea of how&nbsp;<span id="mce_1_start" style="overflow:hidden;">you can implement something similar. The image below is from the <span id="mce_4_start" style="overflow:hidden;"></span><span id="mce_6_start" style="overflow:hidden;"></span><em>Advanced Properties<span id="mce_6_end" style="overflow:hidden;"></span></em><span id="mce_4_end" style="overflow:hidden;"></span> of the <span id="mce_5_start" style="overflow:hidden;"><span id="mce_8_start" style="overflow:hidden;"></span><em>Name<span id="mce_8_end" style="overflow:hidden;"></span></em> field in the&nbsp;</span><span id="mce_10_start" style="overflow:hidden;"></span><em>Contacts<span id="mce_10_end" style="overflow:hidden;"></span></em> grid.&nbsp;<span id="mce_12_start" style="overflow:hidden;"><span id="mce_13_start" style="overflow:hidden;">Hope this helps.&nbsp;</span></span></span></p> <p><span style="overflow:hidden;"><span style="overflow:hidden;">Jason&nbsp;</span></span></p> <p><span style="overflow:hidden;"><span style="overflow:hidden;"><img src="http://i.imgur.com/42GZaL2.png" width="696" height="123" alt="" /></span></span></p>http://forums.method.me/cs/forums/thread/18335.aspxThu, 18 Jul 2013 09:37:09 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:18335andy0http://forums.method.me/cs/forums/thread/18335.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=18335<p>Is there any written documentation on implementing SQL overrides within grids?</p> <p><span id="mce_8_start" style="overflow:hidden;"><span id="mce_9_start" style="overflow:hidden;"></span></span>I am working with a grid based on the Customer table. I have <span id="mce_2_start" style="overflow:hidden;"></span>the <span id="mce_5_start" style="overflow:hidden;"><span id="mce_6_start" style="overflow:hidden;"></span></span><span id="mce_7_start" style="overflow:hidden;"></span><span id="mce_10_start" style="overflow:hidden;">Contacts</span>&nbsp;<span id="mce_7_end" style="overflow:hidden;"></span>field in the grid<span id="mce_3_start" style="overflow:hidden;">. I have the following override script...</span></p> <p><span style="overflow:hidden;"><span style="overflow:hidden;"><span style="overflow:hidden;"></span></span></span></p> <p>&#39;&lt;b&gt;&#39; + ISNULL(viewCustomer.Contact,&#39;&#39;) + &#39;&lt;/b&gt;&lt;br /&gt;&#39; + &#39;&lt;i&gt;&#39;&nbsp; + viewCustomer.FullName + &#39;&lt;/i&gt;&lt;br /&gt;&#39; + ISNULL(viewCustomer.CompanyName,&#39;&#39;)</p> <p>...and the following filter fields...</p> <p><span style="overflow:hidden;"><span id="mce_15_start" style="overflow:hidden;"></span></span>Contact,FullName,CompanyName</p> <p>I keep getting &#39;Error Generating Grid&#39;.<span id="mce_14_start" style="overflow:hidden;"></span></p> <p><span style="overflow:hidden;">Thanks.</span></p> <p><span id="mce_12_start" style="overflow:hidden;"></span></p> <p><span id="mce_8_end" style="overflow:hidden;"><span id="mce_9_end" style="overflow:hidden;"><span id="mce_11_start" style="overflow:hidden;"></span></span></span><span style="overflow:hidden;"><br /></span></p>