how to insert record from UI

[#1]

I'd like to build a what if tool, I know we can use INPUTFIELD to modify existing record values with table box, but what if I want to add new record instead of adjusting existing one, what is in my mind is that we can place an input box for each column, user can manually input the value and click "Add" and insert this new record in existing table, how can I achive this? Thanks.

[#2]

I don't need to insert the change back into database, add to qv data model is enough.

[jmvilaplanap]

Then, I think that the ronalddoes solution is the only way.

You can use partial reload to do it lighter (What is meant by partial reload? What is its use? Please explain!) but, you must to reload the script.

Regards

[#4]

hi Pankaj,

I think the Dynamic update works, I will try something with this approach.

Thanks a lot

-Stan

[RonaldDoes]

Hi Stan,

I'm sorry, I should have shared the fruit.qvd as well.

Here you go. Save both in the same location and you're good to go.

[RonaldDoes]

Hi Jose,

A partial reload would be a great way to add the "new fruit" to the data model of the QVW, however it will never store it into QVD, since only the ADD LOADs are executed.

This means that after a full reload, your additions would be gone again.

That's why I suggested a full reload.

[jmvilaplanap]

Hi Ronald

Can't you store a QVD with the new data?

I think if you can reload it then you can store it, isn't it?

Regards

[RonaldDoes]

Hi Jose,

You are right! I assumed the QVD wouldn't be stored during a partial reload, but testing it appears to be working now.

I wonder what else is executed during partial reloads apart from the ADD LOADs.