Re: Change base table at run-time with Form 4.5

You do not need to change your base table. There are two better solutions.

First, get your test data and your production data into two separate databases with different connect strings, different resource pools, and different security.

Second, if this is not possible, create two separate identical schemas say TEST. and PROD. Remove all schema references from your Forms application (just say EMP not PROD.EMP). Now create a set of personal synonyms for each tester / developer that point to the TEST schema:

CREATE SYNONYM EMP FOR TEST.EMP; Do the same for each production user:

CREATE SYNONYM EMP FOR PROD.EMP; Now your forms will run on two different sets of data depending on who is logged in.

• Ronald K. Olcott, President
• Interlude Enterprises
• interld808_at_aol.com

In article <35EEC17E.734A931A_at_att.com>,   Stan Buskus <buskus_at_att.com> wrote:
> Hi,
> I'm developing an app with Forms 4.5 and I would like to change the base
> table at run-time. The reason is that I want to have to databases; one
> for production and one for testing. Consequently when a users connects
> the base table will change to the production schema and for a tester the
> base table will change to a test schema. If anyone has any ideas I would
> like to hear them.
>
> Stan Buskus
>
>

[Quoted] -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Sep 04 1998 - 20:42:10 CEST