Table in incomplete state

comp.databases.gupta (1995-2015)
AndyG

Table in incomplete state

Post by AndyG » 19 Jan 2004, 20:18

 Posted by:  agon...@navigatorco.com (AndyG) 

Hi Guys,

I am writing because I have a weird bug that I have not been able to
figure out.

Description of the problem -- I created a table in SQL Base, committed
the transaction, tried to insert a record in the table, and SQL Base
complaints with the following error message: "Error: Table
TF_DISCOUNT_PERCEN in incomplete state." I have never seen this error
message before. Perhaps, SQL Base requires an extra step that I am not
aware of or probably, there is a bug hidden some where in the script
that I am not catching up.

Anyhow, the attached script is the exact SQL statements that I am
executing. If you have any idea of what is causing the problem, please
let me know. I would really appreciate it.

Best regards,

Andy Gonzalez

Scrip:
DROP TABLE TF_DISCOUNT_PERCEN;

COMMIT;

CREATE TABLE TF_DISCOUNT_PERCEN
(DISCOUNT_CODE varchar (15) NOT NULL,
PART_ID varchar (30) NOT NULL,
SELLING_UM varchar (15) NOT NULL,
QTY_BREAK_1 decimal(14, 4),
QTY_BREAK_2 decimal(14, 4),
QTY_BREAK_3 decimal(14, 4),
QTY_BREAK_4 decimal(14, 4),
QTY_BREAK_5 decimal(14, 4),
QTY_BREAK_6 decimal(14, 4),
QTY_BREAK_7 decimal(14, 4),
QTY_BREAK_8 decimal(14, 4),
PRIMARY KEY (DISCOUNT_CODE, PART_ID, SELLING_UM)
) ;

COMMIT;

INSERT INTO TF_DISCOUNT_PERCEN (DISCOUNT_CODE, PART_ID, SELLING_UM )
VALUES ('TNC', '200-12315', 'FT');

Bob Badour

Table in incomplete state

Post by Bob Badour » 20 Jan 2004, 01:22

 Posted by:  Bob Badour <bba...@golden.net> 

Create an index for the primary key. It's stupid to require an index for a
single-page table, but that doesn't stop most dbms vendors from requiring
one.

AndyG

Table in incomplete state

Post by AndyG » 23 Jan 2004, 18:15

 Posted by:  agon...@navigatorco.com (AndyG) 

Thank you very much. Creating a index solved my problem.
I appreciate your help.

-Andy

Return to “comp.databases.gupta”

Who is online

Users browsing this forum: [Ccbot] and 0 guests