Preconfiguration "Postgre SQL - connecting to the database by the PmaAdo object and table usage."
connecting to the database by the
PmaAdo object and table usage..
This preconfiguration can be activated when creating a new object (e.g. by
"New object ..." in the local object menu or by pressing the
Insert key after selecting the object) and is included in the group:
"/ Database access / Postgre SQL".
This preconfiguration can be created in the object:
PmaFolder or
PmaRoot.
The
PmaAdo object is created including the configured interface for selected database type. The connection string is also preconfigured in the
DbConnectionString property in order to allow connection to selected database. This will need to be modified in some cases to meet the requirements for connecting to the database on the target computer..
The panel is preconfigured in order to allow creation of testing table (
datatest) with primary key in the
cindex column. The SQL statement for table creation is included in the
PmgString object in field
DbExecute and is activated by the "
Run the SQL statement" button. The
INSERT INTO button can be used for adding new record into the database table. The values of new record are generated randomly (in the
Values field) by the button with "arrow in a circle" symbol. The buttons
UPDATE and
DELETE can modify the record or delete it. The button with "arrow in a circle" symbol in this case displays the value that is in the marked row of the table in
cindex column. There is an info system in the bottom of the panel that indicates the result of performed operations..
These configurators can be set before the preconfiguration is created:
| The name of created object | Name of the object created in the tree of Pma objects. The maximum name length is 30 characters. This is a system name, so it must contain only alphanumeric and must not contain any diacritics (i.e. national dependent chars), empty string, spaces and the first character must not be a number.
Default: "DbPostgreSQL" |
|---|
|
| Database connection string | When working with file databases, it is necessary to modify the path to the file or data files folder (dBase) in the created connection string. |
|---|
|
| Object scripting language | Application object scripting language
0 - vbscript
1 - javascript |
|---|
| Enable as Web component | Specifies whether this object has to be registered as a Web server component
After the preconfiguration is created, the "PmaPanel > Web server > Enable as Web component" configurator will be set to this value. |
|---|
| PmaWeb object | Path in the tree of Pma objects to the object PmaWeb, PmaWebFolder or PmaWebLang where the registration is carried out.
Macro expression can be used for input (it is evaluated after starting the application).
After the preconfiguration is created, the "PmaPanel > Web server > PmaWeb object" configurator will be set to this value. |
|---|
| DbType | DbType |
|---|