Assistance needed on query

[Bart Pietercil]

Hi John,


the '' as 'aliasname' part is most certainly not the problem, I use  
it in many other places in my program AND I get the same error when I  
do not use the expression in the select.
SO the problem lies in another part or the query


Thanks for joining in though

Bart

On 14-mei-07, at 19:59, Sims, John (CDC/CCHP/NCBDDD) (CTR) wrote:

>
> Hi Ruslan,
>
>>
>> But you describe in fact this case:
>>>>     SELECT expr as 'alias'
>>
>> NOT
>>>>     select '' as 'alias'
>>
>> First case works in Valentina also I believe.
>>
>>
>> --
>> Best regards,
>>
>> Ruslan Zasukhin
>> VP Engineering and New Technology
>> Paradigma Software, Inc
>>
>> Valentina - Joining Worlds of Information http:// 
>> www.paradigmasoft.com
>>
>
> Do you know if it would have work for him if he had used:
>
> SELECT ' ' as 'alias' FROM myTable
>
> Making sure he put a space between the quotes?  Or, is it possible to
> use
>
> SELECT NULL as 'alias' FROM myTable
>
> Just trying to see what is possible.
>
> Thanks!
>
> -John
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina