Re: webdb - advanced pl/sql

In article <38cc7743$1_2_at_news.ausmail.com>,   "Mark Hills" <m.hills_at_exec.com.au> wrote:
> I was wondering if anyone has done much with the option to add one's
own
> "Advanced PL/SQL" in webdb?
>
> If you have could you please enlighten me as to what sort of things
you have
> used this for and the limit of what can be achieved with it?
>
> Because I was wondering when building forms(etc) in webdb is it
possible to
> use the "Advanced PL/SQL" facility to write code that interacts with
the
> values in the forms on the page?
>
> For example, in certain situations, I would like to add one or more
buttons
> at the bottom of the page that will provide functionality based
either on
> default values or ones that the user has entered/selected in one or
more
> fields.
>
> I've tried various combinations of frame-drivers and qbe forms but I
don't
> think that the functionality I want exists in the standard Webdb
framework.
>
> Any thoughts or advice gladly received.
>
> Thanks,
> Mark Hills.
>
>

Hi Mark.
Yes, this kind of functionality doesn't exists in the current version.

When we was faced with similar problem - add some buttons that would operate with values in the form - we used JavaScript. Usual way to add JS we use is to create procedure, fill it with many htp.print() commands, which simply print the JS code, and from "Advanced PL/SQL" just call this procedure with appropriate arguments.

If you view the source of the page with a form, you can see the function findItem() and how it is used in another function checkAll(), so we use it in our scripts to access fields.

We also always create forms as "Unstructured" to better control the form layout and to insert additional HTML tags (buttons etc.)

HTH,   Zdenek

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Mar 13 2000 - 10:05:02 CET