WebDB Problems & Workarounds

From: Brooks Vaughn <brooks_at_tidalwave.net>
Date: Thu, 24 Feb 2000 14:38:26 -0500
Message-ID: <38B588B2.8A311F35_at_tidalwave.net>



Some of the tihings I have been faced with are:
    [Quoted]
  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 Thu Feb 24 2000 - 20:38:26 CET

Original text of this message