variable tabelname in FORMS

From: Dirk Beelprez <dbeelpre_at_roularta.be>
Date: Wed, 25 Aug 1999 09:50:39 +0200
Message-ID: <7q07bk$nre$1@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 - 02:50:39 CDT