Re: WebDB - how to do an implicit query when initially displaying a form

Thanks Zdenek, I appreciate your help - again!

Regards,
Mark .

Zdenek Zavadil <zzavadil_at_my-deja.com> wrote in message news:8atf6u$gsh$1_at_nnrp1.deja.com...
> Hi Mark.
>
> In article <38d1b302_2_at_news.ausmail.com>,
> "Mark Hills" <m.hills_at_exec.com.au> wrote:
> > Hi all,
> >
> > I've got a problem when trying to update/delete records from a simple
> form
> > (based on a 2 column table) that is in the bottom frame of a frame
> driver
> > setup.
> >
> > I pass all the necessary values to the form to populate the fields
> but after
> > I've changed the required values and/or hit the "Update" or "Delete"
> buttons
> > I get oracle errors (WWV-14607 and WWV-14615,14612 which tell me that
> the
> > wwv_process_delete procedure has a problem or that my record has been
> > changed by another user - impossible!).
> >
>
> If you click "Update", WebDB generates INSERT instead of UPDATE, if the
> form is not retrieved by the key.
>
> > However, if I put a query button on the form and "Query" before I
> make my
> > changes and update or delete it works. [Thanks to Peter from the
> Metalink
> > webdb forum for that tip]
> >
> > I figure that upon the initial display of the form it doesn't know
> which
> > record it is dealing with - hence the need for doing the query. And
> simply
> > passing the values to my form, even though this includes the primary
> key for
> > the table, must not be enough.
> >
>
> Yes, that's right.
>
> > I've tried setting the "Alternate ROWID" field in the form definition
> to the
> > primary key column and sending the primary key value over as the
> value for
> > "_alt_rowid" when I call the form but still no luck.
> >
> > Does anyone have any solutions or ideas as to how to get the form to
> > recognise the record without having to use a "Query" button?
> >
> > Many TIA,
> > Mark Hills.
> >
>
> Try _rowid instead of _alt_rowid, it works for me!
>
> Zdenek
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Mar 18 2000 - 01:32:21 CET