Marc - Actually, you CAN update an open form - the user will just get the new version of it the next time they open it. However, that's probably not the recommended way to do that. :)
So, do this instead: In the program that calls your MainMenu, pre-define a variable to some value: SET VAR fButton INTEGER = 0 EDIT USING MainMenu IF fButton = 1 THEN RUN your install program here ENDIF ... Then set up the menu choice on the MainMenu form that the user selects to run the update just has to have these actions: SET VAR fButton = 1 CLOSEWINDOW RETURN That way the form is closed when your update program is running. Sami -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Sent: Monday, October 31, 2005 1:56 PM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: updating users Thanks Sami, Javier and Victor I use to do something like that in 6.x when I had a Pulldown menu. Now my Main Menu is a form so updating that form would be a problem. All I can think of is have a choose command to let the user go into the Maim Menu or do an update. Marc ----- Original Message ----- From: "Sami Aaron" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Monday, October 31, 2005 12:07 PM Subject: [RBG7-L] - RE: updating users > Marc - > > I usually create a menu choice for the user to "Install Program Updates". > This menu choice always looks for a special file, Install.sms, to run. > > For your example, just unload the forms and reports to files (use the > right-click option in the Database Explorer, and it will add the line "DROP > REPORT whatever" to the top of the file so that the old report or form will > be deleted before the new one is loaded). > > Create your special install file as this simplified version shows: > > SET NULL -0- > SET MESSAGES ON > SET ERROR MESSAGES ON > CONNECT databasename --If not already connected via your menu > RUN form1.frm > RUN form2.frm > RUN report1.rpt > RUN report2.rpt > > DELETE form1.frm > DELETE form1.lob > DELETE form2.frm > DELETE form2.lob > DELETE report1.rpt > DELETE report1.lob > DELETE report2.rpt > DELETE report2.lob > RETURN > > Then zip up the forms and reports files along with the install file and have > the user unzip them to the database folder. They then run your program > normally, and select the "Install Program Updates" option. > > To get more complex, add an error check as the file is installed and delete > or replace the original Install.sms file after the user has successfully > installed it. > > Sami Aaron > Software Management Specialists > 913-915-1971 > [EMAIL PROTECTED] > > > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Marc > Sent: Monday, October 31, 2005 11:26 AM > To: RBG7-L Mailing List > Subject: [RBG7-L] - updating users > > Hi > > I have several out of state users and was wondering > what is the best way to update their forms and reports. > > > Thanks > >
