keep an insert from working, if field matches

ecourt · #1 (**permalink**) 01-13-11, 09:55

so I have a sybase 12.5 db, with a table of phone numbers.
If the phone number is blank, or 000 000 0000, I need the insert to fail.

I can't 'fix' it from the front-end, as I have no control over the utility that does the insert.

I know there's a way to do this, but I'm having trouble figuring it out.

Thanks

agrawal.meet · #2 (**permalink**) 01-13-11, 10:00

Use insert trigger.

ecourt · #3 (**permalink**) 01-13-11, 11:36

thoughts on why this one don't work ?

Code:

create trigger test_phone
    on phone_table
    for insert,update
    as
    if update(phone) in ("0000000000","000","")
    begin
        rollback transaction
    end

Keeps giving a error on IN

pdreyer · #4 (**permalink**) 01-14-11, 09:22

You probably want something like this

Code:

if update(phone)
  if exists (select 1 from inserted where phone in ("0000000000","000",""))
    rollback transaction

Internet Services

Web Development

Digital Marketing

Consumer Tech