Changing key in virtual table

James111 · 2012-11-29

Hi I need add the key in to virtual table - Date table,

Please tell my, what can i do?

mohana_cse06 · 2012-11-29

Virtual talbes do not exist in our database so we cannot modify them

James111 · 2012-11-29

Thanks Mohana,

so tell my, how i can do group my record using "Period Name" field from virtual Date table?

James

Chinmoy · 2012-11-29

One way can be to create another table (with same structure as Date and create a key on Period Name), populate the records (on the fly) into this new table from Date before using them.

Chn

Changing key in virtual table

Comments

Categories