In article <5d8aafc5aead289ea84b5eb12469e224@...>, Pavel Hrube¹
wrote:

> Select * into NewTable From OldView
>
> in Firebird doesn’t work.

What errors do you get, just "doesn’t work" gives people little to work on.

I suspect you need

insert into newtables select * from oldview

which will only work if the fields in both are valid and in the same order

--
Nick
-----We Solve your Computer Problems---
Founder & Listowner of the Prolifics User Group
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly