>Wow! There's a lot more to making a view than I thought. I thought it was
>just a modified SELECT SQL. I'm thinking of using a PV where I have a SELECT
>into CURSOR right now. I can probably do most of it in the designer, but I'll
>have to add the WHERE clause programatically. That's gonna be a doozy!

My strategy is to do what I can in the designer, then run GenDBCx to get all those DBSetProps, then fix the syntax of the generated code to get exactly the SELECT I want.

FWIW....