|The name of created object||Name of the object created in the application object tree. This is a system name and must not contain diacritics, empty string, spaces and the first character must not be a number.|
|Database connection parameters||Database connection parameters using the DbOpen method in the form of ADO ConnectionString. The ADO ConnectionString (http://www.connectionstrings.com) contains all necessary parameters needed by the ADO Connection object for database connection via the selected ADO Provider. The typical parameters are represented for example by connection provider (provider), server address (server), database name (database), login name and password (uid, pwd), etc. The parameter list and exact syntax is defined by the corresponding ADO Provider, parameters may differ by individual ADO Providers. However for the sake of compatibility most providers ADO Provider understand multiple names of the main parameters simultaneously (e.g. the database name can be represented by database, data source, dbq, etc.). Caution: The syntax of this string is different than other strings used in the PROMOTIC system, the value and the name are separated by =, not by "colon" (:). Entries with assigned value are separated by a semicolon, for example "provider=SQLOLEDB;server=.\SQLEXPRESS;database=pm_data;uid=pm_admin;pwd=pmadmin;". |
This configurator sets the initial value of the property DbConnectionString.
Macro expression can be used for input (it is evaluated while the application is launching).
Additional parameters can be edited manually, or created by the button on the right, that will open the window for Window of recommended settings of the connection string.
The defined parameters may not always be valid (for most common cases), it depends on the selected ADO Provider.
After this preconfiguration is created, the configurator is se to: PmAdo > Main > Database connection parameters.
|Creates the methods of user interface||Create the main and auxilliary methods for working with database table|
|Type of database being connected|
Microsoft SQL Server
|Title or data source description||User title or description of data source (e.g. the title displayed in viewer)|
|Enable - add row||enables the command to add row in the viewer interface|
|Enable - delete row||enables the command to delete row in the viewer interface|
|Enable - edit row||enables the command to edit row in the viewer interface|
|Select the mode of record saving||Sets the mode in the viewer interface, how each record is saved into the database table|
editing disabled - Read only
by each row (default) - Editing by rows with instant writing into the database table
whole content - Editing only in the viewer. SAving the record into the database table will be completed in two steps 1) delete all records 2) create new records
by each cell - Editing by each cell writing into the database table
|Enable - create new table||enables the command to create table in the viewer interface|
|Enable - remove table||enables the command to remove table in the viewer interface|