Re: Select question

Gokusan wrote: > I would like to have just the first row retrieved from a select statement. > How can i do? (informix se 7.21) Mmm, I don't think you can in SQL using THAT version. That's a bit old. If you are using CURSORs then you can FETCH a single row. If you upgrade to a later version (7.30? 7.31?) you can use: SELECT FIRST 1 * FROM ... Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+ sending to informix-list