I wrote: > ... > > I tried to define a trigger using this code-snippet: > CREATE VIEW OR REPLACE sstorm.VTB_sellings AS SELECT ... > > After that I tried to use this view by an ODBC-connected program, > but it fails, so I checked it in SQL Studio again. In the left > pane I have to recognize, that this View-Table has not associated > to the SCHEMA 'sstorm' but to the SCHEMA 'mona'. > ... > As I have not had the time, I did not proof this issue in more > detail. > ...
In the meantime I played with it, but I can not replicate the mentioned behaviour today. Maybe (probably) this has been an issue on my windows and has been solved automaticly by the reboot of this windows-box :) The view-tables I defined today have been associated to the schema I include in the CREATE_VIEW-statement as it is stated in the manual. Sorry for the panic ;) Kind regards & Thank for help and comments! (And sorry for my poor english ;)) Andreas -- GMX DSL = Maximale Leistung zum minimalen Preis! 2000 MB nur 2,99, Flatrate ab 4,99 Euro/Monat: http://www.gmx.net/de/go/dsl -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
