I was trying to finish most of my 7.1 app using mostly 6.5 thinking.
A few new tricks for the old dog are required.
Thanks,
Dennis
***
At 07:40 AM 5/31/2005, you wrote:
Dennis
The key in 7.1 to this is the GETPROPERTY TEXTVALUE command to pull the
value(s) of the columns on which your expressions are based into a variable,
then the PROPERTY TEXTVALUE command to set the columns you want to default
to the calculated values to preset the columns before entering the field.
Took me a while to catch onto this!
Example from my application:
Automobile claims insurance company.
Four DB Edit fields, located in this tab order:
IncidentInsuredLName
IncidentInsuredFName
IncidentClaimantLName
IncidentClaimantFName
User fills in the insured last and first name.
On ENTRY to the Claimant last name field, this eep runs:
-- FileName: CLUPDT.EEP
-- Created by: D. Blocker
-- Date Created: 12/27/04
-- Purpose: Claimant last name and first name same as insured last and first
-- if last left blank
-- 01/07/05: Correct component name
-- 01/09/05: Put RECALC VARIABLES back in
-- 05/11/05: Fix component name in first GETPROPERTY
-- Changed to run ON ENTRY INTO ClaimantLName on
-- form LossForm2
SET VAR eIL TEXT = NULL
SET VAR eIF TEXT = NULL
SET VAR eCL TEXT = NULL
-- If claimant last name already filled in skip the rest: DON'T CHANGE IT!
GETPROPERTY IncidentClaimantLName TEXTVALUE 'eCL'
If eCL is not null then
GOTO BOTTOM
Endif
-- If claimant last name is NOT filled in, get insured last and first in
variables
GETPROPERTY IncidentInsuredLName TEXTVALUE 'eIL'
GETPROPERTY IncidentInsuredFName TEXTVALUE 'eIF'
-- Hey R:Base, I'm about to update the value in this row: KEY STEP
PROPERTY TABLE Incident 'EDIT'
-- DEFAULT claimant last to insured last, claimant first to insured first
PROPERTY IncidentClaimantLName TEXTVALUE .eIL
PROPERTY IncidentClaimantFName TEXTVALUE .eIF
-- KEY STEP
RECALC VARIABLES
-- NOT needed - I was wrong!
--SAVEROW
LABEL BOTTOM
CLEAR VAR eIL, eIF, eCL
RETURN
David Blocker
[EMAIL PROTECTED]
781-784-1919
Fax: 781-784-1860
Cell: 339-206-0261
----- Original Message -----
From: "Dennis Fleming" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[email protected]>
Sent: Monday, May 30, 2005 10:27 PM
Subject: [RBG7-L] - Updating values in scrolling region
> This is a two part question.
>
> 1. I believe it was Larry who had a thread about clicking on a popup in a
> row. If I click on the popup column it seems to take three clicks. Once to
> select the row (focus), again to select the column, and then a third click
> to bring up the popup. I also think it has to do with any variables which
> need to be resolved.
>
> 2. Which brings me to the second part which is expressions are a problem.
> In each row I have a quantity ordered, received, and back ordered. These
> are (in 6.5) calculated on the fly and can be overridden on the form. It
> looks like I need to do this all with EEPs on each column and then Refresh
> the row after anything is changed (???).
>
> Any help appreciated as the completion of this project and what's left of
> my sanity are in a virtual dead heat.
>
> Dennis
> *****
> Dennis Fleming
> IISCO
> http://www.TheBestCMMS.com
> Phone: 570 775-7593
> Mobile: 570 351-5290
>
>
Dennis Fleming
IISCO
Phone: 570 775-7593
Mobile: 570 351-5290
