Brad,
You make me feel good in stating you have been converting from 7.6 to 9.1 over the past eleven months. I am in the process myself of converting over to 9.5 from 7.6. I have not been at it that long but it is definitely a process. I will keep this post and show it to the boss if he gets impatient. James Belisle Making Information Systems People Friendly Since 1990 ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Brad Davidson Sent: Friday, August 24, 2012 1:01 PM 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.
