Barcode Label Maker enterprise edition provide data access through the ADO framework. ADO, (Microsoft ActiveX Data Objects) is a set of COM object that access data through an OLE DB provider. It consists of Microsoft ADO 2.1, an OLE DB provider or ODBC driver for the data store access.
Click button 'Database' in Data Table window, you will get a Database Connection dialog.
|
|
|
Here is the guide for make a query from database:
- Connect to database : Click the button 'Database' on Database Connection dialog,
the Windows Data Link Properties dialog box appears. This Windows dialog box displays the OLE DB providers currently on the Windows computer running Barcode Label Maker enterprise edition.
Complete the Data Link Properties dialog box and click OK, if connect successfully, all tables and its fields appear in the treeview box.
- Make SQL command: You can input SQL statement to 'SQL commands' edit box by yourself directly, or generate through program.
Select tables to be used from available tables in treeview box, it will appears
in FROM
clause
when made by program.
Select fields to be used from available fields in treeview box, it will appears in SELECT
clause
when made by program.
The Join, Where, and Sorting tabs work together to automatically generate an SQL statement based on the user's settings.
You need click the 'Make SQL' button to generate statement to 'SQL commands' edit box, and click 'Test SQL' button to preview the query result in Browse preview tab.
- Save query result to data dable:
Click 'OK' to save query result from database to data dable.
|
|
* Note: Only enterprise edition supports connecting to database.
|