Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Relating Two Tables
Message
From
13/12/2005 14:47:51
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
13/12/2005 14:34:52
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:
01077623
Views:
57
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
Next
Reply
Map
View

Click here to load this message in the networking platform