this code should only add 1 record. i would drop the NEXT 1 -- the replace will work fine. make sure it is only being called once.
>>>USE \workorde.dbf
>PUBLIC mValue
>STORE workordern TO mValue
>SCAN
>mValue = MAX(workordern, mValue)
>ENDSCAN
>GO BOTTOM
>SET OPTIMIZE ON
>****USE \workorde.dbf
>INSERT INTO workorde FROM ARRAY nrec
>REPLACE workordern WITH mValue+1 NEXT 1
>
>Just recently added NEXT 1 to see if it would
>change anything, haven't had a chance to check
>it out thoroughly.
>
>
>vfp 3.0 in win 95
>>>
>>>Is it necessary to select workarea and alias
>>>of a database when inserting or appending?
>>>
>>>I have been using these two commands, however,
>>>they are adding two records instead of one.
>>>
>>>I didn't notice this happening during development,
>>>but user is experiencing this problem. Is it possible
>>>for this to happen on installed version but not developed
>>>version? Default form buffering is set, exclusive on
>>>any thoughts??
>>
>>
>>Can you give examples?
>>
>>
>>Wayne