Dear all,
I have a table. When the user adds a new record, I want to check if this new record (for example, same UserID) has already exist in the table or not. How can I do that?
I found in an example that it has a "Save" button and the CLICK event is:
result = TABLEUPDATE(.F.) if result = .F. =MESSAGEBOX("Fail to save!"+CHR(13)+"User ID already exists";
else
....
...
It works in this example. I have tried to find any coding for checking about the existing data in this example but cannot find any idea.
Anyone can help?
Thanks
Power
Power Wong
Every problem will have a solution, the only problem is that can you find it out.