How can I prevent insert more than one record in a table. At DataBase level.

Best regads
Vitor Martins

Vitor

>How can I prevent insert more than one record in a table. At DataBase level.

Do you mean one record at a time, one record ever or....

Roy Lambert [Team Elevate]

<How can I prevent insert more than one record in a table. At DataBase level.>

Victor,

If you want a table to contain only 1 row at most, you will need to create a Before Insert trigger and see if the table is empty. If not, then raise an exception to disallow a new row from from being inserted.

This allows the row to be deleted, or edited, but won't allow the table to have more than 1 row in it.

Barry

Vitor,

<< How can I prevent insert more than one record in a table. At DataBase
level. >>

Here's what it would look like as a trigger:

CREATE TRIGGER "PreventInsert" BEFORE INSERT ON "SingleRow"
BEGIN
  DECLARE TestCursor CURSOR FOR TestStatement;
  PREPARE TestStatement FROM 'TABLE SingleRow';
  OPEN TestCursor;

  IF (ROWCOUNT(TestCursor) >= 1) THEN
     ABORT;
  END IF;
END

If you have any other questions, please let me know.

Tim Young
Elevate Software
www.elevatesoft.com

Works fine, thanks

Best regards
Vitor Martins

"Tim Young [Elevate Software]" wrote:

Vitor,

<< How can I prevent insert more than one record in a table. At DataBase
level. >>

Here's what it would look like as a trigger:

CREATE TRIGGER "PreventInsert" BEFORE INSERT ON "SingleRow"
BEGIN
  DECLARE TestCursor CURSOR FOR TestStatement;
  PREPARE TestStatement FROM 'TABLE SingleRow';
  OPEN TestCursor;

  IF (ROWCOUNT(TestCursor) >= 1) THEN
     ABORT;
  END IF;
END

If you have any other questions, please let me know.

Tim Young
Elevate Software
www.elevatesoft.com