Subject Re: [firebird-support] How create Table from View?
Author Nick Upson
In article <5d8aafc5aead289ea84b5eb12469e224@...>, Pavel Hrube¹
> 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

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