Here are some untested suggestions:
1. A Checkbox with checked value = 'I' and unchecked = 'E'
2. On Exit EEP of the field, place some code like:
getpropery <CompID> textvalue 'vText'
set var vText = (luc(.vText))
property <CompID> textvalue .vText
3. I would consider placing it into the On Exit EEP of Supplier.
in the variable expressions: vSupplier = (Supplier)
If vSupplier is null then
set var vMessage = ((cval('NetUser')) + ', fill in the supplier!')
pause 2 using .vMessage
property SupplierCompID set_focus 'true'
endif
4. Uncheck TabStop in the properties tab of the Variable Edit.
________________________________
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lin MacDonald
Posted At: Tuesday, January 15, 2008 8:29 AM
Posted To: RB7-L
Conversation: [RBASE-L] - simple Form questions
Subject: [RBASE-L] - simple Form questions
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.
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?
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??
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?
thanks for the help! I really appreciate everyone taking the time to get me
through this!!
Lin
