John Minyo just answered on the same error.
Please check your DATE and TIME settings. R>SHOW DATE DATE format MM/DD/YYYY DATE sequence MMDDYYYY Century threshold YEAR is 30 Default CENTURY is 19 R>SHOW TIME TIME format HH:MM:SS TIME sequence HHMMSS Make sure the format and sequence for both the DATE and TIME are valid. There should not be quotes around the setting values. If the TIME format uses seconds, then the TIME sequence should also use seconds. Best regards, John Minyo II Customer Service R:BASE Technologies, Inc. P: 1+724.733.0053 From: Brad Davidson Sent: Friday, August 24, 2012 11:00 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Cannot Save a Revised Form (Error (122)) - Version 9.1.5.20816 (64) 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.
