Home End User
New Blog Posts: Merging Reports - Part 1 and Part 2

recordcount and TppDataPipeline

edited December 2002 in End User
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

Comments

  • edited December 2002
    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

This discussion has been closed.