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 creation routines

The tables used by your application are not automatically created. Back in the Pervasive PSQL 2000 and FairCom ctree Plus days, the table was created automatically the first time you accessed it. SQL doesn't work that way. If you try to use the application without creating your tables, you will get an error message similar to the one shown in the following screenshot. The message will not be displayed until the system tries to access one of your tables:

Table creation routines

Likewise, if the table exists but its structure does not match the table definition in your application, you will receive the following error:

The More Info button provides ...

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