PB里的排序和ORACLE的排序

测试SQL:
drop table t_test;
CREATE TABLE t_test (cid number(4,0), c1 varchar2(10)) ;

insert into t_test values(001,'aa');
insert into t_test values(002,' ');
insert into t_test values(003,null);
insert into t_test values(004,'bb');
commit;

select * from t_test order by c1 asc;

--------------------
       CID C1       
---------- ----------
         2          
         1 aa       
         4 bb       
         3          

4 rows selected.

PB里的排序(v-pb10.5 Build4523)odbc连接

dw_1.setsort('c1 asc')
dw_1.sort()
--------------------
       CID C1       
---------- ----------
         3          
         2        
         1 aa       
         4 bb