| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
|
| Why running the following script gives an error message E_US0836 line 1, Column 'c' not found in any specified table. ? --------------------------------- create table tmp00 (a i1, b i1); create view tmp00_vw as select * from tmp00; alter table tmp00 add column c i1; select c from tmp00_vw; rollback; \g |
|
#2
|
| This is why we do not use SELECT * in production code. It may or may not be re-executed, depending wher it appears. You now know that a VIEW is defined once with expanded column names. |
![]() |
| Thread Tools | |
| Display Modes | |