Examples of using Pmdatabase object in English and their translations into Czech
{-}
-
Colloquial
-
Official
Database- Examples for the PmDatabase object.
Usage of the PmDatabase object requires purchase of the PmDB license.
Relative or absolute path to PmDatabase object.
The PmDatabase object must be closed before using this method e.g.
It must differentiate from the database defined by the PmDatabase object.
PmDatabase object: database data type BINARY can be used now.
Let's have 3000 rows stored in the PmDatabase object that are changed by the time.
In PmDatabase object it is necessary to configure following items.
The example solves access to the database using the PmDatabase object and the DAO technology.
Maximum time that the PmDatabase object is waiting for the connection to the database on the server.
If the name is longer than 8 characters,then the database cannot be opened with the PmDatabase object.
The example uses the PmDatabase object to display data stored in a database.
If checked, then the SQL statement SELECT is passed without the syntax correction of the PmDatabase object.
PmDatabase object: in ODBC mode for MSSQL the wrong database type of Float was used for"float.
The example shows reading andwriting of particular data range into the Excel application using the PmDatabase object.
The PmDatabase object must be in the open state so that it could provide the data by the FillFromInfo method.
If working with non-existing table(or non-existing database) the PmDatabase object must be closed e.g.
Creates the PmDatabase object This preconfiguration can be activated when creating a new object e.g.
Reading the data into the PmTable object from a database( DataExcel. xls file)using the PmDatabase object.
The method can be called if the PmDatabase object was connected to the database, for example, by calling the Connect method.
The pointer(current position) specifies unambiguously the table record which the methods of the PmDatabase object will work with.
The PmDatabase object enables to perform simple and complex database operations of the type: read/write records, select, sort, etc.
Any changes made by another user(by another PmDatabase object, another application) after the moment of opening are not visible.
If the PmDatabase object writes into the cells of the Excel table(sheet) over which calculations are made or graphs are displayed, then it is suitable to opt Database type configurator to Excel 4.0 in the PmDatabase object by reason of the error in MS support of data type writing for other Excel types.
In this object, it is necessary to set the following configuration items: The PmDatabase object: the application can work with data in this database via ODBC interface registered ODBC data source'pm_data' is necessary.
Another user(another PmDatabase object or other application) can work with the database table after the previous user completes its work.
Let's have the PmiAx graphic item in the panel bound with the PmTable ActiveX object, andthe oDb is the reference to the PmDatabase object whose data from the"Temperature" table(with 10000 rows) have to be displayed by the PmTable ActiveX object. .
The locking means that nobody else(other PmDatabase object, other application) cannot modify the locked part of the table in the locking time.
Changes made by another user(by another PmDatabase object, another application) in existing table rows(at the moment of opening) are not visible.
Static query(snapshot)- The user(the PmDatabase object) can read the table(by the FieldValues property), scroll in both directions by the Move, FindFirst, etc.