>Weird, an analogous query works for me in VFP 7 SP1. Maybe a setting difference?
>
>Here's my test query. With TasTrade open:
>
>SELECT last_name FROM employee ;
>UNION ;
>select SPACE(1) as last_name FROM customer
Hi Tamar,
Oops. That works for me as well. What doesn't work is:
SELECT last_name FROM employee into cursor test1
select SPACE(1) as last_name FROM customer into cursor test2
Select * from test1 ;
UNION ;
select * from test2
Shouldn't this work as well?
Roi
'MCP' Visual FoxPro
In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!