>>Back again. I forgot to ask for your thoughts on creating local views. Unfortunately the books I have don't have much info on creating them even though they appear to be a valuable tool in VFP.
>>
>>What's your opinion about the best way of creating local views... hard coded SQL statements (and where do you create/store them?) or using VFP's View Designer?
>>
>>Also, any ideas where I can find more info on creating "complex" views here on the 'net?
>>
>>MTIA,
>>Mandy
>
>IMHO Mandy,
>
>For simple views use the View Designer. For more complex views, use CREATE VIEW... where you attach your (pretested, I hope) SQL code.
>
>I use ad hoc SQL statements for things like populating combo boxes from AllCodes, and views where the same complex SQL-Select is used repeatedly (usually parameterized). It's a judgment call, and others may feel differently.
>
>For example, Visual MaxFrame suggests views for ALL data entry, using tables ONLY for lookups.
>
>Barbara
visual maxframe isn't drew speedie's framework, is it?