delphidelphi-7delphi-2010delphi-2009dbgrid
Delphi DbGrid order by ID
Am showing data from database in DBGrid and in my Command text. I want to display data in ascending but all time is descending i dont know whay.
In command text in Client DataSet i set: SELECT * FROM groups ORDER BY ID ASC but when i compaile and grid is showed list is again start from ID=3.
What i do wrong
Solution
Do you set a value in the IndexFieldName property of your Dataset ?.
This would override any order in your commandtext, because no matter in which order you retrieve the data, your data will posteriorly be locally ordered as your IndexName or IndexFieldName defines.
- Using Advanced Installer DLL with Delphi
- C++Builder 12 error in dynamic OnDocumentComplete event assignment for TCppWebBrowser
- How to debug Delphi IDE?
- How to 'parent' a form? (Controls won't accept focus)
- Avoid that SetFocus raises an Exception
- Any hints for those that want to upgrade from Delphi 7 (and down) to Delphi 2010?
- TIdTCPServer hangs when setting Active = false
- Error : Using Microsoft WebService.dll to canonicalize XML with Delphi7
- Smoothly TDBGrid scrolling
- How do I sort a generic list using a custom comparer?
- Vcl.Printers.pas(888): W1025 Unsupported language feature: 'custom attribute'
- Compiler directive SETPEFlags in Delphi 5
- How to remove the seconds from TTime without resorting to TimeToStr(const datetime:TDateTime; const formatsettings:TFormatSettings)
- How to get list of opened files in Delphi IDE
- How can I retrieve the GUID's for the network adapters on my system?
- What is the URL to access a RAD Server custom module on IIS?
- How to convert a form to a frame?
- How to work with 0-based strings in a backwards compatible way since Delphi XE5?
- How can I auto resize the TWebComboBox's width to match the selected option's width in TMS WEB Core?
- How to record microphone to MP3 with Delphi 10.4.2 on FMX Windows?
- Auto append/complete from text file to an edit box
- COM Port Commands CRC XOR
- How to load a file into a stream on Android knowing its Jnet_Uri?
- Delphi notification when a file gets updated
- Any build-in function like PosEx that finds a sub-string starting from the back of the string?
- Delphi how to Serialize and Deserialize TObject
- Selecting a directory with TOpenDialog
- How to make a function that takes 2 dimensional array of Extended and return TArray<Extended>?
- How to make Windows notification display application title instead of EXE filename?
- FMX + Android + Rotation