It sounds like that is what happened to me. I was doing great last night, making a new form. This morning after I made one little change, not only did that new form stop working, but some other forms also stopped working. The forms do use some common variables and maybe that had something to do with the problem.
I just loaded the old form and now the other forms work just fine. I hate it when I can't figure what actually went wrong. Jim I may try unloading the forms as you suggested as a quick fix in case this happens again. ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: Tuesday, June 23, 2009 2:23 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: UNLOAD LOAD FORMS & REPORTS Jim, Guess it depends on your philosophy. I keep 2 subfolder in the directory for Forms and Reports. That way if I need to reload either all I have to do is grab it and run and the form is back up and running. I've a couple of cases (very rarely) where a form just quits and a simple reload restores me to operation. Jan -----Original Message----- From: "Jim Belisle" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Tue, 23 Jun 2009 14:00:55 -0500 Subject: [RBASE-L] - Re: UNLOAD LOAD FORMS & REPORTS Karen, Once I load the backup form, do I then delete the frm and lob file from my directory? Jim ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Tuesday, June 23, 2009 1:55 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: UNLOAD LOAD FORMS & REPORTS Jim: As you mentioned, bring in your backup copy of the database, and use the right-click "unload" function in the form section of the database explorer. This will create 2 files with the name of your form, a .frm and a .lob. Then you open up your current copy of the database and at the r> prompt simply: RUN yourfilename.FRM If the .frm and .lob aren't in the current database directory, just include where it is: RUN c:\olddirectory\yourfilename.FRM The file will automatically delete the current version of the form and then bring in from the backup. You will want to make sure that SET NULL -0- is the setting both when you unload the form from your backup, and when you bring it in. That's all there is to it! Karen I am very unfamiliar with unloading and loading the forms &reports. Here is my situation: After creating a new form and then changing it this morning, somehow some of my forms and reports got messed up. I want to keep the data that has been entered for the last couple of days, so I would just like to unload the affected forms from my last backup. What is the proper procedure for this. I see the unload form function while in the forms section and have done that before but how do I load it into my database. Whenever I've tried it before, I mess things up. Jim
