Jeff Watson [EMAIL PROTECTED]
Tube Methods, Inc.
610-279-7700
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lin
MacDonald
Sent: Tuesday, January 15, 2008 9:29 AM
To: RBASE-L Mailing List
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.
You can use a CheckBox where checked is I and unchecked is E, or a radio
button of the same configuration. or you could use a Variable/DB User
defined List Box. They are all suitable for this...
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?
make a DB Edit (or var depending on what you are using w/ your form)
right click and go to object properties. give it a component id, maybe
DBSELF for example.
you can go to the "on-exit eep" (in the eep tab of the properties
window) and put something in there like this
set var vtmp text = null
getproperty DBSELF TEXTVALUE 'vtmp'
set var vtmp = (icap2(.vtmp))
property DBSELF TEXTVALUE &vtmp
return
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
try using property and getproperty instead to check the values of your
form db and var fields it seems to be the better method for this.
(plenty on "From The Edge" and the HELP files and at Rbase.com, check
the support link and look for the property and getproperty generators.)
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?
use properties to disable it! probably in the on after start eep for the
form.
property thecomponentid_of_your_variable_Edit enabled 'false'
thanks for the help! I really appreciate everyone taking the time to
get me through this!!
Lin
