In the demo DISQLite3_World_ClientDataSet.dpr DISQLite3UniDirQuery.SelectSQL = 'SELECT * FROM Countries' If i change it in: SELECT * FROM Countries ORDER BY NAME I continue to see the lines in their insertion order. Besides if i write SELECT * FROM Countries WHERE name > 'C' I get all the lines unless i change something in the form in order to let the program feel the change in the sql instruction. Thanks -- edoardo falzetti _______________________________________________ Delphi Inspiration mailing list yunqa@xxxxxxxxxxxxx //www.freelists.org/list/yunqa