I'm using an older version of IB but it only works for if you remove the
quotes from "VUNIQNO" & "UNIQ_NO". I can't think of why you would need them

>From: "phoove27" <phoove27@...>
>Reply-To: ib-support@yahoogroups.com
>To: ib-support@yahoogroups.com
>Subject: [ib-support] Re: view generator
>Date: Thu, 21 Mar 2002 14:27:19 -0000
>

> > >CREATE VIEW "VUNIQNO"
> > >(
> > > "UNIQ_NO"
> > >) AS
> > > SELECT GEN_ID(UNIQNO, 1) FROM RDB$DATABASE;
> > >
> > >
> > >In IBConsole, I connect to my database and click on VIEWS. Then
> > >after double-clicking the VUNIQNO view I attempt to click on the
> > >DATA tab. The following message appears:
> > >
> > >Dynamic SQL Error
> > >SQL error code = -104
> > >Token unknown � line 1, char 24
> > >)

_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx