General information
Category:
Forms & Form designer
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?
>
>
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