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.
|