>Is there a way, programmatically or from the desinger to use macro substitution in a view? I have an application that takes a user-defined filter and creates a fairly complex where clause. I create a tmp table and update the master from this. I'd rather use an updatable view.
'WHERE' clause should be created in this manner:
SELECT...;
WHERE table.field = ?varMyVariable...etc.
You can accomplish this in view designer, or write it directly.
Danijel