你的id字段是字符类型,排序当然没错
而你要求的是按数字排序,所以用一个数据类型转换就行了.adoquery1.sql.add('select * from TABLE where id='''+Form_main.id+'''and id is not null ORDER BY cast(PORT_id as int) ')
而你要求的是按数字排序,所以用一个数据类型转换就行了.adoquery1.sql.add('select * from TABLE where id='''+Form_main.id+'''and id is not null ORDER BY cast(PORT_id as int) ')
adoquery1->sql->add("select * from TABLE where id='''+Form_main.id+'''and id is not null ORDER BY cast(PORT_id as int) ")