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

(\__/)

(='.'=)

(")_(")

 


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