ralph@unifybb.uucp (Florida State U./ISPA) (01/29/91)
I have the following FoxBASE+/Mac database structure:
Field Field Name Type With Dec
------- --------------- --------------- ------- ---
1 bud_no Character 10
2 level Character 1
3 stu_name Character 50
4 dept Character 20
5 stipend Numeric 11 2
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 would really appreciate any suggestions as to how
to code this type of form. I'm new to FoxBASE+/Mac and
I need to get this form ready as quickly as possible.
Contacts:
FREAC/CAR/FSU
Ralph Axel Zuniga Ph: (904)644-3410
Fax: (904)574-6704
E-Mailing address
Reply to this message...
BNetRB@%FSU.BITNET@vtvm1.cc.vt.edu Internet
BNetRB@RAI.CC.FSU.EDU BITNetpew@cs.brown.edu (Peter E. Wagner) (01/30/91)
|> 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'm not exactly clear on the functionality of this form. Are you inputting new records, editing old ones, both, etc.? Is it for "dumb" users or will they have some training? Also, I am speaking from familiarity with Fox products in DOS. However, my first recommendation is to check out the capabilities of browse. There may be enough power in the browse facility to accomplish what you want with very little work. If not, it gets far more complicated. I have written my own custom browse routine which gives me all sorts of options which the basic browse doesn't provide. I am very happy with my end result, but it was quite tricky. Fox's latest product, FoxPro, has many more browse options and makes sophisticated browse screens very easily with minimal programming. However, I get the sense that you will not be able to wait for FoxPro/Mac to arrive (they haven't even given a potential ship date yet). Good luck. Peter
a_dent@fennel.cc.uwa.oz.au (02/02/91)
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)