>You can use the DBGETPROP() function to get the SQL clause, adjust the WHERE portion of it, then write it back to the DBC with DBSETPROP():
>
>cSQL = DBGETPROP("rv_ViewNameHere", "View", "SQL")
>
>* Change the WHERE portion of cSQL here
>
>DBSETPROP("rv_ViewNameHere", "View", "SQL", cSQL)
>
>It may be difficult to parse the WHERE portion. I usually have the ORDER BY clase immediately follow the WHERE clause, but I can't remember if that is a SQL requirement.
That is a good idea. Thank you.
Alex
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only