I have a parameterized view setup with a where clause "gl_period like ?l_period"
This works fine, but I need to change the statement to be "<=" instead of "like" on-the-fly, based upon the report selected. I have been looking in the dbsetprop commands, but don't see a hook to manipulate this part of the view statement. Is there a way to do this? I would simply write an SQL statement, but the fields are all formatted and set for the report.

I'm beginning to think I'm "viewally challenged" <g>