Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Order Tag on Numeric String!
Message
From
30/06/1999 05:57:10
Mark Hall
Independent Developer & Voip Specialist
Keston, Kent, United Kingdom
 
 
To
30/06/1999 05:32:42
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00235738
Message ID:
00235740
Views:
20
>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)
Regards
Mark

Microsoft VFP MCP
Menulib - OO Menus for VFP www.hidb.com/menulib
Previous
Reply
Map
View

Click here to load this message in the networking platform