>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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement