Re: coupla WebDB questions from a newbie

Not familiar with the toolkit per se but I know PL/SQL well enough and hey, if I can't learn, what am I doing in thie business? :-)

Thanks for the reply!

Best regards -

In article <930e76$1rc$1_at_nnrp1.deja.com>,   Paul <paul_fountain_at_my-deja.com> wrote:
> You will find that the Webdb form wizards will often be a bit restrive
> for what you want to do. Are you familiar with the PL/SQL web toolkit?
> I've used stored procedures that use the web toolkit to generate
 either
> whole forms or parts of forms. Often I'll just create a skeleton page
> using the wizard in webdb and then call stored procedures to generate
> the bits I need by putting the call between the <oracle></oracle>
 tags.
>
> You can definitely use the stored procedure approach to determine
 which
> forms are shown. Just about everything in webdb is stored in packages
 so
> it doesn't make any difference whether the form you call is one that
 was
> done with a webdb wizard or a custom built form that you've done
> yourself. You just need to be able to pass the correct parameters to
 the
> particluar procedure you've called.
>
> As for your question about normalised tables, I think each case has to
> be evaluated on its own merits. The project I worked on with webdb, we
> started with normalised tables and denormalised when we found a need,
> usually to simplify or reduce query processing. When we denormalised
 we
> used triggers where appropriate to keep everything in sync.
>
> regards
>
> Paul
>
> In article <92vdvp$3dv$1_at_nnrp1.deja.com>,
> itc_at_my-deja.com wrote:
> > I am writing my first WebDB (2.2) app, and had a few questions for
> > anyone gracious enough to offer some advice:
> >
> > How does one create a Master-Detail-Detail form? The Master-Detail
> > wizard just doesn't cut it for the database design I am using.
> >
> > If one wished to call another form after submission of the current
 one,
> > would it be done by creating a link to <form.SHOW> of the form you
 want
> > to call, then writing a stored procedure to do so? If so, can one
> > examine the contents of the form before deciding which next form to
> > call?
> >
> > General technique question: right now I am coding to a normalized
> > design. Do people use this apporach for WebDB, or do they
> > use 'staging' tables matched to forms and then distribute the data
 to
> > normalized tables afterwards, or do they live with a denormalized
> > transactional design?
> >
> > Sorry for posting from deja but the place I work declines to
 install a
> > news proxy...
> >
> > TIA -
> >
> > Sent via Deja.com
> > http://www.deja.com/
> >
>
> Sent via Deja.com
> http://www.deja.com/
>

Sent via Deja.com
http://www.deja.com/ Received on Thu Jan 04 2001 - 21:44:14 CET