This may be the ticket but seems quirky. Flashes various data within fields (as if looking) then errors with 'Invalid text value'. The lookup value and column are both text. Curious if it's actually scanning each row or using the index...
________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, February 13, 2007 5:27 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: one more item I have recently been using the following PROPERTY command that is great for what you are looking for: (Taken from the PROPERTY command syntax builder) Requires 7.5 or higher though. I did not see the original post, so I am not sure what you are using. -Bob Syntax: PROPERTY TABLE 'FormTableName->SEARCH->FormColumnName->' varname Notice the database QUOTE character surrounding the 'FormTableName->SEARCH->FormColumnName->'. SET VAR vSearchString TEXT = NULL SET VAR vSearchString = + ('PROPERTY TABLE Customer SEARCH->'+.vColumnName+'->'+.vSearchValue) &vSearchString RETURN -- Thompson Technology Consultants LaPorte, IN 46350 219-363-7441 -------------- Original message -------------- From: Emmitt Dove <[EMAIL PROTECTED]> > > I neglected to mention this requires 7.1 or better ... and, you can > copy your existing form, changing the table upon which it is based in > the process, so no need to rebuild the form if you use the same > column names in the view. > > > >One way is this: > > > >1) build a view on your table containing the values you want to > >display plus your part number column > >2) base the form on the view > >3) handle the part number selection however you'd like > >4) in an eep after part number selection, do this: > > > > PROPERTY TABLE viewname 'CLOSE' > > -- drop your view > > -- recreate your view with a WHERE clause limiting it to yo ur part number > > PROPERTY TABLE viewname 'OPEN' > > RECALC VARIABLES > > RETURN > > > >>Ok, I've got a form associated with a table. DB Labels show table data > >>all over the form. Want to capture a value (a part number) from the > >>user with a Variable Edit control then have the form display all the > >>associated data for that part number. I need to display with DB Labels > >>so I can locate the data specifically. No matter what I try, I can't > >>get the form refreshed without leaving the form. What am I missing? > >> > >>Should be simple... > > > >Emmitt Dove > >Manager, DairyPak Business Systems > >Blue Ridge Paper Products, Inc. > >37 Sybil Ave > >Branford, CT 06405 > >(203) 643-8022 > >[EMAIL PROTECTED] > >[EMAIL PROTECTED] net > > Emmitt Dove > Manager, DairyPak Business Systems > Blue Ridge Paper Products, Inc. > 37 Sybil Ave > Branford, CT 06405 > (203) 643-8022 > [EMAIL PROTECTED] > [EMAIL PROTECTED] >
