[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=