Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Navigating Through Records
Message
From
08/10/2002 04:40:57
 
 
To
07/10/2002 16:11:10
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00708510
Message ID:
00708652
Views:
13
Hi,

<<
I need help with navigation. I have a table which has part numbers entered in random order the part numbers are like such. 117124,117124-001,117124-003,117125,117126,117126-001. When I use navigation on my form I need some method to make sure I get the part numbers with dashes to show up. Right now it will go 117124,117125,117126 etc.
<<

Maybe:
INDEX ON PADR(ALLT(CHRTRAN(Partno,"-","")),LEN(Partno),"0") Tag PartOrder
HTH,
Viv
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform