IT SOLUTIONS
Your full service technology partner! 
Ron Roper -Collapse +Expand
-Collapse +Expand
ronroper
-Collapse +Expand Profile◄╣
Member Info
Member Narration

POSTS:
MB Posts (3)

Search ronroper:

Advanced
Personal Account . . .
Ron Roper
Melbourne, Australia



Real Name:  Ron Roper
Primary Role:  Coder
Joined: Jun 2002 (18 years ago)
Visits: 6
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Message Boards Activity

3 posts.
More...

Thread 3 of 3
Thread Starter or a Reply (but not last)  Group

Ron Roper
How to change sort to descending?
{Too Long!}
Posted to MB Topic: Delphi Single User Apps « Delphi Board
18 years ago

rdkram

If it is an index, then by default it is automatically ascending.

When selecting the data, include a SORT BY clause and then DESC for descending - it is automatically ascending by default. Here is an example:
SELECT FieldA, FieldB, FieldC FROM Employee ORDER BY FieldB; 
SELECT FieldA, FieldB, FieldC FROM Employee ORDER BY FieldB DESC;

 

9 years ago
Nothing New Since Your Last Visit
8000
Hits

Pascal and Delphi Coding

Thread 2 of 3
Thread Starter or a Reply (but not last)  Group

Ron Roper
Re: How to change sort to descending?
Thanks Rick for that advice, I created separate descending indexes and it works fine., , I am interested in following the best path regarding the future of the BDE etc. The project I am working on is expected to be around for some time so I do need to use a supported database format. Briefly, it is a single user application using a local database consisting of about 70 separate paradox tables along with all the index files etc. It is a complex highway pavement modelling and lifecycle tool., , I have considered changing it over to an MSAccess database so that I only have one database file instead of over 200, which would also allow easy updating of tables using Access if necessary. I haven't done enough database programming to be sure of the best solution. Can I use MSAccess files without using the BDE?, , Regards, , Ron Roper, ARRB Transport Research, Melbourne Australia
Posted to MB Topic: Delphi Single User Apps « Delphi Board
18 years ago
Nothing New Since Your Last Visit
2
Hits

Pascal and Delphi Coding

Thread 1 of 3
Thread Starter or a Reply (but not last)  Group

Ron Roper
Can't control visibility in DBCtrlGrid ?
I am using a DBCtrlGrid to display several records on screen at once. The control grid has a DBCheckBox and a DBEdit on it. I am trying to control the Visible state of the DBEdit according to the Checked state of the DBCheckBox., , When a checkbox is clicked (I am using the OnClick event), the corresponding DBEdit behaves correctly, however all the other DBEdits (for the other records) change state whenever I move to another record. , , I notice that the controls placed on a DBCtrlGrid actually appear with the Form as their parent in the object inspector., , Is there any way to determine which instance of the controls I am dealing with at any one time and limit the effects to just one record at a time., , Thanks for any help, , RonR , --------------------------------------------------------------------------------
Posted to MB Topic: Delphi VCL « Delphi Board
18 years ago
Nothing New Since Your Last Visit
4062
Hits

Pascal and Delphi Coding
Sales Website: www.prestwood.com Or visit our legacy sales site: 
legacy.prestwood.com


©1995-2020 Prestwood IT Solutions.   [Security & Privacy]