>I have a customer table which cust_no (Primary Key) is a C(7)
>
>Currently, it will be full "999" and overflow at "1000"
>
>since the system is changed from dBaseIV (manual input) to VFP
>system generate next cust_no key...
>
>I have added a new tag with
Padl(Cust_no,7) or
Padl(Cust_no,7,"-") to make the "1000" at end...
>
>but still fail, it show:
>
>
>1
>10
>100
>1000
>
>in browse window...
>
>What can I do!?
The string is by default already 7 characters long, so the pad has no effect.
Try trimming if first:
PADL( RTRIM(Cust_no), 7)