SOLVED : "count" attribute in a table !!!!
Posted in 1995
Alain Leroy — — source: Informix-list mailing list archive (1991-1998)
Remeber, yesterday I posted this message :
>* Try this :
>
> Create table tabname
> ( count integer,
> other integer );>
> It'll work on Informix 5.0C on-line
> It won't work on Informix 4.0B on-line
>
>* The question is : Given that I can crete the table with a "count"
> attribute, I must be able to retrieve it (unless it's a bug in 5.0C).
> HOW ????
>
> OK, don't tell me "select count from tabname". It'll generate
>a syntax error. What else ?
>
The solution is :
"select A.count from tabname A"
Thanks to the aliasing technique
AND TO ______ Christian <HEIKERheiker@quietsch.ping.de> _____
Alain.