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

Table operations

As with any database program, you need to get down to the basic table operations before you do anything fancy. Now is the time for you to put some code behind those buttons and see your window in action.

Knowing the basic table operations is the first thing you need to learn using any database programming. Learning table operations is often referred to as "knowing your CRUD." Let's do it. This is what CRUD means:

  • Creating a record
  • Retrieving a record
  • Updating a record
  • Deleting a record

Creating a record

You're going to attach your code to the Click event of the Save button. When you click on the Save button, you will add a record to the PM Vendor Master table. Open the code window by double-clicking on the Save button. Add the following ...

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