The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
SalesLogix 7.2 Service Pack 2 changes the way data grids format fieldnames
Posted: 26 Mar 08 11:15 AM
|
FYI, when using a sub or funtion that has fieldname as a parameter (Such as a datagrid's OnEditing event) the value returned for the fieldname after SP2 is installed is now referenced as [TABLE ALIAS].[FIELD NAME] instead of [TABLE ALIAS]_[FIELD NAME]. (A3.ACCOUNT instead of A3_ACCOUNT).
Any code that relied on a field name that worked prior to SP2, like "if fieldname = "A3_ACCOUNT" then...", will no longer function after SP2 without altering the code.
The SQL field aliases still show in the old format "A3_ACCOUNT" when looking at the SQL of the data grid. I could not find this as a documented change in the 7.2.2 fixed issue list. |
|
|
| |
|
Re: SalesLogix 7.2 Service Pack 2 changes the way data grids format fieldnames
Posted: 27 Mar 08 9:36 AM
|
| I can confirm this issue. Fortunately for me, this is only an issue on a development database that has not yet been put live, but I have got 7.2.2 upgrades in my work pipeline in the near future, so it will be an issue there. As stated, it's a pity this isn't mentioned anywhere in the upgrade docs. |
|
|
|
Re: SalesLogix 7.2 Service Pack 2 changes the way data grids format fieldnames
Posted: 27 Mar 08 1:39 PM
|
Well the logic is pretty sound though. Instead of *forcing* the A3 prefix, which is defined by the grid at almost random, you just have to worry about the column name as it should be.
The real problem? Waiting until SP2! If it was fixed in 7.2 it'd be less of a hassle but now along with your service pack upgrade you have to touch up a bunch of old code? Not cool. I expect it going to a major revision, not so much a service pack or hotfix. |
|
|
| |
| |
| |
|