Massimo Renzi (MATICA) wrote some time ago: > > > Hi all, > Ive installed 7.4 in Linux Mandrake. > Now to execute a query in SQLStudio I need to put " in the > table name and > field name like this: > <cut> > SELECT * FROM "DBA"."UTENTE" WHERE "DBA"."UTENTE"."ID_UTENTE" = 1 > </cut> > Why?
Why do you think this is needed? As MaxDB always changes identifier without " around to upper case, those mentioned above do not differ from those without " around. > and why dont work this statment? > <cut> > ALTER TABLE "DBA"."UTENTE" DROP COLUMN > "DBA"."UTENTE"."ID_UTENTE" RELEASE > SPACE > ---- Error ------------------------------- > Auto Commit: On, SQL Mode: Ansi, Isolation Level: Committed > Syntax error or access violation;-3005 POS(1) Invalid SQL statement. > ALTER TABLE "DBA"."UTENTE" DROP COLUMN > "DBA"."UTENTE"."ID_UTENTE" RELEASE > SPACE > </cut> You are using ANSI-mode, meaning SQL92-compatible syntax. And SQL92 did not know ALTER TABLE. Therefore the error is correct. Please change the sqlmode to internal and the statement will work Elke SAP Labs Berlin > > If I omit the "RELEASE SPACE" I've: > <cut> > ALTER TABLE "DBA"."UTENTE" DROP COLUMN "DBA"."UTENTE"."ID_UTENTE" > ---- Error ------------------------------- > Auto Commit: On, SQL Mode: Ansi, Isolation Level: Committed > Syntax error or access violation;-3005 POS(1) Invalid SQL statement. > ALTER TABLE "DBA"."UTENTE" DROP COLUMN "DBA"."UTENTE"."ID_UTENTE" > </cut> > > Thank you > > Max > > > -- > 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]
