Have you tried to use the BeforeCursorFill() event to verify the cSelectCmd includes the where clause?
>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