slxdeveloper.com Community Forums

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!

Administration Forums - Upgrades
Forum to discuss upgrading SalesLogix from version to version. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Upgrades | New Thread

View: Search:

Author

Thread: Missing comments tab after upgrade from 6.2 to 7.2

Brian Smith
Posts: 18

Missing comments tab after upgrade from 6.2 to 7.2 Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 06 Dec 07 1:24 PM

Hi all,

Thanks for all of the great information I have acquired from this site so far. We are in the process of upgrading our old SLX 6.2 to 7.2 and I currently have a test environment where I have completed the upgrade. Things are going well for the most part but in the 6.2 client we have a tab in the Account Detail window called Comments - This tab contains a lot of free-form notes about test numbers, connectivity, etc. for our customers. It has completely disappeared in our 7.2 install, and I can't find reference to it in Architect or Administrator. Does anyone have any info on how to get this back?

Thanks,
Brian

[Reply][Quote]

Brian Smith
Posts: 18

Re: Missing comments tab after upgrade from 6.2 to 7.2 Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 06 Dec 07 2:15 PM

I see now that after the upgrade, our freeform "comments" from 6.2 made it into the NOTES column of the ACCOUNTS table, which is odd because this column is a varchar(16) and the comments are very large. I decided to use SQL to push our comments into the BUSINESS DESCRIPTION field (which we were not currently using) and move the business description box into its own tab with more space so it behaves much like our original comments window does. This is working out fine in my tests so I think we're all good. Just wanted to update this post with the results - If anyone has other suggestions I'd still be very grateful.

[Reply][Quote]

Mike Spragg
Posts: 1226

Re: Missing comments tab after upgrade from 6.2 to 7.2 Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 07 Dec 07 4:07 AM

It's not varchar(16) but text(16). This is a memo field - the 16 bit refers to a pointer to the location (as opposed to physical size) where this data is stored (up to 2Gb's of it in fact !).

[Reply][Quote]

Brian Smith
Posts: 18

Re: Missing comments tab after upgrade from 6.2 to 7.2 Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 10 Dec 07 10:59 AM

Yes of course... text not varchar. Dumb oversight on my part. Thanks again for your help!

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/26/2024 12:57:31 AM