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:
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 the reason your application could not access the SQL data; namely, there was a column in the Dexterity table definition that did not exist in the physical table:
Your job now is to provide an easy way for your user to create the SQL Tables
and *zdp
procedures required by your application, to grant permissions to those tables, and to bind the default...