[firebird-support] Re: Unable to INSERT INTO TABLE

2013-05-16 Thread Allstars
Yes, I got it to work. Thank you! --- In firebird-support@yahoogroups.com, Nagy Szilveszter nagy_szilveszter@... wrote: Did you commit after creating the table? From: Allstars data@... To: firebird-support@yahoogroups.com Sent

[firebird-support] Need a row to show but it's not coming up in the result set..

2013-05-16 Thread Allstars
Ok so i have this query, I want the customset.info to show a blank value for a part number. but when i set the customfieldid to 51 the record does not show up. I want the record to show with a blank even if it doesn't exist in the customset table. I tried using coalesce and a case

[firebird-support] Re: Need a row to show but it's not coming up in the result set..

2013-05-16 Thread Allstars
Sorry guys, But i was able to resolve the issue. I had to take the line customfieldid = 51 and join in with customset.recordid = part.id and customfieldid = 51. Thanks --- In firebird-support@yahoogroups.com, Allstars data@... wrote: Ok so i have this query, I want the customset.info

[firebird-support] Unable to INSERT INTO TABLE

2013-05-15 Thread Allstars
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

[firebird-support] Re: Unable to INSERT INTO TABLE

2013-05-15 Thread Allstars
No I didn't think I have to since there is no transaction statements. --- In firebird-support@yahoogroups.com, Nagy Szilveszter nagy_szilveszter@... wrote: Did you commit after creating the table? From: Allstars data@... To: firebird

[firebird-support] Re: Unable to INSERT INTO TABLE

2013-05-15 Thread Allstars
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

[firebird-support] Re: Unable to INSERT INTO TABLE

2013-05-15 Thread Allstars
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