Login / Register  search  syndication  about

SalesLogix Support

SalesLogix Cloud / Web / LAN Support Topics from Mark Duthoy

Updating the DB Manager to Lengthen Fields For SalesLogix Web Deployments

Recently we ran into a problems with a user adding products to an Account tab on the web client. The exact error was - The statement has been terminated : string or binary data would be truncated. What the user was attempting to do was add several products in a multiple picklist field and the web client new the data exceeded the length of the field. Here are the steps we took to correct the issue. 1. In the Administrator open the DB Manager 2. Under the Account listing click on the plus sign and open the Prod_Account_Ext table 3. Find the Product Field, rt click, choose properties, and change the Field Length to 256 4. Click OK to close the Product Field window 5. At the top of the Database Manager find the Apply Changes Arrow and Click it 6. Close the Administrator 7. Open the Application Architect and Rebuild the web platform, deploy the slxclient, and run an iisreset. This method can be used to increase the size of VarChar fields. A word of caution, only perform these steps on a quite system and always create a backup first.
What's This?
  
Bookmark and Share

About Mark Duthoy

  


Related Content
   Infor CRM (Formerly Saleslogix) Iterating through all tabs on a Page
 Using the TabWorskpace you can iterate through all the tabs on a page and do something with them, l
Posted on Jun 19, 2015 by Kris Halsrud to Kris Halsrud's Blog
 
   Infor CRM (Formerly Saleslogix) Hiding Tabs at Runtime Without Using Modules
 As Ryan wrote a long time ago, you can create a module and add it to a page in the Infor CRM web cl
Posted on Jun 10, 2015 by Kris Halsrud to Kris Halsrud's Blog
 
   How I assign ownership to a group of Leads in Infor CRM?
There is a tool within Infor CRM to align Accounts to different Account Owners. It is called Territory Re
Posted on Jun 05, 2015 by Dale Richter to Infor CRM Questions & Answers
 
   Infor CRM (Formerly Saleslogix) Adding a Client Side Confirmation on a Dependency Lookup in the Web Client
 We recently had a client who wanted to have a user confirmation prompt before a user was allowed to
Posted on May 28, 2015 by Kris Halsrud to Kris Halsrud's Blog
 
   Infor CRM (Formerly Saleslogix) Embedding quickforms on quickforms
 I recently had a client who needed to have a lot of elements on a form.  They wanted a kind of
Posted on May 20, 2015 by Kris Halsrud to Kris Halsrud's Blog
 
Comments

 

Twitter Trackbacks for Updating the DB Manager to Lengthen Fields For SalesLogix Web Deployments - SalesLogix Support [customerfx.com] on Topsy.com said:

Pingback from  Twitter Trackbacks for                 Updating the DB Manager to Lengthen Fields For SalesLogix Web Deployments - SalesLogix Support         [customerfx.com]        on Topsy.com

June 19, 2010 2:01 AM

Leave a Comment

(required)  
(optional)
(required)  
Add
All contents Copyright © 2015 Customer FX Corporation
Customer FX Corporation
2324 University Avenue West, Suite 115
Saint Paul, Minnesota 55114
Tel: 800.728.5783

  Follow @CustomerFX on twitter
Follow the best news, tips, and articles
  Subscribe to Customer FX on youtube
Watch SalesLogix tutorial videos from Customer FX
Login / Register