Refresh inputfields from SQL Server

[#1]

Hello.

I load data from MS SQL Server into several tables. One of the field I load is an inputfield.

Is there any way to refresh the field from SQL after I change the value in inputfield?

[biester]

Why would you want to do that? Don't understand your scenario. You load a database field as an inputfield, change it and then you want to change it back to the database value?? What for does it have to be an inputfield?

Rgds,
Joachim

[#3]

Well, ok.

I have an SQL database with financial quotes of my own portfolio.

I want to change the current market price of the securities manually to make what-if analysis.

That's why I load a database field as an inputfiled.

Then I want to change that value once again, but I dont know, what was the original value, so I want to refresh data from database.

[biester]

I would load the field twice, once you can define it as inputfield.e.g.:

INPUTFIELD WHAT_IF_PRICE;
LOAD ..... PRICE,PRICE as WHAT_IF_PRICE .....;

Then you have an inputfield to set up your what if analysis and also the original values.

Rgds,
Joachim

[#5]

I'll try this. Thank you.