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: [email protected] [mailto:[email protected]] 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" <[email protected]>: -------------- 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: [email protected] [mailto:[email protected]] 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" <[email protected]>: -------------- 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
