7 Replies Latest reply on Mar 13, 2009 1:34 AM by comment_1

    Programatically omit records

    chowse

      Title

      Programatically omit records

      Post

      Hi,

      Just joined the forum, and this is my first post.

      In a script, I need a way to omit "the rest" of the records.

       

      So far I have:

      Enter Browse Mode

      Show All Records

      Go To Record/Request/Page (First)

      Sort Records (Restore; No Dialog)

      Go To Record/Request/Page (No Dialog; 11)

       

      Now I need to omit all the rest of the records, starting with the current record.

      Can anyone tell me the elegant way to do that? 

       

      [Edit]

      Actually, I think I've solved this.  

      The next step I used is: Show Custom Dialog("Number of records in table:"; Get(TotalRecordCount)

      Then: Omit Multiple Records (Get(TotalRecordCount) - 10)

      That leaves a recordset with only the 10 records I'm looking for!!

      Yeaaa Me!

      Still interested in any comments. 

      [/Edit] 

       

      TIA,

      Charles 

      FM Pro 9 Advanced, Mac OS X