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');

"AndyG" <agonzalez (AT) navigatorco (DOT) com> wrote

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.

"Bob Badour" <bbadour (AT) golden (DOT) net> wrote

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

-Andy