Skip to Content
0
Former Member
Aug 05, 2009 at 04:50 PM

Create with employee details

22 Views

Hello everyone,

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:

WHEN 'CREATE'.

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,

Regards,

Lucky