FoxPro Set Selection 
Author Message
 FoxPro Set Selection

   Hi,
   I've been programing in a MAC data base called 4D for a year now, but
it is time to upgrade the version. ACI wants $3,000 dollars for 4D server
3.1 with a 10 user license, Microsoft wants $695 for unlimitted users...
sounds good. I've been on the phone with Microsoft quite a bit the past
week, and they've done a good job answering my questons, except for one.
4D makes it very easy to create a custome table (like a browse window),
present it to the user, and allow them to traverse the (sub)set. They can
then create further subsets by holding down the SHIFT key and clicking
table entries then selecting "Show subset". I've been furiously rumageing
through FoxPro manuals and books and have found the wounderfull browse
window (does not apear to suport this), pop-up pickers are the closest
I've found, however they are only one dimentional arays, I want to be
able to splash multiple fields to the screen. Also, in a muti user data
base, records may change as there held in an array. I've heard that there
are third party enhancements to the picker, has anybody seen any? It
seems that user defined subsets from a list of records in table format is
a pretty basic feature. Please help me abondon 4D! Pave the way to the light!

                                To the point; Maybe; Long winded; Definatly
                                        thanks -- peace

p.s. I read the descusions on user selectable sets but none seeemed to
hit this point specificly



Fri, 12 Jul 1996 11:23:02 GMT
 FoxPro Set Selection

Quote:
>4D makes it very easy to create a custome table (like a browse window),
>present it to the user, and allow them to traverse the (sub)set. They can
>then create further subsets by holding down the SHIFT key and clicking
>table entries then selecting "Show subset". I've been furiously rumageing
>through FoxPro manuals and books and have found the wounderfull browse
>window (does not apear to suport this), pop-up pickers are the closest
>I've found, however they are only one dimentional arays, I want to be
>able to splash multiple fields to the screen. Also, in a muti user data
>base, records may change as there held in an array. I've heard that there
>are third party enhancements to the picker, has anybody seen any? It
>seems that user defined subsets from a list of records in table format is
>a pretty basic feature. Please help me abondon 4D! Pave the way to the light!

>                            To the point; Maybe; Long winded; Definatly
>                                    thanks -- peace

>p.s. I read the descusions on user selectable sets but none seeemed to
>hit this point specificly

Hmm... what you are describing is NOT a "pretty basic feature" in the Xbase world.  At
least not with FoxPro.  It WOULD be pretty nice to have something like that you could just
call.  Anyhow, you will probably have to use ON KEY LABEL to trap SHIFT+CLICK
(make sure that keystroke is ON KEY LABEL-able... you may have to use another keystroke
combination) and call a procedure to set a flag field in that record to .T.  
Then when the user chooses "Show subset", use SET FILTER TO flagfield=.T. and reissue
the BROWSE command.
I haven't tried this, and there are some possible gotchas that spring to mind:
  * FoxPro does not give you the kind of color control you would need to highlight the
     flagged records in a different color than the unflagged records.  You would probably
     need to have the flag field the first field in the browse so the user can see which records
     are marked.
  * FoxPro's browse allows the user to toggle records as DELETED by clicking in the space
     to the left of the first field.  This is similar enough to the behavior you describe above
     to possibly cause user confusion.  However, come to think of it, if you simply work on an
     updatable CURSOR (a temporary table) rather than the live data, you could eliminate
     the whole flag-field business, and just SET FILTER TO DELETED().  Of course, if you ever let
     users BROWSE on the real database, they could really{*filter*}things up, since it really
     does mark records deleted.
  * On a liv]e-data browse you should add a record-locking error-handling routine if running multi-
     user in the BROWSE level WHEN clause.  If BROWSEing a cursor, of course, the data is the
     data at the time the records were selected into the cursor... later updates do not show up.

You mention third party enhancements to the picker.  The most famous I've heard about
is a shareware INCREMENTAL SEARCHING tool called jKey.  It allows the user to, for example, type "J"
while in the name column, and a seek is made to the next entry beginning with "J".   jKey has been
around for awhile.  It was just written up in FoxTalk in August 1993.
Written by Joe Gotthelf (August Technologies, 41 Willowbrook Rd, Broomall, PA 19008-1749, $30).
It is actually a function written in C which is installed in memory with a SET LIBRARY TO
command.

joan



Sat, 13 Jul 1996 21:39:38 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. set century on problem with FoxPro DOS 2.5 and FoxPro Win 2.6a

2. FoxPro for Windows - Help on button selection

3. Field selection in Foxpro 25 applications

4. Setting TEXTSIZE for "text" data selection

5. Need help on character set selection!

6. SQL Selection Set Questions

7. SQL Selection Set Questions

8. Alpha4v6 record selection in a set

9. SETTING NULL OFF in FoxPro Using VB and ADO

10. Can't set field size when creating FoxPro DBF

11. Trouble opening a record set on a Foxpro 3.0 dbf

12. SET NULL OFF in FoxPro 2.6 Using VB and ADO


 
Powered by phpBB® Forum Software