Transfer selection to variable

[dirk1955]

Hi,

I have a table wich contains file paths.

After the selection of a file path i want to transfer the selected file path to a variable wich i will use to load data from the selected file, via partitial load.

How can this be done?

I have included the qvw.

THX

Dirk

[Gysbert_Wassenaar · Accepted solution]

You can add a Set Variable action to the OnSelect trigger of the Field with the file paths. You can then use the variable in the load script for the partial reload. Something like:

Table1:

REPLACE ONLY LOAD * FROM [$(vFilePath)]

(biff, embedded labels, table is [Sheet1$]);

edit: see attached example

[dirk1955]

Hi,

"You can add a Set Variable action to the OnSelect trigger of the Field with the file paths."

Where can i do that?

[dirk1955]

THX, but thats what i already did in the uploaded example.

Everytime i get the same error, cannot open....

[#5]

You have the create the variable first. Create the variable from the variable overview dialog box; don't create it in the script since the value will be overwritten.

[dirk1955]

Hi,

Your example is working for me also.

But, what version of clickview are you using?

And: i don't see an action on the triggers tab of the sheet properties.

Furtermore i don't have the possibillity to add a button with the action reload or partial reload in the button properties action window.

[dirk1955]

Hi,

Your example is working for me also.

But, what version of clickview are you using?

And: i don't see an action on the triggers tab of the sheet properties.

Furtermore i don't have the possibillity to add a button with the action reload or partial reload in the button properties action window.

[Gysbert_Wassenaar]

I'm using QV11. I've also tried my example in QV10 (SR3). In QV10 it's indeed not possible to add a reload action. It's not available. The interesting thing is however that the reload action I added using QV11 can still be used if the document is opened in QV10.

The triggers I added can be found on the Triggers tab of the document properties screen instead of on the sheet properties screen.

[dirk1955]

Thank you for the explanation, my problem is solved now.