recordcount and TppDataPipeline

rbuser

I'm writing a EndUser application using extended RAP and queries
designed by user with DADE.I'm currently adding functions to make some
special calculations and treatments when called by RAP event. I'd like
to know if it's possible to get a recordcount from a TppDataPipeline
object. I noticed the property exists but it's private and i dont want
to make my own count if it can fire RecordPositionChange events.I've
coded a bad solution (i get SQLtext and open it with a basic ADOQuery
just to get recordcount).

Anyone got a better solution?
Frederic

digitalmetaphors

We did not publish the record count because we did not want your end users
to call it in RAP and complain that their reports run slow after adding this
call. Getting the record count depends on dataset activites which are going
to be slow, developers already know this, but your end users don't. If you
want to show record count in RAP, you have to code a RAP pass through
function to access the dataview's SQL object's query(as you say you have
already done).

Usually, the reason for wanting to know the record count is to simply know
if EOF is true or ppdaNoRecords in DataPipeline.State. We provide these
other properties on the pipeline so that you can determine if you are at the
beginning or end of the pipeline, or have no records. Sounds as if you need
the record count to do your custom calculations, though. The RAP pass
through is the way to go on this.

Cheers,

Jim Bennett
Digital Metaphors