General information
Category:
Coding, syntax & commands
>>I'm trying to update records that have been printed (the cursor "workorders" contains the work orders that have been printed). The records in the main table need to have a flag set so that they do not print again. The following code works perfectly when I'm debugging, however when running as an EXE nothing is updated, and it looks like the scan is not processing anything.
>>
>
>As the others said, you can replace this with one line of code. However, figured I'd answer the original question.
SPOILSPORT
>My guess is that you're running this code in a form with a grid on it and the grid is stealing focus, so you're not in the right workarea.
>
>As a rule, every single REPLACE command should include the IN clause to indicate what workarea it applies to:
>
>REPLACE Alias.Field WITH Value
>
>is not the same as:
>
>REPLACE Field WITH Value IN Alias
>
>I wrote about this in FoxRockX (second issue, I think) and also in my session notes from last year's Southwest Fox.
>
>Tamar
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only