Re: WebDB Problems & Workarounds

About the LOV's on unstructured forms: There's a bug is in webdb.wwv_user_utilities :

on line 2126 :

l_columns(l_num) := substr(p_layout_text, l_cell_start+1, l_cell_end-l_cell_start-1);

should be:
l_columns(l_num) := substr(p_layout_text, l_cell_start+2, l_cell_end-l_cell_start-2);

and everything works fine!

Brooks Vaughn <brooks_at_tidalwave.net> schreef in berichtnieuws 38B588B2.8A311F35_at_tidalwave.net...
> Some of the tihings I have been faced with are:
>
> 1. When entering code (for Forms edit) into the On Successful Submitt,
> gives a Java Script error when you try to edit that form again. I have
> to revert back to a archive version and reenter the code to make changes
> to the form.
>
> 2. When using Unstructured Forms, undesired resluts can occur with using
> LOV's and ComboBoxes. Must use Structured forms instead.
>
> I'm still having problems with the basics like:
>
> 1. How to call components from other components
> 2. How to return to a previous form or report after calling another
> form,
> 3. How and where to HyperLink the day of the month on a canendar to a
> insert calendar event form
> 4. etc...
>
> -Brooks
>
>
> >>> Jacquie Armstrong <jacquie_at_softtracks.com> 02/24 12:40 PM >>>
>
> That would be great... I know that in the past couple of days I have
> fought with WebDB only to discover things like:
>
> 1) when writing a report based on an SQL Query you CAN'T put a
> semi-colon at the end of the query
>
> 2) If you want to tell who is logged on to the system (in order to
> restrict the data they see), you must change the DAD settings so that
> WebDB components use the secure DAD. (Otherwise the user of the
> component is the PUBLIC user)
>
> 3) There is no way to add joins to a query if you have created it using
> the Wizard. (Our standard is now to create all reports from our own SQL
> queries)
>
> It would be very helpful if we could bounce ideas and problems off each
> other.
>
> Thanks, Jacquie.
>
>
Received on Mon Feb 28 2000 - 14:28:28 CST