Re: What's wrong with this SQL statement?

From: Troy Perchotte <max_at_headroom.com>
Date: Mon, 22 Jun 1998 15:06:35 -0700
Message-ID: <358ED56A.76BC0790@headroom.com>

Problem Solved.

Thanks a lot for all the suggestions made.

Since I was still receiving the compile error after all the suggestions were implemented, I decided to start over from a new table. When attempting to recreate the table (inv_field_items), oracle returned an error on one column that had been named a reserved word (DATE).

After changing the column name DATE to DATE1, the trigger was able to be created successfully.

Strange that oracle barked on the trigger creation, but not on any of the constraints that had been created.

The table was originally created by an export query from ms-access.

Troy Perchotte Received on Mon Jun 22 1998 - 17:06:35 CDT