Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Relating Two Tables
Message
From
13/12/2005 17:59:24
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
13/12/2005 14:54:15
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01077578
Message ID:
01077680
Views:
43
>My comment was also ment for Jerry. And I have seen many cases where people have dropped important lines because they did not think they were important. :-)

I don't understand why you don't reply to him directly then.

>
>>I know that, BUT from the code snippet there are no filters. LOCATE would work too.
>>
>>>In general, SEEK In Tablename or SKIP 0 in Tablename are better solutions. In this case the difference may be minimal, but if a SET FILTER is in effect, GO TOP can be extremely slow.
>>>
>>>>Put a GO TOP IN TableName
>>>>
>>>>after every set relation command.
>>>>
>>>>>Thanks! Unfortunately, I tried that and it didn't work, although I tried it again just now. I also tried SCAN...ENDSCAN, and putting additional code before the SEEK line. So far, none of it does the job.
>>>>>
>>>>>Jerry
Previous
Reply
Map
View

Click here to load this message in the networking platform