Hi folks, creating a simple application in VB where i am reading a single table in SQL Server 2005.
An easy example of what i am trying to achieve would be the following where a user enters data for the length and width fields and then i need the VB application to multiply the length field x the Width Field to achieve the result for the Answer field.
How would i achieve same - Stored procedure ? Also, is the updated answer field only viewable when data application is refreshed etc.
I am using Developer Express Apps to create the application. I could use Unbound columns to create the columns i require with associated calculations but am unsure if i should be using unbound columns or hardcoding the calculations someway in SQL
You shouldn't store that calculated data to begin with. You'll have to write code (triggers, etc...) to maintain should any of the parameters change.
You should calculate those values when the data is retrieved.
If it's not practically useful, then it's practically useless.