Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

need help

Status
Not open for further replies.

magni

Programmer
Oct 11, 2007
12
CA
Hi
I want a simple sql (trigger) for duplicate checking.
My table name is test1, before inserting new record, check - if exist, then error, and not insert.
Thank you,
Magni
 
Why not simply create a UNIQUE constraint ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Thank you, but in my case I am only 3 weeks in informix 4gl no clue. how to create.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top