4Site
Support Request System
View Patch #60.101.081
Description
Patch ID:
Date Implemented:
Patch Title:
Patch Type:
Request IDs:
Bug
Enhancement
Other
03803 -
Error printing reorder report
Symptoms:
Error printing reorder report: sql errors - char to smalldatetime conversion error; - string or binary data truncation error.
Solution:
on reorderlist.rpt - Adjusted column spacing and alignment on reoMdiCh.frm - used the SqlDate( ) function to format date fields in the insert into the r_reorders statement - in the SetupGrigLine subroutine, changed the call to libGetDate( ) to "Both" date&time for date fields - in LoadGridLinesToRptTable: subroutine corrected case structure to correct field formatting on table reload script - Adjusted widths of string columns to accommodate max size of concatenated data sent in insert statements.
Browse Patches
Find a Patch
Return to Request System Menu
