Ben & Jim,
I can vouch for Ben's double dot method within a command file,
works fine under rbw6.5. If a form expression wont allow it, maybe
a simple stored procedure would?
Ben Petersen
On 6 Aug 2001, at 15:11, Ben Johansen wrote:
> Hi Jim,
>
> I was a try, I remember doing it this way, back when! but the ability seams
> to have been lost.
> I remember doing it in 2.11 and trying to deal with its loss when 3 came
> out. Here are a couple other things you could try.
> 1. SMOVE command can move text values from 1 variable to another
> 2. or move the dynamic lookup into an eep (with a very short name so you can
> fit it)
> ie. e.eep usi .vcolumn.
> I know that in an eep you can uses the & without any problem, put it in the
> entry eep side
>
> I remember asking them years ago about this.
>
> Hey maybe we can also push for Autonum with a where clause :)
>
> Ben Johansen
> www.pcforge.com
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Jim Miller
> Sent: Monday, August 06, 2001 7:18 AM
> To: [EMAIL PROTECTED]
> Subject: RE: Form Lookup on column name stored in a var
>
>
> BEN,
>
> Everytime I attempt to begin that variable with an & I get the following
> error. An Expression Cannot begin with binary operator (2150).
>
> I have written the variable structure as you have described but I still get
> the same error.
>
> Any other suggestions?
>
> Jim
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Ben Johansen
> Sent: Thursday, August 02, 2001 4:07 PM
> To: [EMAIL PROTECTED]
> Subject: RE: Form Lookup on column name stored in a var
>
>
> Try this (Keep Expression order)
>
> vDblDot text = ".vcolumn"
> vNew = &vDblDot from table1 where columna = valuea
>
> Ben Johnasen
> www.pcforge.com
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Jim Miller
> Sent: Thursday, August 02, 2001 1:36 PM
> To: [EMAIL PROTECTED]
> Subject: RE: Form Lookup on column name stored in a var
>
>
> 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
> >
> >
>
>
>
>
