Input Box

[siddheshmane]

Hi,

How do I insert multiple values from a single input box. When I insert a value in the input box and append it to the original table and Later when I try to insert a different value in the input box, it overwrites the old value.

Thanks.

[siddheshmane]

Hi Sir,

I tried the steps you mentioned, but the values are still being overwritten. This is my code. Please review and suggest if there are any errors.

LET vListQVDExists = not isnull(QVDCreateTime('Test.qvd'));

SalesDesc:

LOAD * Inline [

Customer, Sales Order ID,ShipDate,Product,Sales,Quantity

$(Customer1), $(SalesOrderID),$(ShipDate1), $(Product), $(Sales1), $(Quantity1)

];

IF $(vListQVDExists) then

Concatenate(SalesDesc)

LOAD * From Test.qvd (qvd);

ENDIF

STORE SalesDesc into 'D:\Projects\Test.qvd';

Is there any way to store two values of a single field using one input box.

Thanks.

[Anonymous]

Can you share this sample QVW and the excel file you are trying to load

[siddheshmane]

Hi,

Here are the qv file and the excel data.

Thanks.

[siddheshmane · Accepted solution]

Bhagirath‌‌, Thank You Sir, for the effort you took into explaining me the solution.

I got the answer finally. The code is as you said. I just had to do a Partial Reload everytime I want to add a value.

----------------------------------------------------------------------------------------

LET vListQVDExists = not isnull(QVDCreateTime('Test.qvd'));

SalesDesc:

LOAD * Inline [

Customer, Sales Order ID,ShipDate,Product,Sales,Quantity

$(Customer1), $(SalesOrderID),$(ShipDate1), $(Product), $(Sales1), $(Quantity1)

];

IF $(vListQVDExists) then

Concatenate(SalesDesc)

LOAD * From Test.qvd (qvd);

ENDIF

SalesNewDesc:

ADD LOAD * Inline [

Customer, Sales Order ID,ShipDate,Product,Sales,Quantity

$(Customer1), $(SalesOrderID),$(ShipDate1), $(Product), $(Sales1), $(Quantity1)

];

STORE SalesDesc into 'D:\Projects\Test.qvd';

------------------------------------------------------------------------------------

Adding the ADD keyword before the LOAD fucntion allows to partial reload..

Thanks.

[Anonymous]

Hi Siddhesh,

Can you please recheck, make sure every time you enter values to input box u need to save your document and then reload

i have done some dummy entries, see the attached QVD and paste it in the same location where qvw is.

I dont think you can this input solution for Acesspoint, because the reload at server will not save values of variables user has changed.

anyways you can mark my solutions correct or useful if it has helped you

[siddheshmane]

Yes. Every time I reload, the values are entered into the table and then saved into the qvd file. But as you said this won't be the case while doing a reload at server.

Thanks.

[siddheshmane]

I am also attaching you the file. You can check and suggest me if I have made a mistake.

[Anonymous]

you do not need this statement

SalesNewDesc:

ADD LOAD * Inline [

Customer, Sales Order ID,ShipDate,Product,Sales,Quantity

$(Customer1), $(SalesOrderID),$(ShipDate1), $(Product), $(Sales1), $(Quantity1)

];

as you have already loaded the same in SalesDesc

below script is fine

LET vListQVDExists = not isnull(QVDCreateTime('Test.qvd'));

SalesDesc:

LOAD * Inline [

Customer, Sales Order ID,ShipDate,Product,Sales,Quantity

$(Customer1), $(SalesOrderID),$(ShipDate1), $(Product), $(Sales1), $(Quantity1)

];

IF $(vListQVDExists) then

Concatenate(SalesDesc)

LOAD * From Test.qvd (qvd);

ENDIF

STORE SalesDesc into 'D:\Projects\Test.qvd';

you can load the excel file data immediately after this and get that concatenated with the SalesDesc table