Problem with example application and temporary workaround

[vadimtsushko]

I'm currently looking at sample applications in QDF. One of them - NorthWindExampleMart.qvw - breaks on load with error

Ошибка в строке скрипта:
for vL.tttt = 0 to vL.xxxx-1 

Oшибка в строке скрипта: stands for something like Error in script line:

Firstly I've checked that I generated QVDS by QVD-Generator-Example.qvw and loaded successfully Example_NorthWind_Mart.qvw datamart. Then I tried to debug this error, unsuccessfully.

Finally I've noticed some irregularity in NorthWind_Mart.qvw on table view:

All tables have names corresponding to they source QVD file names, but instead of Customer table we have vL.temp_table.

I've added

RENAME TABLE vL.temp_table TO Customer 

at the end of Example_NorthWind_Mart.gvw script and after that NorthWindExampleMart.qvw application loads successfully for me.

If somebody stumbled upon same error, that may be quick workaround.

Best regards, Vadim Tsushko

[Magnus_Berg]

Thanks Vadim, I will add the change to the example.

Best regards

Magnus

[Magnus_Berg]

Hi Vadim, In the new QDF 1.3.2 version there is a new function called QVDLoad.
This function will load in muliple qvd files (in multiple folders) and create data-model based on qvd header meta-data.

In the Northwind Mart case you only need these lines instead of Load *

$(Include=$(vG.SubPath)\10.QVDLoad.qvs);

call QVDLoad('$(vG.QVDPath)');

Read more in the updated development guide.

Best regards

Magnus

[vadimtsushko]

Great solution, Magnus.

I will definitely use it.

[bartsa]

Replying to an old thread, but hopefully someone dealing with the same issue finds the solution.

The problem for us was that the tables are not given a name during the load. This creates the vL.temp_table in some point of the reload while QDF is active.  So a solution for us was to give the table name in a variable for each table in loop.