>>>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.
>>
>>If you don't care about deleted records, then use RECCOUNT(), otherwise use COUNT ... FOR NOT DELETED() and create index tag for NOT DELETED().
>
>
>What kind of calculation are you doing? Have you considered using a trigger?
Oop! May be I misunderstood the question. If it's not aalculation the number of records but something else, then... may be CALCULATE or SELECT-SQL would be helpful. Basically, it's really necessary to know what kind of calculation slowing app down.
Edward Pikman
Independent Consultant