Sorry for my miss-information in this posting, I meant to say that I
have had to change some expressions to having parenthesis .. not
quotes... so don't quote me on that... ha,ha
Sorry about that
Jim Limburg
Jim Limburg wrote:
>
> Jim
>
> I'll chime into to say that I agree with Ben. I have had to convert
> some lookups and other expressions to have quotes around them in
> 6.5++ that didn't have to be that way in older version.
> So setting the varlookup = (expression) is a definited consideration
>
> Jim Limburg
>
> Jim Miller wrote:
> >
> > Here is an example.
> >
> > vNew = .vcolumn from table1 where columna = valuea
> >
> > When I use the & I get the error that i cannot start with a binary
> > expression.
> >
> > Thanks for the help.
> >
> > -----Original Message-----
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> > Behalf Of david blocker
> > Sent: Thursday, August 02, 2001 2:27 PM
> > To: [EMAIL PROTECTED]
> > Subject: Re: Form Lookup on column name stored in a var
> >
> > Jim
> >
> > It should work if you do it like this:
> >
> > reportvar1 = columnA in table1 WHERE linkcol = linkcol
> >
> > where linkcol is the linking column name.
> >
> > Now for the second expression, based on looking up columnA in a second table
> > using the variable:
> >
> > reportvar2 = columnB in table2 WHERE columnA = .reportvar1
> >
> > This should work. If this is what you're doing, what error message do you
> > get?
> >
> > David Blocker
> >
> > ----- Original Message -----
> > From: "Jim Miller" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Thursday, August 02, 2001 2:52 PM
> > Subject: Form Lookup on column name stored in a var
> >
> > > I capture a columnname in a variable on a form and then I want to do a
> > > lookup on that column name. When I use a .var for the column name The
> > Latest
> > > and Greatest doesn't like it. Does anyone have any help.
> > >
> > > Thanks
> > >
> > >
