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

[Michael J. Sinclair]

Jim,

For what it's worth, I added a saverow before the property command it "worked" sort of.....it was causing and immediate flipping of the order of the rows, but atleast it was saving data. I guess the property command was taking a value that did not exist yet without the saverow command, so it was placing null values in the table. 

 

Now that I am over this hurdle....maybe I can get some work done!

THANKS A MILLION!!!!!

Mike

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

Mike,

 

The only reason I could help was because someone helped me with the same problem a few months back.  I think it worked because the added code was not needed to properly enter the information so it interfered with the good code. 

The rows are added as you mentioned below.  To the bottom when in the ENTER mode and to the top in the EDIT mode.  When you bring the same information up (after getting out) the new information will be in the proper order.

 

Jim

 

There may have been a thread about making the information add a new row to the bottom in the EDIT mode, but I can’t find it at the moment.

---

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

 

OMG IT WORKED!!! YOU ARE A GENIUS!

Now can somebody tell me why it worked??????????

Also, I notice that when I use ENTER USING formname, the new lines are added at the bottom.

When I use EDIT USING formname, the newlines get added at the top. Do you see the same behavior?

Mike

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

Mike,

 

I am just guessing but try it without the last two lines.  Just comment them out like this:

 

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

 

I do not have those two lines in my code and my lookup works just fine. I am new to the GETPROPERTY command myself.

 

Jim

 

---

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

 

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