Subject Insert SQL ???
Author ggroper
I am new to Firebird and need a little clue as to the proper syntax
for a stored procedure.

I'm inserting data into and existing empty table from a view.

The view and the table structures are the same, field names, field
characteristic (as seen by Developers Workbench), and field order.

insert into existingtable select * from view

First question, does the insert ignore field names and just uses field
order and expect the field types to OK?

Second, do I need some begin trans ... commit trans statements around
the insert statements???.

Is there any way to insert new records(primary key) and ignore
duplicate records or do I need to revise a view to illiminate those