OK, we finally figured out the problem. First of all, thanks to everyone that responded with suggestions (helpful or not).
The original code had a couple large SQL select statements working off of a single table. We needed to make the selects work off of three tables. These tables were linked together using SET RELATION statements, but we forgot to link them together in the WHERE clause on the SELECT statement. Once we added the correct WHERE clauses, the skipping went away. Now this still does not explain why the program was skipping code. But at least it is fixed and I can get the update out. Have a good one. Karl Brown Field Services Section USDA/NASS [EMAIL PROTECTED] Never try to run a bluff when your poke's empty. - "Don't Squat With Yer Spurs On! A Cowboy's Guide To Life" by Texas Bix Bender [EMAIL PROTECTED] wrote on 10/10/2006 01:10:06 PM: > I have a program that has been running for years as part of an > application. I have recently made some changes to it and now I am seeing > a weird behavior. > > It will run fine through the first 300 plus line of code. Then it will > suddenly skip about a hundred lines of code and go about its merry way. > Like the lines did not even exist. I have restored the original version > of the program, made the changes again and hit the same problem. If I > comment out the code that it is jumping to, it will just skip down further > in the program. > > This is driving me batty. Has anyone seen this behavior before. Anybody > have any ideas. > > BTW, this is in Fox 6. > > Thanks for the help. > > Karl Brown > Field Services Section > USDA/NASS > [EMAIL PROTECTED] > > If you get to thinkin' you're a person of some influence, try orderin' > somebody else's dog around. - "Don't Squat With Yer Spurs On! A Cowboy's > Guide To Life" by Texas Bix Bender > > --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ 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.
