Principle

Navigation:  Interfacing QDV > Contextual Databases >

Principle

Previous pageReturn to chapter overviewNext page

Here is an example of data hosted in QDV7 databases. Prices / Rebates are considered generic. They don't take the context into account.

 

Description

Reference

Family

Unit

Cost per unit

Currency

Kind ID

Rebate

Interpact Ins80 Yellow

01109

0d

u

85,07

EUR

LVSWITCH

62,00

Command Std Black Ns80

01225

0d

u

53,96

EUR

LVSWITCH

62,00

Circuit Breaker C60n Tri 1 A

03204

0b

u

83,93

EUR

LVSWITCH

62,00

C60n Bi 1 A C

03220

0b2042

u

51,84

EUR

LVSWITCH

62,00

Distribloc 125 A

03243

0q

u

48,05

EUR

LVSWITCH

62,00

Dpn Vigi Uni + N 10 A 30 Ma

03401

0b3022

u

117,79

EUR

LVSWITCH

62,00

 

The context is represented by the global variables of the estimate:

 

GlvVarsContext

 

The Custom_Articles function reads a contextual database and return to the article passed to the function a contextual Cost per unit, a Rebate and a Currency according to values of global variables GLV_Business and GLV_Country.

 

For this purpose the program has a function which is called by QDV7. This function passes data from the calling-database-row and estimate context which are global-variables and their values.

From within the function, you can write to any field of the image of the database row.

The function is called each time the database is involved. Whether you want to insert an article from it to an estimate or to update an article from it being already used in an estimate. This means you can change context variables and update your estimate so that data match the new context.