>>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
>
>Funtime:)
>
>select "X" as dummy,maxordamt ;
> ** 2 as matSquared,;
> * from customer
>
Works! :-)
>Other programmer knew what he was doing but not bothered with syntax coloring which doesn't work right always.
Well, in FPD26, as I said, he didn't have syntax colouring so I can sort of forgive him, but leaving the * at the start of the 2nd line is confusing.
>PS: Second time as I remember I defend that guy:)
You've defended other gripes of mine about him?
>Cetin
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.