SET ODOMETER only has effect for internal VFP counters, like INDEX ON, etc.
If you want to periodically report your progress at some point, do a MOD()
on your counter, something like this:
m.todo = RECCOUNT()
m.done = 0
SCAN ALL
m.done = m.done +1
IF MOD(m.done,100)=0
WAIT WINDOW NOWAIT TRANSFORM(m.done)+" of "+TRANSFORM(m.todo)+"..."
ENDIF
* do your processing here
ENDSCAN
That will show you a WAIT WINDOW every 100 rows processed.
Fred
On Sun, Dec 4, 2011 at 4:12 PM, Sytze de Boer <[email protected]> wrote:
> I think it must be brain fade or something
>
> I have tried different things but can't seem to find a solution
> I have a large table that needs manipulating
>
> Select winstoks
> Go Top
> mtodo=Reccount()
> mdone=0
> Do Case
> Case Reccount()>100000
> Set Odometer To 10000
> Case Reccount()>10000
> Set Odometer To 1000
> Case Reccount()>1000
> Set Odometer To 100
> Otherwise
> Set Odometer To 10
> Endcase
> Set Talk On
> Set Talk Window
>
> Scan
> mdone=mdone+1
> Wait Window Nowait Str(mdone)+" / "+Str(mtodo)
> Do windnewpric2
> Select winstoks
> Endscan
>
> Set Talk Off
> Wait Clear
> Set Odometer To 100
>
> in this case the table has 81,000 records
> The problem is that it chooses to freeze the wait window factor at a random
> number and it looks like the system is frozen
> But in fact, it is still processing
> The app in fact tells you it is "not responding" but if you leave it long
> enough, it will complete normally
>
> I've also tried this with a thermometer routine, and it does the same thing
> i.e. it looks like the thermometer is frozen at a particular point so
> people use the task manager to abort the routine
>
> As a second observation, the set odometer seems to have no effect
>
> (It's monday morning here ..................)
>
>
> --
> Regards
> Sytze de Boer
> Kiss Software
>
>
> --- StripMime Report -- processed MIME parts ---
> multipart/alternative
> text/plain (text body -- kept)
> text/html
> ---
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/CAJCBksrkXUeEFKs2er7LsG=8mdq+hzly4wd8a_3qw-w8mun...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
