Re: Designer: web apps, server validation of bulk data?

In article <7319pl$ap0$1_at_nnrp1.dejanews.com>,   mdejanews_at_pandion.u-net.com wrote:
> If I have a data entry form, implemented by using PL/SQL to write HTML, I can
> do simple validation with Javascript. Fair enough.
>
> If a field (eg product number) has to be validated against many thousand
> possibilities of course I need to validate the form on submission. If it's
> invalid the user is prompted to try again.
>
> Fair enough if I'm coding by hand, I'm OK there. What if I'm using Designer?
> I'm very, very new to Designer 2.1 and don't understand how this fits in with
> its navigation model.
>
> Do I use a pseudo PL/SQL custom event (Validate) bound to the Input Form? I
> assume that fires on form submission. If the validation fails, what does that
> server-side handler do? I suppose I want the Insert Form to appear, populated
> with what the user entered except for the part number, and with an error
> message saying what happened. Can Designer do this? What do I put in the
> Validate PL/SQL - do I send a HTTP redirect back to the insert form?
>
> Can someone explain the sequence of events and where the code goes?
>
> Any better strategies are also welcome!
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

What about a key constraint in the database? Make the database produce the error message.

Randy

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Nov 19 1998 - 21:37:45 CET