On Tue, May 21, 2013 at 3:37 PM, Ricardo Aráoz <[email protected]> wrote:
> El 21/05/13 11:32, Frank Cazabon escribió: > > > I've also been using it in my previous job with no problems at all. > Well, that's not entirely true. There have been some queries that did > receive a truncated answer, so you should check the quantity of tuples > received to be sure. In those cases I simply changed the query to some > other form that brought the same set or divided it into a couple of queries > and combined them within VFP. Never found out what was going on, but OTOH I > was only allowed to use VFP6 and the people maintaining the database were > not the best. So it might have something to do with database settings or > maybe is something particular to VFP6 and corrected in newer releases. > > --------------- > Sounds like a timeout issue as a WAG from VFP. I have run queries that took DAYS to populate data across tens of thousands of cancer patients over decades in time. All Data Warehouse kind of stuff from every system that St. Jude's Children's Research Hospital. -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJidMYL49UAUYSmJk3c5Q2q3wi_cVXcCLE=9fxgcybmr-8m...@mail.gmail.com ** 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.

