RE: Why is this an SQL syntax error?

_______________________________________________________________ This message and any attachments are intended for the individual or entity named above. If you are not the intended recipient, please do not read, copy, use or disclose this communication to others; also please notify the sender by replying to this message, and then delete it from your system. Thank you. _______________________________________________________________ Well, yeah, it would be useless, but he didn't ask that, did he? William Rice <ricew@operamail.com> on 05/03/2000 07:44:53 AM Extension: To: "Colleen M. Morrow" <Colleen_M._Morrow@jonesday.com>, strangiato <strangiato@my-deja.com> cc: informix-list <informix-list@iiug.org> (bcc: Colleen M. Morrow/JonesDay) Subject: RE: Why is this an SQL syntax error? Grouping by rowid would be pretty useless anyway, it should always be unique Will >===== Original Message From "Colleen M. Morrow" > >It would appear that you can't group by rowid. Could this be because >rowid's do not exist by default in fragmented tables? Anybody? I couldn't >find it documented anywhere. > > > > > >strangiato@my-deja.com on 05/02/2000 01:39:11 PM >Extension: > >To: informix-list@iiug.org >cc: (bcc: Colleen M. Morrow/JonesDay) >Subject: Re: Why is this an SQL syntax error? > > > > >It's a column name. I suspect there is a problem with the rowid?? > >In article <390F01AD.30A7E5DD@bellsouth.net>, > "Carlson@WHSmith" <carlson1@bellsouth.net> wrote: >> strangiato@my-deja.com wrote: >> > >> > Informix 7.x >> > >> > select p_name,rowid,max(finish_dt) from p_status where id=10 group>by >> > 1,2 >> > >> > gives rise to a syntax error >> > >> > why? >> > >> > Sent via Deja.com http://www.deja.com/ >> > Before you buy. >> >> Is p_name a column name or a program variable ?? >> >> -- >> John Carlson >> Informix DBA >> WHSmith USA >> >> #include std_disclaimer.h /* These are my opinions, not my >company's >> opinion */ >> > > >Sent via Deja.com http://www.deja.com/ >Before you buy. ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, as a free service from Opera Software, makers of the award-winning Web Browser, Opera. Visit us at http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail account is waiting at: http://www.operamail.com/ ------------------------------------------------------------