Re: 4GL and $DBNAME

Another way is create a dummy database with all the table schemas (only the table structure). Open this dummy database by default. On runtime, close this dummy and open the right database that you pick from the environment variable. Here the problem is the DBA got to maintain the dummy database too, so that the dummy's schema is in sync with the production database schema. Rgds .. Mahesh G. Bruce McDougald wrote in message <358ECB80.F49BACB8@grocerybiz.com>... >I want to write 4gl code that will grab the database name from an env. >variable at compile time. My problem is that the compiler is choking on >my variable definitions. Is there a way around this? > >EX: >main > call init() > call process() >end main > >function init() > define dbname > let dbname = fgl_getenv("DBNAME") > > database dbname >end function > >function process() > define l_var like table.column ## Compiler will choke here >.... >end function >