Re: "count" attribute in a table !!!!

In article <3jn01c$720@mydear.csl.sni.be>, Alain.Leroy@csl.sni.be (Alain Leroy) says: > > This is a question for Informix gurus : > >* 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 ? > > TIA for your help. > > > Alain. > >PS : Please do reply directly to me as I'm not often on this news group. > I'll post the anwser back to the group. > Using RESERVED words will usually create these kinds of problems...This would be a great contest: See how many reserved words you can use for column names before your programs blow up... :-) => => => => \\\\|// (o o) ==============================---o00--(_)--00o---============================= Tim Schaefer http://www.gate.net~/tschaefe The Computer Business Co., Inc. tschaefe@gate.net Coconut Creek, FL, USA Ub...eh...Now, see, who gets to ask the questions here? --Ross Perot ==============================================================================