General information
Category:
Forms & Form designer
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only