Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
String Conversion
Message
 
 
To
06/08/2007 22:49:46
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01245922
Message ID:
01246378
Views:
32
Incorrct, DO SOMETHING 2 will be executed as long as there's at least one record in the table. The SCAN w/o clauses always starts from the top of the table. Only SCAN WHILE and SCAN REST/NEXT start from the current record.

>I always use the GO TOP. If the table is on a second scan and you are not using a FOR clause, it will not scan the table.
>
>
>
>SCAN
>  <DO SOMETHING 1>
>ENDSCAN
>
><MORE CODE>
>
>SELECT csrTable
>SCAN
>  <DO SOMETHING 2>
>ENDSCAN
>
>
>
>Without a GO TOP, the DO SOMETHING 2 would never happen!
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform