6/18/2025 2:28:03 AM
|
| |
| 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!
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.
|
|
|
|
Error Adding Opportunity - SLX626
Posted: 25 Apr 07 6:13 AM
|
fiogf49gjkf0d We have had an error today when a user was adding an Opportunity to a specific Contact. The error was:
An error occurred executing active form script (System:Insert Opportunity). Multiple-step operation generated errors. Check each status value. at line 740, char 23
This is that line in Inset Opportunity:
objRS.Fields("WORKPHONE").Value = "" & .Fields("WORKPHONE").Value 'DNL
I notice that the length of CONTACT.WORKPHONE is 32 but the length of WORKPHONE in the Product Grid is 24, so if we have a phone number longer than 24 we get this error, which doesn't happen very often, but can where there are lots of trailing spaces, or the user enters two phone numbers in the field.
To remove the trailing spaces I already added a Trim statement, but is it OK for me to change the length to 32 in this statement where it's defining the Grid?
.Fields.Append "WORKPHONE", adVarChar, 24 'DNL
In the short term the user has shortened the Work Phone to less than 24
[Edit] we have 242 Contacts with LEN(WORKPHONE) > 24
|
|
|
|
Re: Error Adding Opportunity - SLX626
Posted: 25 Apr 07 7:05 PM
|
fiogf49gjkf0d As it's X32 in the database, it makes no sense to have the datagrid size X24, as you've found - changing its width, exactly as you suggest, sounds like the best solution to me. |
|
|
|
Re: Error Adding Opportunity - SLX626
Posted: 27 Apr 07 2:40 PM
|
fiogf49gjkf0d That is an issue with more that just the workphone. When the recordsets are defined they are several fields including account name that are defined smaller than the fields are defined in the database. I beleive those issues have been resolved in later versions of SLX than what you are on. |
|
|
|
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!
|
|
|
|
|
|
|
|