Daniel Kasak schreef:
Jan Bassez wrote:
The reason I use tekst field is because sometime I need to use for
instance: 4A or 4B
I would split the numeric and strings parts. ie have a numeric
field, and then an extra field to store your 'modifier' or whatever.
Then sort by numeric_field,
An other option is to use space-strings with a fix character count
and fill in your numbers from right to left, i.e. rightalign your numbers,
so that they end in the second and then append your modifier.
Your example then look like:
rooms
1
19
2
22
20C
15
2A
2B
23
4
36A
12
16
29
William W. Austin schreef:
On 2006-04-05 01:10:43, Jan Bassez wrote:
Daniel Kasak schreef:
Jan Bassez wrote:
Is there a way to sort numeric values in a normal text view without
converting them the numbers with preceding zero's?
(SNIP)
I would split the numeric and strings parts. ie have a
Jan Bassez wrote:
William W. Austin schreef:
While it would be nice to have a function such as you describe, the
implementation on the coding side is more than a tad complex ... and
most likely very inefficient in the long run.
I think of it because windows explorer does it allright (with my
Niklas Nebel schreef:
Jan Bassez wrote:
William W. Austin schreef:
While it would be nice to have a function such as you describe, the
implementation on the coding side is more than a tad complex ... and
most likely very inefficient in the long run.
I think of it because windows explorer
Jan Bassez wrote:
So, the only way is splitting the fields in the database...
hmm...
I've got almost 1500 records already
First time I use a database program in fact.
additional question:
what should I do with fields who contain this: PV 522 (op.268)
I don't know what this code means,
Jan Bassez wrote:
The reason I use tekst field is because sometime I need to use for
instance: 4A or 4B
I would split the numeric and strings parts. ie have a numeric field,
and then an extra field to store your 'modifier' or whatever. Then
sort by numeric_field, string_field
That's an
Is there a way to sort numeric values in a normal text view without
converting them the numbers with preceding zero's?
Now they are sorted like this:
1
12
15
16
19
2
22
23
29
36
36A
4
...
The reason I use tekst field is because sometime I need to use for
instance: 4A or 4B
Jan Bassez wrote:
Is there a way to sort numeric values in a normal text view without
converting them the numbers with preceding zero's?
Now they are sorted like this:
1
12
15
16
19
2
22
23
29
36
36A
4
...
The reason I use tekst field is because sometime I need to use for
instance: 4A or
Daniel Kasak schreef:
Jan Bassez wrote:
Is there a way to sort numeric values in a normal text view without
converting them the numbers with preceding zero's?
Now they are sorted like this:
1
12
15
16
19
2
22
23
29
36
36A
4
...
The reason I use tekst field is because sometime I need to use
10 matches
Mail list logo
