Re: WebDB Howto use Sequences when inserting new records

Hello,

[Quoted] To get current logged-in Oracle userid into a Form field, specify the field's

Default Value as "#USER". This gets you the userid in uppercase. Using "#LOWER(USER)" gets the userid in lowercase. In this context, the "#" character serves as an escape character allowing SQL functions to be placed into WebDB Forms.

Regards,
Mark
mao_at_dde.dk

Win Ker wrote:

> EASIEST way is to design your schema using Oracle Designer, generate your
> tables & related sequences, then generate the table API which will build
> the related triggers, etc. Upon which, in WebDB, create your form, and on
> the PK column, set it to Not Mandatory and it will automagically be
> populated by the sequence...worked great for me.
>
> A few things that DON'T work for me is that I cannot do a "select user
> from dual" to populate a table with the form username...always returns
> <dad>_public as the value...anyone have any idea of how to retrieve the
> username for a particular session of WebDB???
>
> "Paul O. Schenker" wrote:
>
> > Hi,
> >
> > what must I do when configuring Input Forms to make use of an existing
> > sequence for the primary key?
> >
> > Thanks for a hint.
> >
> > Paul
Received on Tue Sep 28 1999 - 09:58:03 CEST