Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Koen Piller
  Where is Koen Piller?
 Santpoort-Zuid
 Netherlands
 Koen Piller
 To: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Canada
 Pete Sass
 Tags
Subject: RE: Position Record Changer
Thread ID: 416445 Message ID: 416452 # Views: 53 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Grids
Date: Monday, December 29, 2014 9:07:16 PM         
   


> Hi Foxitians,
>
> I put this is the Grid category, but this may not require a Grid to
> make display order changes.
>
> I do not know what it requires - lol
>
> Let me explain this for you all. I have a couple of small tables
> that hold employee names and payment types in a POS system. The
> users have requested a real easy way to change the order of the way
> the information is displayed in a Grid, "that's why I put this in the
> Grid category."
>
> The total records will not exceed much more that 20 and in most cases
> only 8-10 records.
>
> So what I an envisioning is something like the way VFP allows us to
> change the field order in the table designer . . .
>
>
> So once you click on the record you can bump it up or down in the order via a drag and
> drop or clicking the up and down arrow would work equally as well. I think I like the
> up / down arrow approach better than drag and drop.
> Then once set this is the new default display order and this is saved until changed again.
>
> A good example of where I may wish to use something like described above is
> here in the payment type process shown below.
>
>
> CASH payment is set as the first selection, but the clients want to say no - no I want
> DEBIT payment on this till as the first option, but on the front quick takeout for coffee and
> small items, I want CASH as the first option, etc.
>
> So I want something that maybe could be done right in the Grid or could due to the small
> number of records be done in a cursor or array and popup another form with a Grid to set
> the order and then close down the form and refresh the main selection Grid and with the
> refresh the new default order is now set here and remains so until changed again.
>
> ANYONE EVERY SEEN ANYTHING LIKE THIS DONE??
>
> Pete "the IceMan", from the Great White North of Canada.
> www.marathongriffincomputers.com



Pete,

do I understand correctly you would like to have a grid which allows end-users to change the sequence of records by drag-and-drop? I would use a listbox, this has drag and drop. Do you need an example?

Regards,

Koen

ENTIRE THREAD

Position Record Changer Posted by Pete Sass @ 12/29/2014 7:56:26 PM
RE: Position Record Changer Posted by Koen Piller @ 12/29/2014 9:07:16 PM
RE: Position Record Changer Posted by Pete Sass @ 12/29/2014 11:19:50 PM
RE: Position Record Changer Posted by Koen Piller @ 12/30/2014 8:03:48 AM
RE: Position Record Changer Posted by Pete Sass @ 12/30/2014 1:50:39 PM
RE: Position Record Changer Posted by Ali Koumaiha @ 12/29/2014 9:37:47 PM
RE: Position Record Changer Posted by Chuanbing Chen @ 12/30/2014 12:55:38 AM
RE: Position Record Changer Posted by Jun Tangunan @ 12/30/2014 2:27:11 AM