Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Understanding REPLACE command - why I don't get the erro
Message
From
11/03/2002 15:00:44
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00630443
Message ID:
00631152
Views:
24
>>Sergey,
>>
>>I just ran your code with another purpose in mind - to see what would end up in the "Date1" field of table OutPut.
>>
>>It was a surprise to me that Date1 was filled with the date - I had expected it to remain 'empty', assuming that the replace command would 'halt' at that point.
>>
>>I then changed the first replace to not use function "Repl1", saying "...Date1 with DATE()" instead. As expected, I got the overflow, but I surprisingly (to me) also got a date in the Date1 field.
>>
>>Is my expectation - that an unbuffered REPLACE will fill fields named UNTIL it hits an error, then any fields there and beyond remain unchanged - INCORRECT??? I could have sworn it always worked as I expected!?!?!
>>
>< snip >
>
>Fortunately, I don't have much expirience with Numeric Overflow error in the replace command. :) However, I seems to remember that it would stop on the field with overflow. Maybe it was Gather, not Replace?
>
>Anyway, I just tested that code in FPW 2.6a and got the same result as in VFP 7.


It probably was GATHER. Aging minds, you know.
Previous
Reply
Map
View

Click here to load this message in the networking platform