>After brief additional testing, I arrived at the following provisional conclusion:
>
>The field in the second part of the query is accepted (for UNION compatibility) if either:
>
>a) Both fields are of exactly the same type, size and decimals, or
>
>b) The second field is smaller,
and it is an expression, not a field.
Cool. I'll be able to get my other code to work now. Thanks.
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!
