Limiting # rows returned by SQL query - during te

Posted in 1995

Billy Wheeler — 25 Apr 95 13:01:00 GMT — source: Informix-list mailing list archive (1991-1998)

-> In INFORMIX, I've always used 'where table.rowid < NNN'. Yeah, it's just that in OnLine, rowid doesn't start at 1... I usually just have a counter in my loops and bomb out when I get to NNN. Graceful, just like me .... billy.wheeler@digitec.co.za ---- Digitec Online - South Africa Telnet: bbs.digitec.co.za