Updateing SQL views via TDBGrid
Posted on 2006-04-25
problem is simple but very annoying.
I have TADOQuery, TDataSource and TDBGrid all set and ready.
TADOQuery.SQL is set to "select * from My_View" My_View is very simple MSSQL View (select Col1 from My_Table)
when I connect to database I can view, edit, delete, append and everything... but when I launched SQL Profiler I was stunned but what I saw
all SQL INSERTs, UPDATEs etc are performed on My_Table not on My_View.
Have You experienced something like that? I spent 2 hours trying to force SQL commands to preform on view instead of table