Xref: alice comp.databases.oracle.misc:54236 comp.databases.oracle.tools:40622 Path: alice!news-feed.fnsi.net!news-FFM2.ecrc.net!newsfeeds.belnet.be!news.belnet.be!afrodite.telenet-ops.be!not-for-mail From: "Leo Van Nieuwenhuyse" Newsgroups: comp.databases.oracle.tools,comp.databases.oracle.misc References: <38B588B2.8A311F35@tidalwave.net> Subject: Re: WebDB Problems & Workarounds Lines: 71 X-Newsreader: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 Message-ID: Date: Fri, 03 Mar 2000 21:12:44 GMT X-Complaints-To: abuse@pandora.be X-Trace: afrodite.telenet-ops.be 952117964 213.224.4.183 (Fri, 03 Mar 2000 22:12:44 MET) NNTP-Posting-Date: Fri, 03 Mar 2000 22:12:44 MET Organization: Pandora-- Met vlotte tred op Internet There's still a problem with the lov's when you put more than one radio group above the popup lov. I'm working on a solution. Leo Van Nieuwenhuyse schreef in berichtnieuws MTAu4.48592$2v4.123836@afrodite.telenet-ops.be... > 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 schreef in berichtnieuws > 38B588B2.8A311F35@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 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. > > > > > >