I have a small question. Quiet confusing though i have created a button "create" to insert data into my employee table.
this is how it goes and it works completely fine:
INSERT INTO ZLEMPLOYEE VALUES ZLEMPLOYEE.
*where zlemployee is my employee table.
Question: How can i make sure that the entered data already exists in my table and how can i tell the user that he cannot create the same employee record with different details?
Say a user has entered the data into the fields and suppose i already have that employee record created in the table. how can i tell the user that the following employee has already been created? say my empid is the primary key.
Thanks for writing back,