Path: utzoo!utgpu!news-server.csri.toronto.edu!bonnie.concordia.ca!uunet!munnari.oz.au!uniwa!fennel.cc.uwa.oz.au!a_dent
From: a_dent@fennel.cc.uwa.oz.au
Newsgroups: comp.databases
Subject: Re: FoxBASE+/Mac Help
Message-ID: <1991Feb2.212203.2877@fennel.cc.uwa.oz.au>
Date: 2 Feb 91 13:22:03 GMT
References: <27A44D8D.10912@unifybb.uucp>
Organization: University of Western Australia
Lines: 54

In article <27A44D8D.10912@unifybb.uucp>, ralph@unifybb.uucp (Florida State U./ISPA) writes:
> 
> 
>         I would like to have a multi-entry form for the above
>         structure that looks like this:
> 
>     -----------------------------------------------------------------
>     |   Bud_no | Level   |Stu_name        |Dept            |Stipend |
>     -----------------------------------------------------------------
>     | 344554   | G       | Marcus         |Geo             |  123.00|
>     |    "     |   "     |     "          |       "        |    "   |
>     |          |         |                |                |        |
>     |          |         |                |                |        |
>     |          |         |                |                |        |
>     -----------------------------------------------------------------
> 
I assume you wish to enter data directly into these fields ("data-entry
form").

You can either use the BROWSE facility or a grid of fields.

If you use BROWSE, you can't apply any data validation as BROWSE is very
modal and doesn't let you put validation clauses on fields.  This will
hopefully change in FoxPRO/Mac which should be out this or next quarter
(according to FOX Technical Support, in November 1990).

If you code a grid of fields, you could implement a "scroll-up" and
"scroll-down" buttons that would actually move the values from one row
of fields to the next. This could be made prettier onscreen using the 
SCROLL command.

Unfortunately, the scrolling lists in FoxBASE aren't enterable, so these
are the only two options I can think of (other than writing an external).

I heartily recommend the book "Dynamics of FoxBASE+/Mac Programming" by 
George F Goley IV.  Publisher Dow Jones Irwin, ISBN number 1-55623-272-1.

We spent a lot of time trying to make FoxBASE+/Mac measure up to what we
do in 4D (close) and would have saved many hours of experimentation with
this book.  From memory, he includes code on how to do the scrolling trick
I described above and all the (plentiful) code in the book can be 
ordered on disk.

> 
> 
> E-Mailing address
> 
> Reply to this message...
> BNetRB@%FSU.BITNET@vtvm1.cc.vt.edu    Internet
> BNetRB@RAI.CC.FSU.EDU                 BITNet
Andy Dent                     A.D. Software phone 09 249 2719
Mac & VAX programmer          94 Bermuda Dve, Ballajura
a_dent@fennel.cc.uwa.oz       Western Australia  6066     
a_dent@fennel.cc.uwa.oz.AU (international)