> The create table works until I add the ON CASCADING DELETE.
> create table fsnep_pollComments (
> pc_id NUMBER Primary Key,
> pc_date_added date,
> pc_poll_id NUMBER REFERENCES fsnep_polls(p_id),
> pc_comment VARCHAR2(3000),
> pc_ip VARCHAR2(20)
> ON DELETE CASCADE
> )
ON DELETE CASCADE should be specified on the same line as the
constraint it applies to. (How else could you have one FK with
CASCADE and another one with NO ACTION?)
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
