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
