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!

Register Log in
  • Congratulations Mike Lewis 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

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
 
Sort by date Sort by votes
Why not simply create a UNIQUE constraint ?

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

Similar threads

aft5425
  • Locked
  • Question
help using dbload command utility; substitute values when i found spaces
Replies
0
Views
87
aft5425
aft5425
zagro17
  • Locked
  • Question
4gl compiling error, please help
Replies
2
Views
98
zagro17
zagro17
ejaggers
  • Locked
  • Question
Need help with case stmt 1
Replies
2
Views
90
ejaggers
ejaggers
ejaggers
  • Locked
  • Question
Help w/ date sql 1
Replies
2
Views
80
ejaggers
ejaggers
ejaggers
  • Locked
  • Question
Help Find Max record using SQL
Replies
10
Views
140
ejaggers
ejaggers

Part and Inventory Search

Sponsor

Back
Top