Article Databases

Navigation:  »No topics above this level«

Article Databases

Previous pageReturn to chapter overviewNext page

The selling conditions of all the articles in a manufacturer's range of products are usually gathered in a database.

Therefore the minutes are closely related to databases.

QDV7 handles the formats .qdb and, for relational databases, sqlqdb.

An SQL Server, Oracle or IBM Informix relational database is hosted by a server; the client built in QDV7 place requests in the SQL language. For SQLite, refer to Migrating from SQLite databases to SQL Server.

 

A virtual database (provisional) refers to several physical databases. This allows to gather the most used articles in one database. As the articles in the virtual database are dynamically linked to the original ones, it requires no maintenance of its own.

There is another use. Say you share with various users databases include prices and times. If you want to use your own times, create a private virtual database with your own times without references, while the other attributes are taken from physical databases.

 

 

 


Topic content

 

How to Open a Database

How to Create & Manage the Databases

How to Deploy a Relational Database

How to Access a QDV Database with SQL Server

How to Edit a Rebate Database

Articles Viewer Description

Prefixes

How to Create/Edit Articles

Database Modes

Edit Mode

 

 

More on this Database of the Estimate

More on this Contextual Databases