Re: 4GL and .frm organization

Michael J. Kuhn writes: > The basic problem I am having is trying to figure the best way > to store the .frm files based on the fact that the > open form xxxx from "f" > does not allow a variable to replace the "f" value. To me this > means my only choices are: > 1. hard code path names ie. "/usr2/dbdir/bin/myform" > 2. "myform" > myform must be in current directory or in the > directory indicated by DBPATH > 3. "bin/myform" > append this to DBPATH > What I would like to do is have > DBPATH = /usr2/dbdir > all of my databases would be in this directory. ... > 1. How do you use the DBPATH and the PATH to provide access to > multiple databases and application systems? One possibility you may be missing: DBPATH is not limited to a single directory, it can be a colon separated list, like /usr2/mydb:/usr3/theirdb:/usr2/experimental This means that there isn't any strong reason to put all the databases in one directory. I have a directory for each database, and keep the forms for each database in its directory. This doesn't, however, solve the problem of keeping the names of the forms distinct: if you have two forms with the same name, 4gl will presumably (I haven't checked) always open the first one it finds along the DBPATH, and so the other(s) will never be found. I don't see any way to avoid the administrative hassle of keeping the form names distinct. -- Harry Bochner -- bochner@das.harvard.edu