[RBASE-L] - Re: Cannot Save a Revised Form (Error (122)) -Version9.1.5.20816 (64)

[Bruce Chitiea]

Just think of this list as "herd immunity". :)

Bruce

-------- Original Message --------
Subject: [RBASE-L] - Re: Cannot Save a Revised Form (Error (122))
-Version 9.1.5.20816 (64)
From: William Stacy <william.e.st...@gmail.com>
Date: Fri, August 24, 2012 11:46 am
To: rbase-l@rbase.com (RBASE-L Mailing List)

I think I probably caused it by messing with the date and time formats, somehow slipping an extra character in there.  Anyway, the fix John gave was certainly quick, easy and painless.

On Fri, Aug 24, 2012 at 11:23 AM, Dan Goldberg <d...@lancecamper.com> wrote:

I will have to remember this since it has came up twice in a day!

 

Dan

 

From: Brad Davidson

Sent: Friday, August 24, 2012 11:14 AM

To: RBASE-L Mailing List

Subject: [RBASE-L] - Re: Cannot Save a Revised Form (Error (122)) - Version 9.1.5.20816 (64)

Yep, you’re right on that, Dan! And, a fantastic follow-up from John M. to focus my attention to the resolution – done!

 

Thank you John and Dan,

Brad Davidson

 

From: rbase-l@rbase.com [mailto:rbase-l@rbase.com] On Behalf Of Dan Goldberg
Sent: Friday, August 24, 2012 11:12 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Cannot Save a Revised Form (Error (122)) - Version 9.1.5.20816 (64)

 

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.

--
William Stacy, O.D.

Please visit my website by clicking on :

http://www.folsomeye.net