restrict number of records

[Guest_imported]

Hi guys,

I have a program that inputs records into sybase.
I have a table here called orders.

now ,i require that there may be a maximum number of 10 entries in this table,not more.
Attempts to enter more entries are discarded.

how should i attempt this

Bye

 

[vechalapu]

Write a trigger on insert using a cursor and get the latest number of records in the table before inserting every record. If record count > 10, do not insert any other records in the resultset.

 

[Guest_imported]

Thanks a lot.
This works fine

 

[swot]

Hi,

I also had faced this problem before...
but can anyone tell me how can i abort the insertion into the table through the trigger..means what code i have to write

Thanks

 

[vechalapu]

use rollback transaction.