>I am using scan command everytime the form load up, so it calculate every single record. (I want to make sure whatever client enter is being calculate)
>scan
> **calculation
>endscan
>
>I want to know is there any other faster command can get the job done faster. Now, everytime client load the form it take 1 minute or so to open up and that's with 16 meg of ram. I can't imagine if the client have less than 16meg of ram, it probably take a while to load.


There are several ways you can do this:

1) CALCULATE
2) SEEK
SCAN WHILE field = key
* Calculations
ENDSCAN
3) SQL SELECT

Craig

Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer