Re: Dynamic form generation with Developper 2000

Jasmine,

Look into dynamic sql. You will have to give the user explicit rights to create tables as roles will be disabled when using dynamic sql. See the Oracle8 documentation for full details. Another really good source of information on using dynamic sql is "Oracle PL/SQL Programming" by Scott Urman. It is available from Oracle Press.

HTH. Brian

"zied" <jasmine.zlahiani_at_planet.tn> wrote in message news:38976025.2FD2DBF3_at_planet.tn...
>
>
> Hi,
>
> We are developping a payroll application using Oracle 8 and developper
> 2000. Among it's functionnalities, we offer the possibility for the user
> to define during
> execution time, his own table, and create them dynamically in the
> database (for exemple, the user may wish to create a table giving the
> salary vs employee pos
> ition. Until now there is no problem, a simple CREAT TABLE can do this.
> But we have to give the user the possibility to populate his new table
> using the application interface.
>
> The problem is that the table structure isn't known in advance and may
> vary from
> a table to another : logically, we have no forms associated to these
> tables because they have been created by the user. Does anyone have an
> idea on how to give
> the possibility to the user to populate the table in these conditions,
> by a dynamic form generated during execution, and based on the table
> structure. Or maybe
> another idea to explore.
>
> Thanks.
>
Received on Wed Feb 02 2000 - 14:58:19 CET