[SOLVED] Record sorting SQLite

[Pe3s]

Hello, is it possible to sort records in such a way that the database remembers the sorting?

Code: Pascal  [Select][+][-]

1. procedure TForm1.SpeedButton5Click(Sender: TObject);
2. begin
3.    ZQuery1.SQL.Text := 'SELECT * FROM users ORDER BY Name ASC';
4.    ZQuery1.ExecSQL;
5.    ZQuery1.Open;
6. end;
7.  

[BSaidus]

Short answer: NO

Hello, is it possible to sort records in such a way that the database remembers the sorting?

Code: Pascal  [Select][+][-]

1. procedure TForm1.SpeedButton5Click(Sender: TObject);
2. begin
3.    ZQuery1.SQL.Text := 'SELECT * FROM users ORDER BY Name ASC';
4.    // Use ExecSQL if you need to Insert, Update, Delete a record ( in this case you do not need it )
5.    // ZQuery1.ExecSQL;
6.    ZQuery1.Open;
7. end;
8.  

[Pe3s]

Is there no way to do it in alphabetical order?

[dsiders]

Is there no way to do it in alphabetical order?

'order by NAME asc' is alphabetic order. IF you want case-insensitive alphabetic order use the 'COLLATE NOCASE clause.

Code: MySQL  [Select][+][-]

1. SELECT * FROM users ORDER BY Name COLLATE NOCASE ASC

You can apply collate to the schema too.

[Pe3s]

Thank you