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
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
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
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
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
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
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