Alpha Video Training
Results 1 to 2 of 2

Thread: Example how to show current record count ie (1 of 3)

  1. #1
    "Certified" Alphaholic Tim Kiebert's Avatar
    Real Name
    Tim Kiebert
    Join Date
    Jul 2004
    Location
    Geelong, Victoria, Australia
    Posts
    2,785

    Default Example how to show current record count ie (1 of 3)

    In response to this forum question attached is a sample showing one way to show the current record number out of the current record set.

    24-04-2012 3-40-38 PM.png
    Attached Files Attached Files
    Tim Kiebert
    Eagle Creek Citrus
    A complex system that does not work is invariably found to have evolved from a simpler system that worked just fine.

  2. #2
    "Certified" Alphaholic Tim Kiebert's Avatar
    Real Name
    Tim Kiebert
    Join Date
    Jul 2004
    Location
    Geelong, Victoria, Australia
    Posts
    2,785

    Default Re: Example how to show current record count ie (1 of 3)

    In response to a concern about using the count() function which carries a warning about only being supported for reports, here is an alternative.

    COMPUTE_FIELD_STATISTICS()
    Which in this case would be used as str(compute_field_statistics("Product_Id").count)
    Tim Kiebert
    Eagle Creek Citrus
    A complex system that does not work is invariably found to have evolved from a simpler system that worked just fine.

Similar Threads

  1. Show actual record count , override the "FIRST" Clause in sql
    By Ken Tjia in forum Application Server Version 10 - Web/Browser Applications
    Replies: 1
    Last Post: 02-22-2011, 08:24 PM
  2. record count - delete button adjusting count
    By dik_coleman in forum Alpha Five Version 7
    Replies: 3
    Last Post: 12-23-2005, 12:06 PM
  3. Show Current Users
    By Charles Hoens in forum Alpha Five Version 5
    Replies: 10
    Last Post: 12-03-2004, 03:28 PM
  4. Print Current record doesn't show Tabs?
    By Tom Mills in forum Alpha Five Version 6
    Replies: 6
    Last Post: 08-13-2004, 06:32 AM
  5. Count of records processed during current session
    By Annita Merriweather in forum Upgrading to Alpha Five from Alpha Four
    Replies: 6
    Last Post: 01-06-2004, 04:37 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •