I was thinking more basic/fundamental. Filters support "TR." field name
prefixes for specifically this purpose. It's the transaction value (vs.
DB. or database value). If TR. value is not null, it's been changed (i.e.
different from the database value).
In your example, your Run If would include 'TR.FieldA != $NULL$
Mike White
Office: 813-978-2192
E-mail: [EMAIL PROTECTED]
"Kelly Deaver"
<[EMAIL PROTECTED] To: [email protected]
VER.COM> cc:
Sent by: "Action Subject: Re: How to verify if
the current value entering exists on the
Request System database
discussion
list(ARSList)"
<[EMAIL PROTECTED]
ORG>
08/27/2006 16:43
Please respond to
arslist
**
There are several ways, depending on what you are trying to accomplish. I'm
going to call the field you are interested in FieldA in my examples.
1. If you are trying to assure that no two records have the same value in a
particular field (FieldA), create a unique index for that field. In the
Admin tool, open the form and select form>form properties. On the Index
tab, move the desired field to the right column and check the "unique" box
below. Save. When the user submits a new record, it will say that entry
violates a unique ID on FieldA.
2. Add a field, FieldB, to number field to check the result of an active
link you are going to create.Create an active link that runs on loose
focus, run if - FieldA != Null. Select a set field of the field action.
Query the form name of the same form (not CURRENT SCREEN) where $FieldA$ =
'FieldA'. Set the no match = set the field to null. Set multiple match =
Use first matching request. Set Field - FieldB = $LASTCOUNT$. This will
tell you how many already submitted records match the current value in
FieldA. You can then create an error message if FieldB not NULL that tells
the user in more detail what you want them to change.
3. Do the same thing with a filter to check on submit and block the submit
action if you like.
4. If you aren't trying to block, but rather find matches, you can do the
same as #2 except instead of setting multiple match to Display a List.
---------------------
Kelly Deaver
Director, ITSM Practice
Xinify
[EMAIL PROTECTED]
-------- Original Message --------
Subject: How to verify if the current value entering exists on the
database
From: Addis Solomon <[EMAIL PROTECTED]>
Date: Sun, August 27, 2006 12:27 pm
To: [email protected]
**
Can anybody help me how can I check if the current value entering already
exists on the database?
Thanks in advance for your help
All-new Yahoo! Mail - Fire up a more powerful email and get things done
faster. __20060125_______________________This posting was submitted with
HTML in it___
__20060125_______________________This posting was submitted with HTML in
it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
