|
| Re: Display Character With Number |
 |
Mon, 3 Mar 2008 08:01:51 -0800 |
These are values, right? You don't have to do it but if you want a
sort/index to display in the proper order you'll need to add the zero.
bigMike
"Edward Racht" <jdrandall@t-online.de> wrote in message
news:gokkz6TfIHA.1880@news-server...
>I have a table field with M1, M2 ... M10 ... S1, S2 ... S10 values
>
> To display as M1, M2, ... M10 ... S1, S2 ... S10 do I need to put a zero
> before the single digit as M01, M02 ... M10?
>
> Ed
|
| Post Reply
|
| Display Character With Number |
 |
Mon, 03 Mar 2008 09:56:03 -050 |
I have a table field with M1, M2 ... M10 ... S1, S2 ... S10 values
To display as M1, M2, ... M10 ... S1, S2 ... S10 do I need to put a zero before
the single digit as M01, M02 ... M10?
|
| Post Reply
|
| Re: Display Character With Number |
 |
Mon, 3 Mar 2008 22:24:02 +0100 |
Edward:
I always think of which is going to be the largest number I am going to
reach
and I add zeros.
So if the maximun value will be 9999
I will go for M0001 IN THAT WAY ALWAYS WILL BE IN THE CORRECT ORDER
Emilio
"Edward Racht" <jdrandall@t-online.de> escribió en el mensaje
news:gokkz6TfIHA.1880@news-server...
>I have a table field with M1, M2 ... M10 ... S1, S2 ... S10 values
>
> To display as M1, M2, ... M10 ... S1, S2 ... S10 do I need to put a zero
> before the single digit as M01, M02 ... M10?
>
> Ed
|
| Post Reply
|
| Re: Display Character With Number |
 |
Tue, 4 Mar 2008 01:34:48 -0500 |
In article <gokkz6TfIHA.1880@news-server>, jdrandall@t-online.de says...
> I have a table field with M1, M2 ... M10 ... S1, S2 ... S10 values
>
> To display as M1, M2, ... M10 ... S1, S2 ... S10 do I need to put a zero
before the single digit as M01, M02 ... M10?
>
> Ed
Edward,
Emilio is right. As before, you need the leading zeroes to get the
correct sort order. Otherwise, you will get this:
M1
M10
M2
M3
M4
S1
S10
S2
--
Geoff Wass [dBVIPS]
Montréal, Québec, Canada
.|.|.| dBASE info at http://geocities.com/geoff_wass |.|.|.
.|.|.| ---------------------------------------------------------- |.|.|.
|
| Post Reply
|
| Re: Display Character With Number |
 |
Tue, 04 Mar 2008 04:22:10 -050 |
Emilio
Thank you. You, Geoff and bigMike verified what I was experiencing.
Your recommendation will be used.
Ed
> Edward:
>
>
> I always think of which is going to be the largest number I am going to
> reach
> and I add zeros.
>
> So if the maximun value will be 9999
>
> I will go for M0001 IN THAT WAY ALWAYS WILL BE IN THE CORRECT ORDER
>
> Emilio
>
>
>
> "Edward Racht" <jdrandall@t-online.de> escribió en el
mensaje
> news:gokkz6TfIHA.1880@news-server...
> >I have a table field with M1, M2 ... M10 ... S1, S2 ... S10 values
> >
> > To display as M1, M2, ... M10 ... S1, S2 ... S10 do I need to put a
zero
> > before the single digit as M01, M02 ... M10?
> >
> > Ed
>
>
|
| Post Reply
|
|
|
|
|
|
|
|
|
|