Re: WebDB - Using sequences
Date: Tue, 07 Sep 1999 07:05:33 GMT
Message-ID: <7r2dfp$ve7$1_at_nnrp1.deja.com>
[Quoted] Hi Edward,
you're indeed forgetting something. It took me a some time to figure it out but the solution is that you have to prefix the sequence with the schema name it is stored in as well as grant the right to select the sequence:
#the_schema.my_seq.nextval
Desiree
In article <7qon7p$6p0$1_at_zonnetje.nl.uu.net>,
"Edward Beemer" <Ted_BMW_at_Hotmail.com> wrote:
> Hi guys,
>
> I'm trying to get the same thing done, but with partial success.
> I inserted #my_seq.nextval in the default value field.
> This works when I'm logged on as WebDB Developer, but when a User logs
in,
> the literal text 'my_seq.nextval' is presented in the edit box.
>
> I already granted the right to select my_seq to the role the User has.
Did I
> forget something?
>
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Tue Sep 07 1999 - 09:05:33 CEST