Why are my reload fetch results different when my edit script tabs are ordered different?

[#1]

Hello for the first time..... I've been busy building my first QV application over the last month and i've hit a problem.... I get different reload fetch results when the edit script tabs are ordered differently.... Look at RawMaterials and Budget in the images below...

Any ideas out there in QV land as to what could be causing my headache?

THanks in advance,

Bernard

[vgutkovsky]

This is really an open-ended question. It depends on any "where" clauses you have in your load script, as well as what you're fetching from--meaning, if you're going after an Excel file then the result should be the same, but if you're fetching from a resident table, that table might not be fully populated yet.

Regards,

[Miguel_Angel_Baeyens]

Hello Bernard,

My guess is that there is some WHERE EXISTS() clause in your script that is affecting to your results.

Is that possible?

[#4]

Cheers guys for the quick reponse.... I have no 'wheres' in my script whatsoever.... I'm accessing a progress database with an odbc driver...

[vgutkovsky]

So each table load goes after the DB? None of them are going after resident tables?? That's really bizarre, there shouldn't be any difference. The only thing I can think of is maybe your DB has actually changed between the times you ran the script first and second. Try it again with the original tab order.

[#6]

The database i'm connecting to isn't the 'live' production DB, it's updated every 4 hours and it remained the same during the time i was adjusting the QV script.... Really scratching my head now....

[rwunderlich]

Can you post the script portion that loads the RawMaterials table?

[#8]

Hi Rob,

i'm convinced it's something to do with my Budget table load... If i comment it out RawMaterials load as expected... So here are the load statements for both tables....

Budget:
LOAD Year & '_' & Month & '_' & CustomerNumber & '_' & CompoundCode AS %KeyYearMonthCustNoComp,
BudgetMOP,
BudgetValue,
BudgetVolume,
BudgetExchRate;
SQL SELECT
BudgetMOP,
BudgetValue,
BudgetVolume,
BudgetExchRate,
CompoundCode,
CustomerNumber,
Month,
Year
FROM PUB.Budget;

RawMaterials:
LOAD MaterialName,
MaterialType,
RawMaterialCode;
SQL SELECT MaterialName,
MaterialType,
RawMaterialCode
FROM PUB.RawMaterials;

[#9 · Accepted solution]

Sorted...... It wasn't Qlikview.... it was Progress locking table overflow....

Thanks for your eagerness to help.... I shall return here again and hopefully helpout when experienced enough...

Cheers