• Registered: 2014-09-06
  • Posts: 805

Topic: 1=1 Order By id desc NOT working

Hi all,
I found that the following script doesn't work in the 6.4 version


Form1.ComboBox1.dbFilter := '1=1 Order By id desc';
Form1.ComboBox1.dbUpdate;


or if I place it in the Menu Filter 

Any solution????

2 Reply by derek (edited by derek 2020-11-16 12:57:25)

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,674

Re: 1=1 Order By id desc NOT working

Hi,
Perhaps try doing it like this (see screenshot in the attached example);  since a couple of versions ago, 'sort field' and 'sort order' were added as new combobox properties instead of doing it with '1=1 order by.......' (which was really just a workaround) in the 'filter' property.
Derek.

Post's attachments

Attachment icon combobox order by.zip 528.99 kb, 213 downloads since 2020-11-16 

3 Reply by v_pozidis (edited by v_pozidis 2020-11-16 13:16:09)

  • Registered: 2014-09-06
  • Posts: 805

Re: 1=1 Order By id desc NOT working

I wanna sort the cmbobox beginning from the last record (id)

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,674

Re: 1=1 Order By id desc NOT working

So, using my earlier example, you'd just type in 'id' instead of 'country'

Post's attachments

Attachment icon screenshot2.jpg 226.7 kb, 97 downloads since 2020-11-16