Simplicty and flexibility!


Migrating forms and procedures in database 4.53


Started by Don Myers
Search
You will need to Sign In to be able to add or comment on the forum!

Migrating forms and procedures in database 4.53

Cannot remember how to move profs etc developed / modified at an offsite copy of database to the onsite database .. A .din file was part of it I think and maybe an utility file (inst.exe). Cannot find any copy of inst.exe . Can anyone Remember how to do this? I know it's in the dinosaur era but some businesses are still lumbering on. 

Thank you


Written by Don Myers 09/08/16 at 14:47:29 DataEase for Windows 5.x and before...

Re:Migrating forms and procedures in database 4.53

There was a 3rd party software called distribw.exe

This connected to the DataEase Dos application and you could choose install, replace, replace with data.....then install.din file was created


Written by Josef Vella 10/08/16 at 05:53:59 DataEase for Windows 5.x and before...

Re:Re:Migrating forms and procedures in database 4.53

Hi Dan.

You don't need any program, it is simply a text file called SOMETHING.DIN ex INSTALL.DIN

the format of this file is rather straight forward:

FORM:

install form FORMNAME from: FORMNAME.dba ;
ex : install form CUSTOMERS from: custaaab.dba ;

Now the form/table is installed so the next bit is data.

New Table:

Install form FORMNAME data: FORMNAME.dbm ;
ex. install form CUSTOMERS data: custaaab.dbm ;

These too go together when you install a new form.

If you re replacing and EXISTING form then the format is:

replace form FORMNAME from: FORMNAME.dba ;
ex. replace form CUSTOMERS from: custaaac.dba ;

the existing data will be reorganised and everything will be honkey dorey.

DQL/REPORT

The process for installing/replacing DQL and Reports are the same.

Install procedure PROCEDURENAME from: PROCEDURE.dbr ;
install report REPORTNAME from REPORT.dbr ;

if you want to replace a form/procedure the format is

replace procedure PROCEDURENAME from: PROCEDURE.dbr ;

replace report REPORTNAME from REPORT.dbr ;

DATA

We have shown above how you replace a .DBM file but maybe you just want to add data ex. to Relationships or to another support table etc.

You define an import definition (.dbi) inn the donor app, export the data to a file that match the .dbi and then simply include the command

import from IMPORT.dbi ;

ex. 
import from NewRel.dbi ;

a typical INSTALL.DIN file could look like this.

install form CUSTOMERS from: custaaab.dba ;
install form CUSTOMERS data: custaaab.dbm ;
replace form USERS from useraaac.dba;
Install procedure LISTUSER from: listaaaa.dbr ;
install report ACCOUNTS from accoaaab.dbr 
replace procedure NEWUSERS from newuaaa.dbr ;
import from Newrel.dbi ;

Make sure the install.din and the files you want to install is in the same directory (all of them).

Then you open 4.53 and from the Main Menu it is 

7-6-5-1

Then you type in the full path to your DIN file and off you go.

NB! Obviously take a backup first!!!!

PS! If you have problem with finding the correct file names simply list out the Application Status for the different objects.

From Main Menu.
6-1

APPLIKASJON STATUS
SKILLER: Fortsett prosedyre   UT: Avbryt prosedyre  PgUp: Tilbake

Antall prosedyrer/rapporter: 154 Nr. PROSEDYRE NAVN DISK FIL NAVN FIL STØRR bytes --- -------------------- --------------- --------------- 1. FAKTURERING B:FAKTDAAA.DBR 1093 2. FAKTURA_OPPD_STAT B:FAKTDAAB.DBR 16575 3. FAKTURA_SISTE_NR B:FAKTDAAC.DBR 738 4. ORDREBEKREFTELSE B:ORDRDAAA.DBR 5855 5. HVOR_ER_DU_FREMOVER B:HVORDAAA.DBR 2114 Data-entry skjema B:HVORDAAA.DBF 2247 6. KUNDELISTE B:KUNDDAAA.DBR 2533 Data-entry skjema B:KUNDDAAA.DBF 2105 7. SALGS_STAT B:SALGDAAA.DBR 4837 Data-entry skjema B:SALGDAAA.DBF 2506 8. OBS-KUNDER B:OBSKDAAA.DBR 2392 Data-entry skjema B:OBSKDAAA.DBF 2133 9. KUNDEETIKETTER B:KUNDDAAB.DBR 1488 Data-entry skjema B:KUNDDAAB.DBF 2134 10. SLIPPER_INNSTILLING B:SLIPDAAA.DBR 829 Data-entry skjema B:SLIPDAAA.DBF 1407 11. KUNDELISTE_ALLE B:KUNDDAAC.DBR 2119 Data-entry skjema B:KUNDDAAC.DBF 1969 ESCUT Sh-F9SKRIV B:\ NoOffice 10/08/16 14:35:48


Written by DataEase 10/08/16 at 13:17:11 LegEasy DOS

Re:Re:Migrating forms and procedures in database 4.53

Thank you for the information.


Written by Don Myers 10/08/16 at 22:48:41 DataEase for Windows 5.x and before...

Re:Re:Re:Migrating forms and procedures in database 4.53

Thanks so much for such a clear description and representation .. that makes me feel confident.

I intend to use your examples. I really appreciate the help.


Written by Don Myers 10/08/16 at 22:50:28 LegEasy DOS
DG3_ForumList