Hi,

Try something like this:

LOCAL nNextNo
nNextNo = 0
SELECT yourtable
CALCULATE MAX(yourtable.inv_no) TO nNextNo
IF nNextNo > 0
Do your insert here...
ENDIF

HTH.

>I have added your code in my program but the same problem exist. I think my 'set order to inv_no' and other code in my program has conflict. So let me put the question in this way ---
>If I don't use 'Set order' command, how can I find the maximum 'inv_no' in my table?
>
>