Thanks Aleksey,

Sometimes it takes a second pair of eyes to spot the obvious. After I changed my base class and recompiled it works. Now I can stop pulling my hair out. By the way, once we get everything converted over to SQL server using cursor adapters and installed, you may want to use our software as a case study. Let me know if that is of interest.

Thanks Again,

Neil.


>>CommandText: SELECT prd_prd_cd,prd_prd_nm,prd_mem_pr FROM ic_prd ORDER BY prd_prd_nm WHERE prd_mem_pr = 1
>>
>>
>>There is no second WHERE clause in the SQL.
>>
>
>Yes, but WHERE clause is supposed to be before ORDER BY.
>
>Thanks,
>Aleksey.