How can I use the "AS" Operator in an SELECT-Statement

[Ruslan Zasukhin]

On 6/3/05 10:22 AM, "Ivan Smahin" <IvanSmahin at public.kherson.ua> wrote:

> Hello SoftIl,
> 
> Friday, June 3, 2005, 9:00:28 AM, you wrote:
> 
> S> Hi Ivan,
> S> thanks for your very fast answer.
> S> But it dosen't work. :-(
> 
> S> I tried it in ViSQL:
> S> SELECT record_id AS 'recIDBetrieb' FROM betriebe   --> retuns 0 records
> S> SELECT record_id  FROM betriebe  --> returns 7 records
> 
> S> If I try it in Valentina Studio, I get the Kernel error 603 return.
> 
> Very strange. I just tried it self and got correct result.
> Anycase I don't see any relation between "AS" and record count in the result.
> Would you be so kind to send me "create table" script or database or something
> else
> for reproducing this problem?

AS work only in 2.0


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