Fetch emp salary against its Employee ID

ishrat khan · #1 (**permalink**) 12-04-03, 02:44

Hi...

I am doing an assignment..... and need some help.

The application i am working is connected to sql server 2000 as database. And vb 6 as front end.
I have a form with multiple fields. What i want is ... that when i enter an employees Id in the field... On its lost focus event, The application populates the salary field of the form against that ID.

Hope u understand. So thanks for any help.

blindman · #2 (**permalink**) 12-04-03, 13:23

You could write a Stored Procedure on your database that returns the salary for a given EmployeeID. For something as simple as this you could also send a direct SQL query and process the results, but I hope you have some security or verification scheme for this and a stored procedure will give you more functionality.

blindman

rnealejr · #3 (**permalink**) 12-04-03, 23:59

You can create a 2nd recordset object that either runs a stored procedure or a select query. Then, use the result from this recordset to populate the field.