Re: Informix - ifx_num_rows

Thanks for all that answered my question. I wanted this function because i use Postgres too in the same project , i will use informix or postgres , so the logic in my implementation was based on postgres functions... But if to Informix it doesn't work ... I will do of another way. Leila Martín marqués <martin@bugs.unl.edu.ar> escreveu nas notícias de mensagem:01082321203802.16708@bugs... > On Jue 23 Ago 2001 21:21, Chris Fry wrote: > > This function does not work reliably with most databases, not just > > Informix. Caused me a lot of problems as I have a number of pages where I'd > > like to display a "No records found message". > > I normally have a count(*) query to know how much records belong to the query > (especially when I use LIMIT and that stuff). > > With Informix, you'll have to use sqlca.sqlerrd[0..5]. One of the elements of > the array is the amount of records. > > > Just have to do it the hard way. > > > > I think there's a disclaimer in the docs about this being unreliable. > > It once was on the informix docs, but not anymore. The source may have > changed. > > > Saludos... :-) > > P.D.: No problems with pg_num_rows() :-) > > -- > Porqué usar una base de datos relacional cualquiera, > si podés usar PostgreSQL? > ----------------------------------------------------------------- > Martín Marqués | mmarques@unl.edu.ar > Programador, Administrador, DBA | Centro de Telematica > Universidad Nacional > del Litoral > -----------------------------------------------------------------