Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why does this not work?
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Environment versions
Visual FoxPro:
VFP 8
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00970191
Message ID:
00970750
Views:
23
I agree. It processes much faster with one REPLACE statement as opposed to individual statements.

Cathy


>I'd preffer (if using REPLACE) to write it in one-line aproach:
>
>
>
>APPEND BLANK IN INVCount
>REPLACE INVCOUNT.cLocation WITH TempLoc,;
>        INVCOUNT.cUpc WITH TempUpc,;
>        INVCOUNT.nCount WITH 1 ;
>   IN InvCount
>
>
>
>HTH
>
>
>			Append Blank In INVCOUNT
>			Replace INVCOUNT.CLOCATION With TEMPLOC
>			Replace INVCOUNT.CUPC With TEMPUPC
>			Replace INVCOUNT.NCOUNT With 1
>
>>Christopher,
>
>>You are doing an APPEND BLANK IN, but you are not REPLACEing IN, that might bring you wrong results. I would use Fabio's approach of using INSERT instead of APPEND/REPLACE
Cathy Pountney, Microsoft Visual FoxPro MVP
Memorial Business Systems, Inc. (www.mbs-intl.com)

My Website: (www.frontier2000.com)
My Blog: (www.cathypountney.blogspot.com)
My Book: The Visual FoxPro Report Writer - Pushing it to the Limit and Beyond
Free MSDN Article: What's New in the VFP 9.0 Report Writer
Free MSDN Article: The VFP 9.0 Report Writer In Action
Previous
Reply
Map
View

Click here to load this message in the networking platform