Subject Re: [firebird-support] Re: Problem with SKIP keyword
Author Helen Borrie
At 07:53 AM 15/10/2003 +0000, you wrote:
> > Just a shot on the dark, but try it with "SKIP".
>
>I tried....
>
> > What tool are you using ?
>
>I tried to execute queries using IBExpert (2.5.0.61), InteractiveSQL
>(1.0.1.340), InterBase Interactive SQL (V5.5) - the error always is
>the same.

I don't know whether you are in a position to upgrade to Fb 1.5, but SKIP
isn't a keyword in 1.5. Even if you don't want to upgrade, you could
simply open the ib6 database using the fb 1.5 client and server (that won't
cause the database to "upgrade" itself), run the sql to copy the data into
the new column, drop the column and shut down.

heLen