Hello Michael, The next 7.6.00 release will contain a SQL Studio version 7.6.00.35. This SQL Studio will include the feature described in the webpts link.
regards Wolfgang -----Ursprüngliche Nachricht----- Von: Michael Neuber [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 31. Oktober 2006 09:03 An: Auer, Wolfgang; maxdb@lists.mysql.com Betreff: Re: AW: SQL Studio and View Definitions Good Morning, Wolfgang, right now available from MySQL.com is SQL Studio Vs 7.6.00.27, packed in the file maxdb-sqlstudio-setup-7_6_00-130190.exe (I just checked this again - [2006-10-31 08:20]). For this Version 7.6.00.27 -which, IMHO can thus be regarded to be the latest available version - the problem (1) and (2) I described in my mail yesterday are still present, problem (3) (multiple occurrence of selected attributes) is partly solved, however, one needs still some fantasy to recognize the own (in my case admittedly long) view definition for a UNION SELECT. The work-around to use the SELECT * FROM "DOMAIN"."VIEWDEFS" where VIEWNAME = '<your view>' does not really help : By default, SQL Studio displays only 1kB of long columns. Hence, the select without further change displays just this 1kB. Since I know that my definition had about 35kB length, I configured SQL Studio to limit the length for display of long columns to 50000 Byte or even down to 38000Byte, and then again issued the query. After about 10secs of contemplation, the system returned with a crash of the video display system: (a) a video reconfiguration (!) to ... presumably VGA display... (640x480pixels, lowest color quality 4bit), and that is a dramatic change on a laptop capable to show 1680x1050 pixel; (b) the system error message with the dialog title: Windows - Display Driver Stopped and the content: The ialmrnt5 display driver has stopped working normally. Save your work and reboot the system to restore full display functionality. The next time you reboot the machine a dialog will be displayed giving you a chance to upload data about this failure to Microsoft. [OK] TBH, this is close to the least what I expect when I have the chance to set limits on lengths of to be displayed columns in SQL Studio. The link you supply in the last of your messages http://www.sapdb.org/webpts?wptsdetail=yes&ErrorType=0&ErrorID=1142469 leads to a web page in which an SQL Studio Vs. 7.6.02.00 is mentioned. Where can I get this version in order to check, whether currently there is indeed a chance to see all of my view definitions in a manner, which allows to inspect in detail what I have defined in my views? Michael Neuber Auer, Wolfgang schrieb: > Hello Michael, > > Please use the newest 7.6 version of SQL Studio. > As you can see in the PTS Link > http://pts:1080/webpts?wptsdetail=yes&ErrorType=0&ErrorID=1142469 some of the > problems you describe are already resolved. > > To see the original view definition kept by the kernel you can execute a > 'SELECT * FROM "DOMAIN"."VIEWDEFS" where VIEWNAME = '<your view>'. > If the line breaks are missing in the definition field, SQL Studio does not > have a chance to display them in the view dialog. > > The comments you make are very interesting and will be considered in the new > development of SQL Studio. > To repeat the situation you describe could you please send me the complete > definitions of your views and tables. > > Regards > Wolfgang -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
