Hi J.M. I would love to have a comp,I think your file would help me.
Sometimes I add 2-3 cols to a tab, add a view, change a view, change the length of a field... It sure gets hard to remember all of these little changes and make a command file to "update" the users data base. I have some offices that either didn't get our updates for the last 2 years or didn't know how to run them. There has been so many changes since them I have been worried about sending them one big upgrade. Would your program take care of this? Thanks marc --- "J.M. GRATIAS" <[EMAIL PROTECTED]> wrote: > > Gunnar, Javier : > > > > I have the same problem when I am upgrading an > application I have to > constantly update forms and/or reports on the > client's production database. > I keep wanting to develop a command file that will > allow me to pick and > choose forms and reports from the development > database and then create a > file with the commands to delete the forms from the > production database and > load the new ones, then create an executable file > that merges all files > (command, .LOB) so it can be executed in one step. > It probably would not > take very much time to so something like this, but > right now it sits at the > bottom of my priority list. > < > > > > A very good idea is to be able to seperate > "applicationat part of a > R:BASE database that is forms reports rules and so > on from real data#" > that way I could have a common application against > many databases. I am > the only one in this need- Rigt now I need to do a > lot of unload reports > and load reports in many databases to keep the > application in sync! > < > > I have the same problem since 1987 (RB System V). > My strategy is to send an empty DB to the client > (datas tables are empty, > but applications tables -forms, rules,reports ...- > are populated) and I > send to the client a CMD file that : > - check the client's DB structure (AUTOCHK OK ...) > - check that client have a fresh backup > - align the clients' DB structure to the new version > (ADD/DELETE columns), > - UNLOAD client's data to a flat file, > - copy the new (empty DB), > - copy the new app files, > - RELOAD client's data, > - check that the total number of row is unchanged > > With this CMD file, installation of new version is > totaly automatic and I > no more fear to forget a form/report. > And very easy for the client (Install a new version > is part of the menu). > > If anyone is interested, send a private mail .... > > J.M. GRATIAS, Logimatique > __________________________________________________ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/

