>Hi, Michelle. I know what you mean about the parameterized views! But it gets to be second nature after a while. I've been making the transistion to PVs sloooowly. :-) I made major progress yesterday though: I had a troublesome grid that I solved with a PV because it was the _easiest_ solution I could think of. I'm pretty pleased.
>
>As for programmatic views. The way I started _that_ transistion was to start a view in the designer (I still start there!), and then I copy the sql statement to a PRG I keep of my view definitions and add the create view code--which I learned by using Steve Arnott's GENDBCX program (www.stevearnott.com) I even do this for really simple views so that if my DBC gets damaged I can recreate the views really easily.
>
>FWIW, here's one of my view procedures

(Snipped View)

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!

So, once I have the view in the .prg, how do I get it in the database? Just run it? Do I need to run it every time, or only if the syntax changes?

Thanks,

-Michelle