Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only