First, you need to change the procedure to include a RETURNS clause to return the data you are SELECTing. As it stands, it would not return any data.
Second, you need to make sure there's an "EMPLOYEE" table in the database you are using. THe error indicates there isn't one.
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.
I have altered the stored procedure to include a RETURNS statement. I have also made sure that there was a table named "EMPLOYEE". I am still getting this error "No such Table or Object". Am I missing something in my stored proc syntax?