> >> Quick question: are you using Views to access the data? > > Yes and no. Yes, our application uses views. No, the views are not in > > use when this problem first occurs(on load). There were also no views > > in the test app I created for TS.
> I'm starting to take a different, hybrid kind of approach where I use > views for retrieving but then just do inserts/updates/deletes directly > into the VFP or MYSQL tables. Not sure if this simplifies or > complicates, but so far, so good in my experiences. I'm wondering too > if it aids at all in network traffic management? Probably not with > VFP. But I recall VB6 learning about ADO recordsets and the various > types of cursors you could create (e.g., "forward only" being the least > network intensive). Much of the views still in use in the application were created many years ago when Ed was on board as a consultant(or soon after by another developer). Personally, I'm not a fan of VFP-designer-built views, as they're way too inflexible. I have some code-built views in temporary view DBCs that I use at certain parts of the app where I want easy buffered add/update/insert functionality, but most other places I use basic SQL. -- Derek _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
