Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Canada
 Pete Sass
 Tags
Subject: Position Record Changer
Thread ID: 416445 Message ID: 416445 # Views: 60 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Grids
Date: Monday, December 29, 2014 7:56:26 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

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