4Site
Support Request System
View Patch #50.028.019
Description
Patch ID:
Date Implemented:
Patch Title:
Patch Type:
Request IDs:
Bug
Enhancement
Other
02570 -
Error loading requisition line.
Symptoms:
A user entered a requisition and its lines. Later, attempting to open one of the lines, the error, "An error occurred while attempting to get this requisition from the database." Examination of the lines display showed that part of the description was in the units column and other data was shifted one column to the right.
Solution:
There is an internal procedure (InsertPrLine) that use the "tab" character to build a table that later will be loaded into the grid control, since there was no restriction on what the user can type into the txtBrief textbox you could easily insert a tab that later would be interpreted as a column jump by the InsertPrLine routine. txtBrief is now checked against the tab control code and if found will be replaced with a whitespace character. The same applies to libPGrid procedure. Note that the only way that a tab character can be entered into a 4Site text field is to type the data in using a different application and to paste it into the 4Site application.
Browse Patches
Find a Patch
Return to Request System Menu