Board index » delphi » Q: Sorting a Databound Grid Or Moving Record's

Chris

Delphi Developer
Sun, 09 Nov 2003 22:50:09 GMT

Q: Sorting a Databound Grid Or Moving Record's

Ok i have a databound grid and i want the user to be able to shift selected
record's up or down ie 1 to 3 or 3 to 1, i've been contemplating on how to
this, is there a better way then having an extra sort field in the database
so when a user move's a record you change the sort value's? i think this
might be time consuming, any other way's?

Thanks

--
Chris Polewczuk
MT/Rush/Ergo 50
http://www.elogik.com

 
Bj?rge S?the

Delphi Developer
Mon, 10 Nov 2003 18:22:05 GMT

Re:Q: Sorting a Databound Grid Or Moving Record's


"Chris" <chris...@videotron.ca> skrev i melding
news:f3QO6.2296$6Y6.605962@weber.videotron.net

Quote
> Ok i have a databound grid and i want the user to be able to shift selected
> record's up or down ie 1 to 3 or 3 to 1, i've been contemplating on how to
> this, is there a better way then having an extra sort field in the database
> so when a user move's a record you change the sort value's? i think this
> might be time consuming, any other way's?

If your displayed dataset relies on actual stored order, and no indexing
whatsoever comes into play, you could try just exchanging the values. I'd
rather suggest a hidden sort field, as non-indexed tables are sometimes
showing odd behaviour when attempting to refresh records from the underlying
table.

--
Bjoerge Saether
Consultant / Developer
http://www.itte.no
Asker, Norway
bjorgeremovet...@itte.no (remove the obvious)

Chri

Delphi Developer
Tue, 11 Nov 2003 00:06:27 GMT

Re:Q: Sorting a Databound Grid Or Moving Record's


the other option might be unbound, it's not just for display it's for
working purposes... ie: a part's grid whereas instead of changing the item's
for oder being to shift items up/down....

Quote
"Bj?rge S?ther" <REMOVE_bsaether@THIS_online.no> wrote in message

news:Dy6P6.448$lM3.7574@news1.oke.nextra.no...
Quote
> "Chris" <chris...@videotron.ca> skrev i melding
> news:f3QO6.2296$6Y6.605962@weber.videotron.net
> > Ok i have a databound grid and i want the user to be able to shift
selected
> > record's up or down ie 1 to 3 or 3 to 1, i've been contemplating on how
to
> > this, is there a better way then having an extra sort field in the
database
> > so when a user move's a record you change the sort value's? i think this
> > might be time consuming, any other way's?

> If your displayed dataset relies on actual stored order, and no indexing
> whatsoever comes into play, you could try just exchanging the values. I'd
> rather suggest a hidden sort field, as non-indexed tables are sometimes
> showing odd behaviour when attempting to refresh records from the
underlying
> table.

> --
> Bjoerge Saether
> Consultant / Developer
> http://www.itte.no
> Asker, Norway
> bjorgeremovet...@itte.no (remove the obvious)

Other Threads

1. Database link'n'joining Qs

2. Sort Record after using 'union' command

3. Moving selected record to top of grid

4. Sorting A String Grid with a secondary sort field

5. Typing in lookup combo box doesn't move pointer to new record

6. Can't Move to Next Record

7. Don't post a record after moving in a DBGrid

8. Fast copying records in sorted order / was Sorting

9. How to drag record from grid to grid

10. Very slow to move from record to record (Delphi2, local dBase)