Hi,

I am using vwd 05. I have a table, and I want a column to have default value of a sum of 2 others. e.g: column4 = column1 + (column2 * column3)

Where would I write this so the columns value is set automatically using the sum?

Thanks,

Jon 

cell_2.Font.Bold = True

 Hi, thanks for your reply!

I was actually talking about a database table - static thats always there..

Thanks,

Jon
 

You would need a trigger to add data to User_Data when a new row is
added to aspnet_users:

   CREATE TRIGGER add_user_data ON aspnet_Users FOR INSERT AS
    INSERT User_Data(UserID, Level, Points, ...)
       SELECT UserID, 1, 0, --- more defaults goes here
       FROM   inserted

or use just formula in insert statement argument like..

dim z as integer =x+y

insert into a values (x,y,z)

In the database side you can do it with the following script;

select col1+(col2 * col3) as col 4 from yourtable

But actually i could not understand if you are talking about this.

Or in the application side (i assume you have a datatable filled with the results) you can add a computed column as;

for example dt is your datatable in your dataset, and you want to add a computed column;

dt.Columns.Add("col4", GetType(Integer), "col1 + (col2 * col3)") in vb.net

 dt.Columns.Add("col4", typeof(int), "col1 + (col2 * col3)") in c#

 Hi,

I am using VWD 05..

I am looking at tables - click 'open table definitions' - where you make tables and define their data type..

I noticed in the column properties there is a 'default value or binding' section - I thought maybe I could type in some code there to make all entrys of the column the sum of other columns?

Or is there another way to do it permenantly through vwd backend?

Thanks,

Jon