Crash using duplicate field names in Union Sql

[erne]

on 17-09-2007 16:57, Ruslan Zasukhin at sunshine at public.kherson.ua wrote:

> 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.
> 

Thanks for answering!


Cool Runnings,
erne.
-- 
| e r |  Ernesto Giannotta
| n e |  Musical Box - a media store