Delphi Pages Forums  

Go Back   Delphi Pages Forums > Delphi Forum > General

Lost Password?

Reply
 
Thread Tools Display Modes
  #1  
Old 02-11-2019, 05:18 PM
kbboykin kbboykin is offline
Senior Member
 
Join Date: May 2005
Posts: 371
Default Index by Date Descending

How do I sort my DBGrid by descending date? I want the latest date to be at the top of the grid. I have tried this code to execute on title click. The table is in a master-detail relationship. If I click the column it does as expected, but if I move to another record in master table I get this error: 'Argument are of the wrong type, are out of acceptable range, or in conflict with one another'

Code:
procedure TfrmMain.dbFuelLogTitleClick(Column: TColumn);
begin
  AdatMod.fueling.Sort  := ('fYear DESC');
end;
__________________
Using Delphi 2010 Professional as a Novice Programmer - self taught
Reply With Quote
  #2  
Old 02-12-2019, 03:48 AM
Marsheng Marsheng is offline
Senior Member
 
Join Date: Nov 2008
Posts: 314
Default

What DB are you running. Often the sorting is a DB function.
Reply With Quote
  #3  
Old 02-12-2019, 11:25 AM
kbboykin kbboykin is offline
Senior Member
 
Join Date: May 2005
Posts: 371
Default

Quote:
Originally Posted by Marsheng View Post
What DB are you running. Often the sorting is a DB function.
ADO (ms access 2010). And I have the table sorted in the DB, but still shows up in browse screens in app in ascending order, although I store it in the DB in descending order.
__________________
Using Delphi 2010 Professional as a Novice Programmer - self taught
Reply With Quote
  #4  
Old 02-12-2019, 11:38 AM
Norrit Norrit is offline
Moderator
 
Join Date: Aug 2001
Location: Landgraaf
Posts: 7,318
Default

Try to use a Profiler and see what the generated SQL statement is that goes wrong (usually the last before you get the exception)
This will most likely point in the right direction of what part is false (perhaps you do more and use for example a filter or something at an other point which you don't provide here)
Reply With Quote
  #5  
Old 02-13-2019, 02:55 PM
kbboykin kbboykin is offline
Senior Member
 
Join Date: May 2005
Posts: 371
Default

Quote:
Originally Posted by Norrit View Post
Try to use a Profiler and see what the generated SQL statement is that goes wrong (usually the last before you get the exception)
This will most likely point in the right direction of what part is false (perhaps you do more and use for example a filter or something at an other point which you don't provide here)
I'm sorry, I don't understand what a profiler is. I am using ADO directly without SQL -- I use ADOtables with ADOConnection in my app.
__________________
Using Delphi 2010 Professional as a Novice Programmer - self taught
Reply With Quote
  #6  
Old 02-14-2019, 10:07 AM
Norrit Norrit is offline
Moderator
 
Join Date: Aug 2001
Location: Landgraaf
Posts: 7,318
Default

A profiler is an application that lets you see all communication to a database.
Not sure if MsAccess has one (I use it all the time for SQL Server), you should try to google that.

Otherwise you could take a look at the ADOConnection.OnWillExecute event. Log all that goes by there, this should be the point where you can see what the queries that get executed are (but I thought this will only trace select statements)
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump


All times are GMT. The time now is 07:20 PM.


Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2019, vBulletin Solutions, Inc.