Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
C5 at the Home Straits of my run
Message
From
16/03/2005 05:41:58
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
C5 at the Home Straits of my run
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00996216
Message ID:
00996216
Views:
56
Hi Fox Maniacs

Can anyone suggest why the following code should have C5'd at the end of the 2nd SQL select below (near bottom of Scan)? I don't think it failed 1st time and it probably went through many loops before it did. This was at the end of some labour-intensive 30-odd minutes of reading through source tables and compiling a routes-stops-times database schema. This was at the last leg, doing the last bit of exception reporting, but was doing nothing more arduous than it had for the rest of the time.

'ppreciate it

Terry
Select * From RZStop where SeqNo = 1 into CURSOR csrSubjRZStop 
	
* Got thru each one and see if ANY RZStop rec, any Seq. # of this Roue has not a Time 
* value attached.  This shows that such a stop is not actually used somewhere in
* one of the route's Journeys. 
* __________________
Select csrSubjRZStop 
lnNoRecs		= RECCOUNT()
lnInterval	= INT( lnNoRecs / 100)
If lnInterval < 1
    lnInterval	= 1
EndIf 
lnDone			= 0
Thisform.barProgressBar.Reset( .nMaxJ)
Thisform.barProgressBar.Visible = .T.

SCAN
  lcRteNo	= RTE_NO
  lcDirectn	= DIRECTN
  lcStopNo	= STOP
  lcCounty	= COUNTY

  Select TIME from	RZStop ;
  	where RZStop.RTE_NO   = lcRteNo ;
 	  and RZStop.RTE_LET  = "A" ;
 	  and RZStop.DIRECTN  = lcDirectn ;
	  and RZStop.Stop	    = lcStopNo ;
	  and RZStop.County   = lcCounty ;
 	  and not EMPTY( RZStop.TIME) ;
	  into Cursor csrTemp                 && C5 HERE !!!!!!!
  ...
EndScan
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Next
Reply
Map
View

Click here to load this message in the networking platform