Eliminate time consuming follow up and account servicing efforts.

Use WINSALES ACTION PLANS to systematically deliver the right information to the right people at the right time.

Find more WINSALES support information at

WINSALES Support Document - sup257

Version: 5.0
Revised: 3/30/04

Error In Trigger Update Routine Creating New Activities Through Wizards

Working with wizards in WINSALES where users are creating an activity from a NEXT STEP process and receive an error in TRIG INSERT, the problem could be from to long of a text response being entered through the wizard and the program is unable to save the value. We have found with wizards where there is a text response field, if users enter more characters then the field is set up to store (maximum characters is 65) the program will give the following error once the wizard goes to save the data. There is no validation of the length of the text response in the wizard, so the data is not saved with the new activity, the value is blank.

We have found that adding logic to the triggers which control the wizard to trim the text responses to 65 characters if the value is greater then 65 solves the problem.

Click the image for larger view

Contact Silent Partner for more information.


WinSales Basic Selling System

      S       I       L       E       N       T          P      A       R       T       N       E       R      

©2002 WINSALES is a registered trademark of the Ascendium Group Inc. and
subject to the licensing agreement with Silent Partner Ltd. All rights reserved.

Share this with a friend.