sl@0: [constraints]
sl@0: Delete0=c:\test2.db
sl@0: ExpectedError0=KErrNotFound
sl@0: Create1=c:\test2.db
sl@0: NewBlock2=test
sl@0: Close3=
sl@0: EndBlock4=
sl@0: 
sl@0: [test]
sl@0: Exec0=create table names(pkey int primary key, fname text, lname text NOT NULL, age int, UNIQUE(fname, lname), CHECK(age < 100));
sl@0: Exec1=insert into names(pkey, fname, lname, age) values(1, "fred", "smith", 25);
sl@0: Exec2=insert into names(pkey, fname, lname) values(1, "tom", "jones");
sl@0: ExpectedError2=KSqlErrConstraint
sl@0: Exec3=insert into names(pkey, fname, lname) values(2, "fred", "smith");
sl@0: ExpectedError3=KSqlErrConstraint
sl@0: Exec4=insert into names(pkey, fname) values(3, "fred");
sl@0: ExpectedError4=KSqlErrConstraint
sl@0: Exec5=insert into names(pkey, fname, lname, age) values(2, "tom", "jones", 101);
sl@0: ExpectedError5=KSqlErrConstraint
sl@0: EndBlock6=