RE: webdb form question

Thanks Diana for you info.

Another simple question (hope you or someone in the list could give me some ideas):

I want to display multiple rows from a table on a form in update mode which allows the user to change the row contents. How could I do this?

This is a very SIMPLE requirement but for me it is not a straght forward thing to do in webdb. Looking at a few options:

1. I could create a form based on the table and have the QUERY and UPDATE button there, but this only displays one row at a time. Here I want multiple rows to be displayed on the form at the same time to allow users to update multiple rows on one screen.
2. The master-detail form allows you to update multiple entries but here there is only one table involved.
3. I have thought a get around way to achieve this, which is to have a report that displays rows in the table, with the key field in each row to be presented as a link. When the user clicks on the link it will call a update form which displays just one row based on the value of the key selected, and the user can change the row content on the update form. So far I got the report done but then when I click on the link it calls the update form and dispalys it with the key field haveing the value passed, and all other fields empty. How can I have a link which passes to a form a key parameter which enables the form to get back a row based on the parameter value?

Hmm, a simple requirement but not a simple task to me. Probably I missed something here.

Please help.
Thanks
Long

-----Original Message-----
From: Diana Duncan [mailto:Diana_at_fileFRENZY.com] Sent: Wednesday, 29 November 2000 2:08 AM To: Multiple recipients of list ORACLE-L Subject: RE: webdb form question

Long,

This is actually a Javascript question, having nothing to do (particularly) with WebDB, hence the probable silence of the list. The best place I've found to look up Javascript stuff is http://msdn.microsoft.com/ie/ (I know, Microsoft, yuck, but they have some good documentation here) and http://developer.netscape.com/docs/manuals/index.html?content=ssjs.html which is the Javascript manuals.

Anyway, to reference a form field (assumning your field name is "theElement") you usually need to do something like:

forms[0].theElement.value

or

forms[0].elements[i].value (where i is the index of the field)

or

myForm.theElement.value (where myForm is the name if the form)

HTH, Diana

-----Original Message-----
Sent: Monday, November 27, 2000 5:16 PM
To: Multiple recipients of list ORACLE-L

Hi,

What I found about webdb is that the manuals are not comprehensive. It is really hard to work without sufficient info. So ... I am seeking for your help.

If I write a javascript within a form (either as a script to do field validation or form validation for a particular field, or as a script included in the "Header" or "Footer" of the Text Option), how can I refer to a particular field within the form? I have searched but have not been able to find this info in the webdb manuals.

(I know that in a field/form validation script for a particular field you
can refer to the field as 'theElement' and the field value as 'theElement.valule', but that's all I know. But how do you refer to other fields in the form?)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Diana Duncan
  INET: Diana_at_fileFRENZY.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may