Hi Listmembers, today I tried the follwing: I have DB-Instance with 8 tables in it. These are all in a SCHEMA called 'sstorm' ;) Now I logged into that instance with the SQL Studio using my new girlfriend MONA with her top secret password RED :)
There 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'. I retried it (after a DROP VIEW), as I first thought I forgot to enter the SCHEMA-Name in the definition, but once again the new VIEW has been asociated to mona :( So then I used: SET CURRENT_SCHEMA = sstorm // CREAT VIEW OR REPLACE VTB_sellings AS SELECT ... What should I say - this works fine. As I have not had the time, I did not proof this issue in more detail. FYI: Using MaxDB 7.6.00.10 & SQL Studio 7.6.00.3 on a Win-XP-Home box (SP2 + all Post-SP2-fixes, localized german) So my question is: Did I misunderstand the manual or is it wrong in that point too? Or is this the second Bug (after the DROP VIEW RESTRICT) I found? 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]
