>>>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?
Dont forget that you will need to use the CURSORSETPROP() functions to configure your hard coded views. I set them up in my form.load method.