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

[Quoted] 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 Fri Mar 17 2000 - 15:24:35 CET