how to use inputfield

[#1]

Hi all,

I am trying to use inputfield but it seems it doesn't work as I need.

According to the base guide, I have to declare something like:

INPUTFIELD Test.inputField;

Then I can declare my table. I used this one:

Test:
LOAD * 
Inline [
     var, inputField
     1, 1
];

After reloading, I can use that table and change every inputField value.

When I try to declare a table like the following, I can't change inputField value - that's the problem.

Test: 
LOAD *;
SQL SELECT * FROM table;

I need to change some values, and the table comes from a query.

I use QUALIFY and UNQUALIFY statement in my script. I can add a qvw file with a semplify example.

Last but not least: when an user edits a value, will the document save new value into its memory and then share new value with all users?

Thank you.

[Miguel_Angel_Baeyens]

Hi,

Try just removing the table name from the INPUTFIELD sentence, and leave only the name of the actual field, case sensitive:

INPUTFIELD Field_1;
Table:
LOAD Field_1,
     Field_2;
SQL SELECT *
FROM Table;

Hope that helps.

Miguel

[#3]

Thank you for your help.

I tried but it still doesn't work

At the beginning of the script I wrote QUALIFY *...

[Miguel_Angel_Baeyens]

Hi,

My bad, then you do have to set the table name in the INPUTFIELD statement. Are you sure that you are spelling the field correctly? Does it appear case sensitive as you see it in the table viewer (Ctrl + T)? Note that some drivers are case insensitive about the name of the field and they send to the DBM all field names. QlikView does not work that way, and if the field name is uppercase, INPUTFIELD must specify the field uppercase.

Hope that helps.

Miguel

[#5]

checked it... no problem using Inline statement, when I switch to SQL query, it doesn't work no more

[deepakk]

hi,

Try this application

Deepak

[#7]

It works!

But no my document

What happens to you document if you use a script like this

Data:
SQL SELECT *, 1 as Test
FROM Testdata;

In more, I used OLEDB, I see you used ODBC: is this a problem?

[quiquehm]

Hi

Could someone share some more examples on how to use InputField ? I checked the Qview reference guide and the explanation there is really poor. I simply would need to add one InputField in an existing loaded table to appear as a Comments field, where I can manually enter a comment as needed for every row in my table.

Is there any other way to do it than using Load Inline statement ? I found an example , but using LOAD INLINE

INPUTFIELD Budget;

LOAD * INLINE [

Area, Actual, Budget

North, 10000

South, 20000

East, 30000

west, 40000

];

The example is really straight forward, but in my case the table where I need to add the manual entry field is already loaded ( from a flat file generated from another system ). Appreciate any help

Thanks

Enrique

[deepakk]

hi,

The below are the steps forusing inputfield.

1) declare the field

inputfield Test;           -------- here Test is the field name.

2) Use the field inthe table and initialize its value

Select *, 1 as Test from Table.

3)use it in expression  of a pivot/ Straight Table

Inpustum(Test)

I hope this helps.

[deepakk]

Hi Present02,

Try with ODBC in your system or create a resident of the table  like below

Data:

Select * from TestTable;

Load * , 1 as Test residentData; 

where Test is my inputfield.

I will try with OLEDB and let you know my result.

Deepak