>>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