[constraints]

 Delete0=c:\test2.db

 ExpectedError0=KErrNotFound

 Create1=c:\test2.db

 NewBlock2=test

 Close3=

 EndBlock4=

 [test]

 Exec0=create table names(pkey int primary key, fname text, lname text NOT NULL, age int, UNIQUE(fname, lname), CHECK(age < 100));

 Exec1=insert into names(pkey, fname, lname, age) values(1, "fred", "smith", 25);

 Exec2=insert into names(pkey, fname, lname) values(1, "tom", "jones");

 ExpectedError2=KSqlErrConstraint

 Exec3=insert into names(pkey, fname, lname) values(2, "fred", "smith");

 ExpectedError3=KSqlErrConstraint

 Exec4=insert into names(pkey, fname) values(3, "fred");

 ExpectedError4=KSqlErrConstraint

 Exec5=insert into names(pkey, fname, lname, age) values(2, "tom", "jones", 101);

 ExpectedError5=KSqlErrConstraint

 EndBlock6=