Lin MacDonald wrote:
I think these are all simple questions, but they just seem to be
eluding me! Can't get my head around how to do them in this version
versus how I did it 15 years ago in v. 4.5!!
1) What is the best control for a choice that only has two
possibilities? Like a "Yes, No" but in this instance, the choices are
"I" or "E". I'm using a DB User Defined ListBox, but it seems clumsy
for this purpose.
I use a checkbox. Check it for "I", leave it unchecked for "E" or vice
versa. You can even put another field right next to the checkbox that is
a variable and define the variable as the full description of the I or E.
2) Text Data integrity. If I want to capitalize what the User enters,
and then show it in the same place after I move on to the next field,
how would I do it?
I would use a format mask.
3) Verifying Data Entry. I'm developing a form that is very similar
to the SalesOrder form in RRBYW14. Once the User chooses a Supplier,
the address on record appears. (Not changeable). Then, they enter
the Description of the item being purchased (only 1 item per form, as
opposed to the RRBYW14 example). Once they enter the field to input
the description, I want to check that they haven't left the Supplier
field blank, and if they have, send them back to it. I added an EEP
on Entry into the Description field, but nothing seems to happen.
Here's what I put in:
IF vref# IS NULL THEN
PAUSE 2 USING 'You MUST Select a Supplier!' CAPTION ' New
Transaction' ICON stop
SKIP TO ref#
RETURN
ENDIF
SELECT company INTO vpurchfromcompany INDICATOR ivpurchfromcompany
FROM contacts WHERE ref# = .vref#
RECALC VARIABLES
RETURN
So, is my code wrong (highly possible!),or is it in the wrong spot, or
both, or??
The code should be on exit from the field you are verifying. You can
then use
IF vref# IS NULL THEN
PAUSE 2 USING 'You MUST Select a Supplier!' CAPTION ' New
Transaction' ICON stop
SKIP 0 -- that's a zero
RETURN
ENDIF
SELECT company INTO vpurchfromcompany INDICATOR ivpurchfromcompany FROM
contacts WHERE ref# = .vref#
RECALC VARIABLES
RETURN
4) On the same example above, I have the address appear as information
only -- I don't want the user to be able to change it here. I am
using a Variable Edit control, only because I could make it match the
rest of the fields visually. I know how to make it so that the User
can't change the field, but what if I don't want the cursor or the Tab
to take you into it? Is that possible, or should I change controls?
I also use variable fields, but change the colour to yellow to show the
user it is not editable, and then in the field properties, I check [Read
Only] and uncheck [Tab Stop] and [Autoselect]
thanks for the help! I really appreciate everyone taking the time to
get me through this!!
Lin
