Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Order Tag on Numeric String!
Message
De
30/06/1999 05:57:10
Mark Hall
Independent Developer & Voip Specialist
Keston, Kent, Royaume Uni
 
 
À
30/06/1999 05:32:42
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00235738
Message ID:
00235740
Vues:
21
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform