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

(\__/)

(='.'=)

(")_(")

 


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