hello Arsen You have to set the focus on the control hooked to the ID field whenever user wants to create a new record, as for checking duplicate key values, in paradox, if you move yourself from the record the changes are post, thus creating a key violation exception if the value already exists. To do this you have to have a clone value, where right before moving or exiting the ID field control, you will check the existing value in the clone table, if value does not exists you will continue your work, if it exists, you will keep focus on the control and force the user to cancel changes or enter a new value.
In all cases, I suggest not to use paradox. There are lot of good alternatives up there. Vahan Yoghoudjian Information System Administrator Schneider Electric East Med Arsen Khachatryan <[EMAIL PROTECTED]> Sent by: delphi-en@yahoogroups.com 08/07/2006 03:48 PM Please respond to delphi-en To: delphi-en@yahoogroups.com cc: Subject: [delphi-en] ID Control Hi friends, I have Db in paradox with BDE and how can I put the control on the ID field, and when the user types the same ID number twice, can get the error message?? Thanks a lot friends --------------------------------- How low will we go? Check out Yahoo! Messenger’s low PC-to-Phone call rates. [Non-text portions of this message have been removed] ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. This is a service contracted by Schneider Electric to avoid Spam. ______________________________________________________________________ [Non-text portions of this message have been removed] ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/