[comp.databases] DBASE4 user interface programming problem

bernhard@ai-vie.UUCP (Bernhard Pfahringer) (07/28/89)

Hi, you DBASE4 gurus out there, 
I need good advice on the following problem:

Some fields of a table may only contain values from a given selection.  So
when entering records, the user should be able to choose the appropriate value
for the current field by means of a popup-menu.
 
Partial (and awkward !!!) solution:

I define e.g. function key F2 to be active during input: if the user wants to
get a popup-menu to choose from, s/he just hits F2.
Via some macro-fiddling (defining a macro at runtime to return the appropriate
result and using PLAY MACRO) I can even splice the result into the input.

One problem remains: how does the function know, which FIELD of the table was
under consideration ????

My current - horribly kludgy - workaround is storing X/Y coordinates of the
FIELDS on screen in an extra table. Using ROW() and COL() the procedure can
determine where the cursor was, and then look up in the table which field is
*supposed* to be there.
But, if screen layout changes, ...

I bet there better ways to get what I want.
Any ideas and suggestions are warmly welcome.
Constraint: no other language should be used, just DBASE4.
BTW: I have to use DBASE4 on this project,
     so better redirect flames to /dev/null

Thank you so much
Bernhard

Please email to:
bernhard@ai-vie.uucp                (...mcvax!tuvie!ai-vie!bernhard)
                        (from bitnet:  bernhard%ai-vie.uucp@cernvax)
            (from outside europe: bernhard%ai-vie.uucp@uunet.uu.net)