I've gotten into the habit of using an SQL check...is that inherently any better or worse than your first suggestion?

>>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,
>Probably sample depends on table's primary key. If UserId is primary field than tableupdate(.f.) would return .f.
>If you don't do that with a primary key you could use other workarounds :
>-If row buffered use the table again and seek userid in "used again" alias (use again doesn't see buffered ones).
>-Do the same with an SQL check (it doesn't see buffered also).
>-Also you could just use seek (lookup()). Seek would catch first entered and if its recno() # yours than its duplicate.
>Cetin