Script failed storing input field on partial load

[mrossoit]

Hi all,

I'm trying to build a save/load "macro-less" system for values modified by a user.

My app loads many records so I used partial load to execute only the storing portion of the script.

In the sample you could see that if inputfield declaration is commented then the qvd's saving process works, in the opposite a loading error occurs.

Any of you knows if this is caused by a qlikview bug or if I missed something?

Thanks

MR

[pokassov]

Hello, Massimiliano!

Please, change your script. Because you have a mistake in "store.." section.

INPUTFIELD IF;

tab:

LOAD * INLINE [

    F1, IF

    1, 0

    2, 0

    3, 0

];

if IsPartialReload() then

  STORE tab into tab.qvd (qvd);

ENDIF;

[mrossoit]

Hi Сергей,

thank you for your answer but partial load still not work on my qvw

[pokassov]

I'm sorry. My first answer was wrong.

It's curious. It's looks like qv sees the table "tab" but cannot use it during partial reload.

So I decided to try some tricks.

One of them have worked.  I created another table and store it to qvd;

Can you try?

INPUTFIELD IF;

tab:

LOAD * INLINE [

    F1, IF

    1, 0

    2, 0

    3, 0

];

if IsPartialReload() then

  //STORE tab into c:\temp\tab.qvd (qvd);

let vChech=NoOfTables();

TRACE $(vChech);

  t2:

  Replace NoConcatenate

  LOAD

  *

  Resident

  tab;

  STORE t2 into c:\temp\tab.qvd (qvd);

  DROP Table t2;

ENDIF;

[mrossoit]

Same result.

The document automatically close during script execution and qv ask me if I want to load previous data

[pokassov]

It's strange...

Now I'm sure with the result. I've attached model.

Can you check your QlikView version?

Sergey

[mrossoit]

Loading tab in a temporary t2 is a good idea.

Your qvw now doesn't crash during partial load but has a strange behaviour:

after the storing, IF becomes a normal field without input functionality and its values automatically change from 0, 0, 0 to 0, 1, 2 in this order.

Yesterday I was running 11.20.12235.0 SR5 x64 version, this morning I installed 11.20.12742.0 SR10 x64 version but there's no differences.

[pokassov]

I've break my head ))

Instead of partial reload I used the action "Export".

I had got the file with correct inputfield values.

And my inputfield still was inputfield.

After that I changed some inputfield values.

However, when I was traying load this file (instead of load * inline), inputfield values didn't change.

Sergey.

[sunny_talwar]

Did not go through the whole post, but Partial Reload needs Add or Replace next to LOAD. Is that something which might be missing?

I am going to check now.

Best,

Sunny

[sunny_talwar]

I guess you are only trying to save it during the partial reload. So that doesn't need an Add or Replace. My bad.

Best,

Sunny