I wonder if anyone else has seen this error and has some advice on what to look for to resolve.
"Error - Column Sys_Form_Mod_TS must be a valid DateTime (122)" After attempting to revise an object in form designer, noted changes were not being saved. So, performed an unload/run on the entire database. Over the years, this routine has cleared up a myriad of errors with our database. After the rebuilding of the DB, and upon saving the form with minor revision, got the error above. Happens for any/all forms - cannot save any forms which have been revised, even with a simple pixel move of an existing object. So, checked out contents of Sys_Columns for this column to find it references Sys_Table_ID of 24, which is the Sys_Forms3 system table. Then, scanned down the column, Sys_Form_Mod_TS to see if there was any data which was not a datetime value - they all look good to me. Kinda lost at this point. Don't know if one of the forms have a corrupted datetime column, or, should I be looking at the sys_forms3 table for something else ?? Any ideas what else to look for? Have made a ton of form changes in past 3 weeks since converting from 7.6 to 9.1(64), an eleven month project for me (updated syntax, redesigned forms, reports, and new menu driven EFF's, etc. Thank you! Brad Davidson Aero-Craft Hydraulics, Inc.
