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/
 



Reply via email to