I am baffled by this sql select problem. When use select (count) first time as follows:

Select count(employee.e_lname) from employee where employee.e_lname == .txtlname.value;
into array a__gen1


everything is ok and I get my results, but when use select statement as follows:

Select employee.e_id. employee.e_lname, employee.e_ssn from employee;
where employee.e_lname == .txtlname.value into array a__gen1

I get an error saying "object EMPLOYEE is not found". The complete code is below. I don't understand why it can find my table with first select, but not the second time. around.


Case !empty(.txtlname.value) and empty(.txtssn.value)
Select count(employee.e_lname) from employee where employee.e_lname == .txtlname.value;
into array a__gen1

If type('a__gen1') # 'U' and type('a__gen1') # 'L'
.hldcnt = a__gen1(1,1)
Release a__gen1
Do case && case4-1

Case .hldcnt = 1 && case4-1a
Select employee.e_id. employee.e_lname, employee.e_ssn from employee;
where employee.e_lname == .txtlname.value into array a__gen1


Thanks
Nick Patel