Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
0000,0001... etc
Message
 
 
To
28/10/2004 11:19:33
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 6
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00955300
Message ID:
00955340
Views:
16
Adjust sticker field size and the second parameter in the PADL() function accordingly. Or even better
CREATE CURSOR crsTemp ( sticker C(5))
FOR i=1 TO 10000
  INSERT INTO crsTemp VALUES( PADL(i,LEN(sticker),"0"))
ENDFOR
>It's only example.
>If the value in 1 I need 00001
>If the value is 10 I need 00010
>If the value is 100 I need 00100
>If the value is 1000 I need 01000
>If the value is 10000 I need 10000
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform