Re: MAX NUMBER

On 24 Aug 2006 01:32:46 -0700, "Reiro" <ReiroGP_at_gmail.com> wrote:

>
>i having trouble with the sequence.... in my access query i have the
>foll:
>
>
>insert into asset(asset_id,parent_asset_id,content_title,asset_level)
>values (asset_seq,parfld1,parfld2,parfld3)
>
>if i try my parameter fields it works fine.... please let me know how
>i can call the sequence in access through the query above..
>
>thx alot
>SORRY (im a beginner of all beginners)

You can do that probably by using a passthrough query. A workaround I used on interactive forms was to create a PL/SQL function to run <sequence>.nextval, call that in a pass through query, and assign the retrieved value to the ID column on my form.

--
Sybrand Bakker, Senior Oracle DBA