Crash using duplicate field names in Union Sql

[Ruslan Zasukhin]

On 17/9/07 2:41 PM, "Erne" <ernestogiannotta at tiscalinet.it> wrote:

Hi Erne,

> it is claimed to be fixed in version 3.3 and indeed it doesn't crash
> anymore but throws this error:
> Kernel error: 0x80501. Field name "RecID" is not unique.
> 
> still I don't see why the use of a field alias is required here
> 
> ok, the output cursor would have duplicate field names but why is it
> allowed for non UNION queries?

Technical glitch :-)

I remember that Ivan have test MS SQL and something else on the same issue,
They have the same inconsistency. Sometimes allow, sometimes not.

Depends what tmp/join tables are used during query resolving.




-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]