[RBASE-L] - RE: Why won't this EEP work?

[Michael J. Sinclair]

Yes, the componentid and the field names are the same. Is that ok?

Mike

-------------- Original message from "Jim Belisle" <j...@kaypark.com>: --------------

Mike,

 

Are “shortcut” and “namedose” also the names of the componentIDs or are they just the name of the fields?  My understanding of the GETPROPERTY function is that it is used on ComponentIDs not on the fields themselves.

 

Jim

 

---

From: rbase-l@rbase.com [mailto:rbase-l@rbase.com] On Behalf Of Michael J. Sinclair
Sent: Monday, May 25, 2009 6:44 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Why won't this EEP work?

 

Maybe this will help show what I am doing wrong...

I have a form serving a table called MEDLIST1, with 2 fields total, 2 DBedits within a scrolling region,

The fields/columns are called.... shortcut and namedose, in that order (both are text values).

I have an EXIT EEP on the first field, shortcut...

 

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

 

When I run or trace the form, the values of vshortcut and vnamedose are correct. But the form shows no data...just blank fields.

What am I doing wrong?

Mike

-------------- Original message from "Jim Belisle" <j...@kaypark.com>: --------------

Mike,

 

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

 

jim

 

---

From: rbase-l@rbase.com [mailto:rbase-l@rbase.com] 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" <j...@kaypark.com>: --------------

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: rbase-l@rbase.com [mailto:rbase-l@rbase.com] 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" <mj...@bellsouth.net>: --------------

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