Re: Breaking Long Query into multiple statements ?

Tech-Archive recommends: Fix windows errors by optimizing your registry

Bernard,
Did you use those in the scan as example.
Scan for &var1 &var2 &var3

I tried joining them like
var4 = var1+var2+var3
and then
scan for &var4
Did not work.
TonySper

"Bernhard Sander" <fuchs@xxxxxxxxxxxxxx> wrote in message
news:%23jGg8oPZFHA.3908@xxxxxxxxxxxxxxxxxxxxxxx
Hi Tony

> That does not work. I had to revert back to a IF ENDIF in my scan as
> I
> wanted to scan for 20 fields and the Scan For would not let me put
> together anything that added up to more than 250 characters even
> trying to add two variables would not do it..
In older version of foxpro (FPD 2.5 ;-) ) i also had this kind of
problem. I
could resolve it with more than one macro variable like this:
var1="scan ..."
var2=" for ..."
var3=" .and. ..."
each varN not longer than about 250 characters,
and finally:
&var1.&var2.&var3
(the dots are not necessary, only for better reading)

With newer versions of foxpro this limit may have change, but I didn't
test it.

Regards
Bernhard Sander


.

Relevant Pages

  • Recently Read - August, 2006
    ... Tony Foster finally comes into his own in this better sequel to the OK ... sentimental about her characters. ... a witch-to-be who has to find and murder her doppelganger before she ...
    (rec.arts.sf.written)
  • Re: Magickal Beings
    ... > Tony wrote: ... >> I'm sure Dr. Strange fans can come up with a host of other characters. ... >> After all between Dr. Strange's books and the second Ghost Rider ...
    (rec.arts.comics.marvel.universe)
  • Re: Magickal Beings
    ... Tony wrote: ... > I'm sure Dr. Strange fans can come up with a host of other characters. ... > After all between Dr. Strange's books and the second Ghost Rider ...
    (rec.arts.comics.marvel.universe)
  • Re: Sopranos - definite spoiler (NBC)
    ... that Tony felt betrayed has been built up over and over again. ... It's really all about the characters. ... Jean Smart and Greg Itzin as the ...
    (rec.music.artists.springsteen)
  • Re: Find Error?
    ... when you use VBA - and you are getting what I would expect (although ... Selection contains only four characters but the fourth 'word' is only ... Tony ... Prev by Date: ...
    (microsoft.public.word.vba.general)