Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Very slow grid!
Message
From
09/05/1997 03:05:37
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Very slow grid!
Miscellaneous
Thread ID:
00031451
Message ID:
00031451
Views:
82
I am using a grid as a checkbook register. I also have a routine (see below) which populates the account balance field. This routine runs on startup and again whenever the sort order is changed.

The problem is that the grid scrolls very slowly after running this loop. I've isolated the REPLACE line as the culprit. If I rem out this line, then the grid scrolls normally, of course, there's no account balance...

The problem occur even outside of the grid (using a browse). In the browse lines that are remmed out below, the first browse is fine and the second one, after the replaces is not. By the way, the transact file has 3300 records, but I've tried it with 99 and get the same behaviour.

I'm running VFP5.0 on a Compaq Presario 100mhz with about a hundred meg of free disk space and 32 meg of RAM. There are no other apps running.

What gives? Thank you in advance...


Here's the code
---------------
SELECT TRANSACT
nRetRec = RECNO()
nTotRec = RECCOUNT()
nCount = 0
GO TOP
nBalance = 559.14
* BROWSE
SCAN
nBalance = nBalance + TrCredit - TrDebit
nCount = nCount + 1
@ 05,02 say nCount
REPLACE ACCTBAL WITH nBalance
ENDSCAN
GOTO nRetRec
* BROWSE
Next
Reply
Map
View

Click here to load this message in the networking platform