| need to brevent dublications [message #82869] |
Thu, 10 July 2003 10:00  |
osos
Messages: 1
Registered: July 2003
|
Junior Member |
|
|
hi guys
i'm still newbuy in oracle
i've 2 fields in my table one for current record and the other for added record, i need when i add in the add_record field added automatically in the current_record field.
2- i need to prevent dublication, i.e when the user enter a name and this name exist it show a message to user telling him that this name exist and if possible shows a details of this name.
thnx alot
best regards
|
|
|
|
| Re: need to brevent dublications [message #82908 is a reply to message #82869] |
Wed, 16 July 2003 02:27  |
Sun
Messages: 92
Registered: August 2002
|
Member |
|
|
to avoid dublication,
in the key next item - give post.
Then use a select statement to find out whether the entered already exist.
By this way u can avoid duplication.
The other way without posting, in loop u have to check with the current value with other values..whether the value exist or not..
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
