After your PROPERTY TABLE refresh, do:

 

RECALC VARIABLES

 

Emmitt Dove

Manager, Converting Applications Development

Evergreen Packaging, Inc.

[email protected]

(203) 214-5683 m

(203) 643-8022 o

(203) 643-8086 f

[email protected]

 

From: [email protected] [mailto:[email protected]] On Behalf Of Michael J. 
Sinclair
Sent: Monday, May 25, 2009 7:49 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Help with EEPs in Rbase 7.6

 

Hi Jim,

I do need to edit the lookup fields, so I do need to use the EEPs. This Exit 
EEP is not working...

 

GETPROPERTY shortcut textvalue 'vshortcut'
SET V vnamedose = namedose IN scripts WHERE shortcut = .vshortcut
PROPERTY namedose textvalue .vnamedose
PROPERTY TABLE medlist1 'REFRESH'
RETURN

 

Do I have the syntax wrong? Or am I missing the big picture. 

Mike

-------------- Original message from "Jim Belisle" <[email protected]>: 
-------------- 

Michael,

 

I have converted many forms that had lookup variables and they transferred over 
properly.  If you do not want to edit the lookups, you should be able to set up 
your variables just like 6.5.  For instance I had this var. in 6.5:

 

EMPNAME = EMPNAME IN EMPLOYEE WHERE EMPID = EMPID. In this case, the var had 
the same name as the DBedit field .  When I entered the info. into the EMPID 
field, the lookup entered the information into the EMPNAME field. You can set 
up as many fields in the same manner. 

 

If you want to edit the lookups you will have to use an EEP with the 
GETPROPERTY functiuon I was mentioning in earlier emails.I had this problem 
with some of my forms.

 

I would just create your lookup variables in the Variables | Add / EdIt 
Variables menu.  Once they are setup there, you can set up your DBEDIT fields. 

 

I hope this helps some.  

 

Jim

 

 

 

  _____  

From: [email protected] [mailto:[email protected]] On Behalf Of mjsmd
Sent: Monday, May 25, 2009 6:08 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Help with EEPs in Rbase 7.6

 

I want to use it on a table. Basically I am trying to recreate the effect of 
look ups in ver 6.5. 

Michael Sinclair, MD

www.epilution.com <http://www.epilution.com/> 

(\__/)

(='.'=)

(")_(")

 


On May 25, 2009, at 6:24 PM, "Jim Belisle" <[email protected]> wrote:

Mike,

 

Are you basing your form on a table or temporary table? 

 

jim

 

  _____  

From: [email protected] [mailto:[email protected]] On Behalf Of Michael J. 
Sinclair
Sent: Monday, May 25, 2009 5:22 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Help with EEPs in Rbase 7.6

 

How do I get the data from the variable to update just 1 row in the table?

Likewise, if I delete a row in the scrolling region, how do delete the 
corresponding row in the table?

Mike

-------------- Original message from "Jim Belisle" <[email protected]>: 
-------------- 




Mike,

 

You can have variable edit objects in a scrolling region.  I have many forms 
with scrolling regions where there is an EEP in a particular field.  It only 
grabs the information related to that row. 

 

Jim

 

  _____  

From: [email protected] [mailto:[email protected]] On Behalf Of Michael J. 
Sinclair
Sent: Monday, May 25, 2009 4:03 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Help with EEPs in Rbase 7.6

 

One more thing...I would like to have a scrolling region with multiple lines, 1 
line for each perscription. Does the EEP work on just the line I am currently 
on like the old lookups? Can I use Variable edit objects in a scrolling region?

Mike

-------------- Original message from "Michael J. Sinclair, MD" 
<[email protected]>: -------------- 



Hi all,

I now realize that lookups in forms that worked well in version 6.5 have to be 
replaced with EEPS in version 7.6. This will probably give me much more 
flexibility in my forms, but I am having trouble getting started. I have a few 
questions that might help me....

Do I use DBedits objects for Variable edit objects?

Should the EEP be triggered from the field that was given the data or triggered 
by an ENTER on the first field that is going to get the lookup data?

 

In my application, I want the user to be able to populate fields for a 
perscription based on a common abbreviation for that perscription. I have a 
table with look up data called  SCRIPTS. The columns are called shortcut, 
drugname, dose, frequency, refills, comments.  My form is allowing the user to 
enter data into a table called SCRIPTS1. The columns are all the same, with a 
few extra columns that are patient specific (patnumbr, rdate_), ie patient 
number and today's date. 

 

Is there a sample that I can look at? Or can somebody give me a little guidance 
on how to start?

Mike 

Reply via email to