Hi All --

I have attempted to use a SQL statement such as:

SELECT * FROM tab_sample_log_product WHERE slp_project_id = '931' AND slp_product_id = 'A0140AA'

A call to lo_slp.CursorFill() with this SQL command in the SelectCmd property fails to filter the result set based on the WHERE clause. I have taken to doing a CursorDetach and then issuing the command through SQLEXEC() and then doing a CursorAttach to put it back.

Any clues on what I am doing wrong? I think there ought to be a way to have WHERE clause filtering on the CursorAdapter and I am just not seeing it. I have looked through the help documentation extensively for clues, but have found none.

Thanks,
Larry Rix
Applications Developer
AQS
Atlanta, GA