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

I've got a problem when trying to update/delete records from a simple form [Quoted] (based on a 2 column table) that is in the bottom frame of a frame driver setup.

[Quoted] I pass all the necessary values to the form to populate the fields but after [Quoted] I've changed the required values and/or hit the "Update" or "Delete" buttons [Quoted] I get oracle errors (WWV-14607 and WWV-14615,14612 which tell me that the [Quoted] wwv_process_delete procedure has a problem or that my record has been changed by another user - impossible!).

[Quoted] However, if I put a query button on the form and "Query" before I make my [Quoted] changes and update or delete it works. [Thanks to Peter from the Metalink [Quoted] webdb forum for that tip]

I figure that upon the initial display of the form it doesn't know which [Quoted] record it is dealing with - hence the need for doing the query. And simply [Quoted] passing the values to my form, even though this includes the primary key for [Quoted] the table, must not be enough.

[Quoted] I've tried setting the "Alternate ROWID" field in the form definition to the [Quoted] primary key column and sending the primary key value over as the value for [Quoted] "_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. Received on Fri Mar 17 2000 - 05:23:56 CET