Walter Meester
HoogkarspelNetherlands
General information
Category:
Coding, syntax & commands
Hi sheena,
>>>replace all May_1998 with 2 for May_1998 = 0 and ((start_da < {1998/06/01}) and (final_da > {1998/05/01}))
>>>
>>>thanks in advance.
>
>Hi :
>
>not doing a replace when I have records that meet the criteria.
It might be a problem with an index order which is based on the May_1998 column. To identify if this is the problem add a NOOPTIMIZE clause at the end of the command and check if this works.
Another possibility is that your SET DATE setting is sert at something else as AMERICAN. Check what {1998/06/01} evaluates to by doing a WAIT WINDOW DTOC({1998/06/01}) before the replacement.
Good luck.
Walter,
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