Mensaje
De
11/12/2006 07:44:02
a
11/12/2006 07:39:19
General information
Foro:
Visual FoxPro
Category:
Bases de datos, tablas, vistas, índices y SQL
Título:
Re: Sql order by
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
SAMBA Server
Database:
Visual FoxPro
Miscellaneous
ID de la conversación:
01176457
ID del mensaje:
01176493
Views:
9
>>>i want to create a sql statement for character field with index.
>>>
>>>sele accode, billdate, billno, amt from xcash2 group by accode, billno into curs ccust order by billdate,billno
>>>
>>>billno is a character field.
>>>
>>>this showing billnos
>>>1
>>>10
>>>11
>>>12
>>>13
>>>14
>>>15
>>>16
>>>17
>>>18
>>>19
>>>2
>>>20
>>>21
>>>
>>>but i want to see like :
>>>1
>>>2
>>>3
>>>4
>>>5
>>>6
>>>
>>>
>>>warm regards,
>>>mk.
>>
>>
>Hi BB
>
>Wouldn't that still be in the same order - OrdBy still being char data?
>I bow to you superior SQL knowledge, but I would have used:
>
>SELECT *, VAL( BillNo) AS OrdBy FROM ..... ORDER BY OrdBy
>
>Terry
No, because this char field is left-padded with [0], you have:
[00001]
[00002]
[00003]
...
in OrdBy field.
>>>
>>>sele accode, billdate, billno, amt from xcash2 group by accode, billno into curs ccust order by billdate,billno
>>>
>>>billno is a character field.
>>>
>>>this showing billnos
>>>1
>>>10
>>>11
>>>12
>>>13
>>>14
>>>15
>>>16
>>>17
>>>18
>>>19
>>>2
>>>20
>>>21
>>>
>>>but i want to see like :
>>>1
>>>2
>>>3
>>>4
>>>5
>>>6
>>>
>>>
>>>warm regards,
>>>mk.
>>
>>
>>SELECT *, PADL(ALLTRIM(billno),6,[0]) AS OrdBy FROM ..... ORDER BY OrdBy >>>
>Hi BB
>
>Wouldn't that still be in the same order - OrdBy still being char data?
>I bow to you superior SQL knowledge, but I would have used:
>
>SELECT *, VAL( BillNo) AS OrdBy FROM ..... ORDER BY OrdBy
>
>Terry
No, because this char field is left-padded with [0], you have:
[00001]
[00002]
[00003]
...
in OrdBy field.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
The only thing normal about database guys is their tables.