O'Reilly logo

Developing Microsoft Dynamics GP Business Applications by Leslie Vail

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Working with ranges

Similar to Dexterity, working with ranges should be on the top of your list of things to master. Establishing a range allows you to work with a subset of data instead of everything in the database's table. When you define a range, the software treats the records in the range as if they were the only records in the database's table.

For example, if your range is set to include only documents dated in 2012, then the GetFirst() method would return the first document dated in 2012. Similarly, the GetLast() method would return the last document dated in 2012. In reality, the table could include documents spanning 20 years, but setting a range would make the other records invisible to your code. Pretty cool!

To set a range, you first ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required