Re: WebDB opinions ?

I kludged in the current date by creating a LOV. Its select statement gets SYSDATE(). Then the LOV goes on the form as a combo box that doesn't show a null option. It's ugly, but it works. You could probably do the same thing with the user.

"H. John C. Hopkins" wrote:

> Hi.
>
> You mean other than using before-insert triggers or default column values?
>
> I'm pretty certain you can set default values form fields as well, although
> I haven't tried using functions for default values (they may have to be
> literals).
>
> -John
>
> H. John C. Hopkins
> Gainesville, FL
>
> "Adam Lipscombe" <alipscombe_at_ingenta.com> wrote in message
> news:Fr5Lnn.Gxy_at_bath.ac.uk...
> > Folks,
> >
> >
> > I am interested in hearing opinions on WebDB....
> >
> > I have been using v2.1 to produce some simple reports and forms to provide
> > administrator functionality on an existing database. Simple things like
> > adding, modifying and deleting users etc.
> >
> > WebDB does not seem to have anywhere near enough functionality.....
> > For example it seems impossible when doing a form "insert" to populate
> > columns in a table with programmatically set (i.e. no user interaction)
> > values such as the current time and user name.
> >
> > I would be grateful if anyone who has successfully used this tool to
> produce
> > forms that create rows with some user enetered data and some
> auto-generated
> > data could share their experiences...
> > Any good tutorials or learning resources?
> >
> >
> > Thanks - Adam
> >
> > --------------------------------------------------------------------------
> -
> > Adam Lipscombe Tel: (+44) 1225 323846
> > Ingenta Ltd email:alipscombe_at_ingenta.com
> > BUCS Building
> > University of Bath
> > Bath BA2 7AY
> > U.K.
> > --------------------------------------------------------------------------
> -
> >
> >
Received on Fri Mar 10 2000 - 17:29:10 CST