4Site
Support Request System
View Patch #50.018.011
Description
Patch ID:
Date Implemented:
Patch Title:
Patch Type:
Request IDs:
Bug
Enhancement
Other
02036 -
Custom Entries Not Working But SQL Within Does Work
Symptoms:
Setting up a custom entry validate against a database table and using an SQL statement, everything works as expected. Eg: Select binid from dbo.stbin you get the correct results. But, when you fill in the 3 other fields, table/key/data eg: Table name = dbo.stbin Key = whseid Data = binid it does not work.
Solution:
An error in the constructed SQL prevented the table/key/data lookup from retrieving the appropriate data. This has been corrected.
Browse Patches
Find a Patch
Return to Request System Menu