Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Number of records after replace
Message
From
30/07/2002 16:53:54
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00684132
Message ID:
00684190
Views:
28
>Hi everybody,
>
>I'm executing this command
>
>&lcReplCommand while not m.plStop
>
>I want to know the number of changed records. _Tally is not reliable. Moreover, this command doesn't change records in all file, sometimes it changes only few records...

Some alternative approaches:

  • Use update - sql. Not always as fast as going to a specified record and doing a REPLACE ... WHILE.
  • Use a SCAN loop, and increment your variables yourself. More work than a simple ... WHILE.

    In what sense does _tally not work correctly?

    Hilmar.
    Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
  • Previous
    Next
    Reply
    Map
    View

    Click here to load this message in the networking platform