Forum Discussion
Data Source Error Invalid Column Name
I'm connecting to an Azure SQL db. I haven't had a problem with other tables and views on this server, but for some reason, this view is giving me trouble. Any idea how to resolve this error? Dat...
thanks for the reply parry. I ended up deleting the query, and starting again, and the view was just fine....not sure what was going on....
thanks for the reply parry. I ended up deleting the query, and starting again, and the view was just fine....not sure what was going on....
HashamNiaz
Solution Sage
Solution SageHi Anonymous !
It seems someone has renamed the column name which breaks your query since it might be using (select * from view) format to refer the view.
When you deleted the query & re-created it, it works fine because of the schema refresh.
Regards,
Hasham