This bug is still in 6.1,
<i><font color="#663300">The following line of code in the CBizObj.OnNew() will not work if you have more than one table in your view:
<B>lcBaseTable = SUBSTR(lcBaseTable, AT("!", lcBaseTable) + 1)</B>
If you have more than one table in a view this line of code will yield something like <B>customer,product!address</B>. The only way around this (aside from simply not using more than one table in your view) is to assume that the first table is always the base table. Although I have not seen any examples where this is not the case I am not positive that this will <I>always</I> be the case. The revised code will be:
<B>
lcBaseTable = SUBSTR(lcBaseTable, AT("!", lcBaseTable) + 1)
lnLength = IIF(AT(",",lcBaseTable)#0,AT(",",lcBaseTable)-1,LEN(lcBaseTable))
lcBaseTable = LEFT(lcBaseTable,lnLength)</B>
</font></i>
Jim Hansen
Canyon Country Consulting
©2001 James H. Hansen |
