Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sums
Message
From
06/03/2003 13:04:24
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Sums
Miscellaneous
Thread ID:
00761911
Message ID:
00762298
Views:
17
>Terry, Thanks. I will study this. To make sure I understand.
>Without having looped through a file,
>Let,'s say I am at record no. 300, in a table with 1000 records.
>Field 1 is call myfield.
>
>There is no function that will return the value for myfield
>but for record 200 without first doing a
>go 200, getting the myfield value,
>and then returning to record 300?
>
>Because it would seem that doing a "go 200" would be slow compared to some kind
>of native vfp command that knew how to return the value for myField.record = 200
>Thanks very much
>Steve

GO 200 would be very fast because VFP uses fixed length records, so it's just a simple calculation. If you know you're going to need the value of some other record for later processing, you might be able to use the SCATTER NAME command to create an object reference while you're on that record. At least that way, you'd have no need to "go back" to it later. If there's the possibility that someone else could be changing that record, you could have problems, as you are no longer looking at the "current value", only your snap-shot of it stored in the object created by SCATTER NAME.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Reply
Map
View

Click here to load this message in the networking platform