Hello Lukasz, Thank you for your hints.
If you work a lot with lower case identifiers please switch off the preference "Identifiers in Create Dialogs Uppercase". (Session->Settings->General) The View-Dialog and Index-Dialog will then not upper names. The behaviour of the View-Dialog with "expressions columns" will be improved in a future version of SQL Studio. regards Wolfgang Wolfgang Auer Developer MaxDB&liveCache mailto:[EMAIL PROTECTED] http://www.sap.com Sitz der Gesellschaft/Registered Office: Walldorf, Germany Vorstand/SAP Executive Board: Henning Kagermann (Sprecher/CEO), Léo Apotheker (stellvertretender Sprecher/Deputy CEO), Werner Brandt, Claus Heinrich, Gerhard Oswald, Peter Zencke Vorsitzender des Aufsichtsrats/Chairperson of the SAP Supervisory Board: Hasso Plattner Registergericht/Commercial Register Mannheim No HRB 350269 Diese E-Mail kann Betriebs- oder Geschäftsgeheimnisse oder sonstige vertrauliche Informationen enthalten. Sollten Sie diese E-Mail irrtümlich erhalten haben, ist Ihnen eine Kenntnisnahme des Inhalts, eine Vervielfältigung oder Weitergabe der E-Mail ausdrücklich untersagt. Bitte benachrichtigen Sie uns und vernichten Sie die empfangene E-Mail. Vielen Dank. This e-mail may contain trade secrets or privileged, undisclosed, or otherwise confidential information. If you have received this e-mail in error, you are hereby notified that any review, copying, or distribution of it is strictly prohibited. Please inform us immediately and destroy the original transmittal. Thank you for your cooperation. -----Ursprüngliche Nachricht----- Von: Lukasz Misztal [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 21. Juni 2007 12:08 An: Anhaus, Thomas; maxdb Betreff: SQL Studio and lowercase name of objects Tomas, thanks for help, for me seems that SQL Studio is also vunerable for lowercase names. It is frequent for getting definition from exist objects. Can i also report following bugs in SQL Studio? If not, where can i do this? For example: //-------------------------------- CREATE TABLE "TableT1" ( "Id" Fixed (10,0) NOT NULL DEFAULT SERIAL (1), "Value" Varchar (200) UNICODE ) // insert into "TableT1" values (1,'xx') // CREATE VIEW "v_TableT1" AS SELECT "Id", NULL AS "NullValue" FROM "TableT1" // CREATE INDEX "Aa" ON "TableT1" ("Id" ASC) //-------------------------------- And bugs for it: 1) missing null value & wrong name of view On SQL Studio: - double click on view "v_TableT1" - right click on export to SQL Dialog result is: CREATE VIEW "V_TABLET1" ( "Id" ) AS SELECT "Id", NULL AS "NullValue" FROM "TableT1" 2) wrong name of index On SQL Studio: - double click on index "Az" - right click on export to SQL Dialog result is: CREATE INDEX "AA" ON "TableT1" ("Id" ASC) Best regards, Lukasz. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
