Print Page | Close Window

Increasing Field Length in Customer Email Address

Printed From: Microsoft Dynamics Forums
Category: Microsoft Dynamics SL (Solomon)
Forum Name: SL - Installation and Administration
Forum Discription: Installation, Upgrade, Service Pack, Security, Database, Administration, SQL Server, Login Issues, System Errors, Performance, EDI, Business Portal, and related topics
URL: http://www.MicrosoftDynamicsForums.com/forums/forum_posts.asp?TID=4251
Printed Date: March 30 2020 at 1:50am


Topic: Increasing Field Length in Customer Email Address
Posted By: kevinmcg
Subject: Increasing Field Length in Customer Email Address
Date Posted: February 03 2010 at 8:54am
I Customer table the email address field is not enough characters, is there an easy way to increase without breaking anything in SQL.



Replies:
Posted By: jhunter77082
Date Posted: February 04 2010 at 2:27pm
No... You cannot increase the length of ANY field in SL without breaking it.
 
You can, however, use a user field to hold the information and put it on the screen instead.  That is... if you can find one long enough.
 
There are a few 3rd party products that can also add a number of user fields of various lengths to SL that can then be used for storing information.
 
Let me know if you need the names.


-------------
John Hunter
MCSE, MCDBA
MBS Certified Master - SL Application - SL Installation and Configuration
Microsoft Certified Business Management Solutions Specialist - Application Dynamics SL, AX


Posted By: kevinmcg
Date Posted: February 16 2010 at 11:45am
We already use ASI EMail but if the Customer and Vendor field length is only thirty we have to manually update and change the email in ASI email addon, kind of a pain in the ass


Posted By: david
Date Posted: December 19 2011 at 2:27am
I have this EXACT requirement now.... anyone developed a solution to longer email addresses in SL6.5 ??





Print Page | Close Window