[H2-commits] r1336 - humano2/trunk/core/schema/mssql

[<sv...@de...>]

Author: marcelo
Date: 2005-06-16 14:34:48 -0400 (Thu, 16 Jun 2005)
New Revision: 1336

Modified:
   humano2/trunk/core/schema/mssql/mssql-3-view.sql
Log:
FIXED: SQL not working properly.

Modified: humano2/trunk/core/schema/mssql/mssql-3-view.sql
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- humano2/trunk/core/schema/mssql/mssql-3-view.sql	2005-06-16 18:15:57 =
UTC (rev 1335)
+++ humano2/trunk/core/schema/mssql/mssql-3-view.sql	2005-06-16 18:34:48 =
UTC (rev 1336)
@@ -52,8 +52,8 @@
=20
 INSERT INTO textline VALUES (1018, NULL, NULL, NULL, NULL);
=20
-INSERT INTO view  ("id_entity","columns","where","idClassView","viewName=
")  VALUES (1404,"0,1018","1017^66|4|'[to]'|0|0",1011,"Views of a class V=
iews");
-INSERT INTO view  ("id_entity","columns","where","idClassView","viewName=
")  VALUES (1405,"0,66","34|4|'[DomainId]'|0|0",2,"View of Domain Clases"=
);
+INSERT INTO [view]  ("id_entity","columns","where","idClassView","viewNa=
me")  VALUES (1404,'0,1018','1017^66|4|''[to]''|0|0',1011,'Views of a cla=
ss Views');
+INSERT INTO [view]  ("id_entity","columns","where","idClassView","viewNa=
me")  VALUES (1405,'0,66','34|4|''[DomainId]''|0|0',2,'View of Domain Cla=
ses');
=20
-UPDATE pertinance set "filterView" =3D '1405,DomainId' WHERE id_entity =3D=
 57
-UPDATE pertinance set "filterView" =3D '1404,to' WHERE id_entity =3D 71
+UPDATE pertinence set "filterView" =3D '1405,DomainId' WHERE id_entity =3D=
 57
+UPDATE pertinence set "filterView" =3D '1404,to' WHERE id_entity =3D 71