Ok sorry, now I am getting a different error. When I do the insert, I'm getting a
Error: arithmetic exception, numeric overflow, or string truncation string right truncation What does that mean? Thanks! --- In firebird-support@yahoogroups.com, "Allstars" <data@...> wrote: > > Hey it worked!! Thanks for the help! Really appreciate it! > > --- In firebird-support@yahoogroups.com, "Allstars" <data@> wrote: > > > > Hello there, > > > > I am fairly new to FIREBIRD SQL. I am using WINSQL as my database > > management system. > > > > I am trying to insert into a table I created. > > > > create table allBillOfMaterials( > > > > id int not null primary key > > , totalTitles int not null > > , bomNumber varchar(17) not null > > , bomDescription varchar(255) > > ) > > > > It creates the table and says (0) rows affected. Fine. I look at the > > database explorer and the table is there. > > > > When i try to insert into the table, it says that the table is unknown. The > > id(pk) should be created automatically I'm thinking. Someone save me!! > > > > insert into allBillOfMaterials('', totalTitles, bomNumber, bomDescription) > > select distinct > > count(bom.num) as "Total" > > ,bom.num as "BOM Number" > > ,bom.description as "BOM Description" > > from bom > > inner join bomitem on bomitem.bomid = bom.id > > inner join part on part.id = bomitem.partid > > inner join bomitemtype on bomitemtype.id = bomitem.typeid > > inner join customset on customset.recordid = part.id > > where bomitem.typeid = 20 > > and customset.info = 'Book' > > group by bom.num, bom.description > > order by bom.description > > >