Re: variable tabelname in FORMS

Hi Dirk,

You should make sure you have your test tables in a different schema/owner, and arrange correct access by synonyms. In that case there's no need to rename tables.

Hth,

Sybrand Bakker, Oracle DBA

Dirk Beelprez <dbeelpre_at_roularta.be> wrote in message news:7q07bk$nre$1_at_news1.skynet.be...
> I have a form that uses table-aliasses from one database to another.
>
> When I have to run that form in a test-environment my table-names are like
> OP_TABLE1TEST
>
> When that form is alright, I have to replace all OP_TABLE1TEST by
OP_TABLE1
> before I can give it to the users.
>
> Later when there's a problem or I have to make some modifications
> I have to replace all OP_TABLE1 by OP_TABLE1TEST.
>
> And so on.
>
> Is there a possibility to make the table names variable, because I have
> several tablenames in that form.
>
> I tryed via FORM---PARAMETERS---TABLE1 as char (30) and string =
> OP_TABLE1TEST
> which I can quickly change to OP_TABLE1.
>
> But in my 'select xxx from :PARAMETERS.TABLE1'
> the compiler says : Encounted the symbol "" where expected one of the
> following : Identifier/double quoted string
>
> Question : is there another posibility the solve my problem ?
>
>
> Dirk
>
>
>
Received on Wed Aug 25 1999 - 12:21:30 CDT