Hi Terry,
Change code to:
select space(1) as undump,space(1) as dumpcode,;
_fb2.* from _fb2 where machine=='a' into table _ergdump
Because char ";" tell VFP... command continues on next row.
The char "*" tell VFP IDE, it's comment (VFP IDE Syntax Highlighing is not VFP Compiler)
MartinaJ
>Hi guys
>
>This one is a bit weird. The following line(s):
>
>select space(1) as undump,space(1) as dumpcode,;
> * from _fb2 where machine=='a' into table _ergdump
>
>
>in a prog I'm altering works. But, in editor, the second line shows up in "commented out" colours, as expected. It makes no difference if I move the * to col 1.
>
>Now I'd've thought it either takes the * to mean "all fields in the selected table", in which case the stipulation of the other fields should cause an error, or comment out the 2nd line, which should cause an error in the first line, with continuation ";" but no continuation.
>
>Now I don't know what the original programmer (and I use that expression reservedly) had in mind.
>
>Anyone shed some light on this?
>
>'ppreciate it
>
>Terry