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

 

[grega]

I would probably do this by defining an insert trigger on the table which counted the records in the table. If there were 10, then don't allow the insert.

Greg.

 

[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

 

[grega]

You would normally have some sort of 'if' condition in the trigger. If you don't want to do the insertion you would do

rollback tran
return

You may also (optionally) want to do a raiserror to generate a user error for the log file before the rollback.

Greg.

 

[swot]

Hi Grega,

but i get the follwoing error
COMMIT/ROLLBACK NOT ALLOWED WITHIN ATOMIC TRANSACTIONS

how do i fix this

Bye

 

[manjunale]

Try using 'rollback trigger with raise error statement'