It's better than a "use again". You could just SQL into an array.
Cetin
>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