.NET Question: SqlCommandBuilder dinamic sql question
Posted on 2003-12-11
1. I have a view i sql2k db with 2 databases in it & instead of update trigger - they work 100%
2. I use data adapter to generate dynamic sql update command (in need it to be dynamic).
3. When i update my data adapter (after RefreshSchema() in sqlcommandbuilder with data adapter) i recieve the following error :
"dynamic sql generation is not supported against multiple base tables"
How can i override command builder so that he will generate the command text (sql statement) but will not try to check if the view is with more that one table ?