AnsweredAssumed Answered

Programatically omit records

Question asked by chowse on Mar 12, 2009
Latest reply on Mar 13, 2009 by comment_1

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 

Outcomes