Обсуждение: error in schema alter database --- SET
In schema is present error when setting var to database or user. The name of variable is quoted but the value no. E.g pippo=# ALTER DATABASE gedis30 SET "TRANSACTION ISOLATION LEVEL" = read commi tted\g ERROR: parser: parse error at or near "committed" at character 65 pippo=# ALTER DATABASE gedis30 SET "TRANSACTION ISOLATION LEVEL" = "read comm itted"\g ALTER DATABASE Error in sub AddOrUpdate class UserVars, DatabaseVars szSQL = "ALTER DATABASE " & fmtID(Database) & " SET " & fmtID(Name) & " = " & dbSZ(Value) <<<<<<<<<<<< ERROR szSQL = "ALTER USER " & fmtID(szUser) & " SET " & fmtID(Name) & " = " & dbSZ(Value) <<<<<<<<<<<< ERROR Bye !! Frank Lupo (Wolf) !! /\_ _/\ \ o o / --ooo-----ooo--- -- Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f Sponsor: Il vero Pomodoro San Marzano D.O.P. dell' Agro-Sarnese-Nocerino. Clicca qui: http://adv2.email.it/cgi-bin/foclick.cgi?mid=981&d=27-1