diff -r 000000000000 -r bde4ae8d615e os/persistentdata/persistentstorage/sql/TEST/testexecute/SQLite/config/views.ini
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/os/persistentdata/persistentstorage/sql/TEST/testexecute/SQLite/config/views.ini	Fri Jun 15 03:10:57 2012 +0200
@@ -0,0 +1,94 @@
+[views]
+Delete0=c:\test3.db
+ExpectedError0=KErrNotFound
+Create1=c:\test3.db
+NewBlock2=create1
+NewBlock3=create2
+NewBlock4=create3
+NewBlock5=view1
+NewBlock6=view2
+EndBlock7=
+
+[create1]
+Exec0=create table names(pkey int primary key, fname text, lname text, ref int);
+Exec1=insert into names(pkey, fname, lname, ref) values(1, "tom", "jones", 2);
+Exec2=insert into names(pkey, fname, lname, ref) values(2, "jim", "davies", 1);
+Exec3=insert into names(pkey, fname, lname, ref) values(3, "bob", "smith", 1);
+Exec4=insert into names(pkey, fname, lname, ref) values(4, "dave", "house", 3);
+Exec5=insert into names(pkey, fname, lname, ref) values(5, "jane", "hobbs", 4);
+EndBlock6=
+
+[create2]
+Exec0=create table roles(ref int primary key, job text, band text);
+Exec1=insert into roles(ref, job, band) values(1, "engineer", "A");
+Exec2=insert into roles(ref, job, band) values(2, "sales", "A");
+Exec3=insert into roles(ref, job, band) values(3, "consultant", "B");
+Exec4=insert into roles(ref, job, band) values(4, "manager", "C");
+Exec5=insert into roles(ref, job, band) values(5, "VP", "D");
+EndBlock6= 
+
+[create3]
+Exec0=create table sal(band text primary key, wage real);
+Exec1=insert into sal(band, wage) values ("A", 24000);
+Exec2=insert into sal(band, wage) values ("B", 30000);
+Exec3=insert into sal(band, wage) values ("C", 45000);
+Exec4=insert into sal(band, wage) values ("D", 60000);
+EndBlock5=
+
+[view1]
+Exec0=create view v1 as select fname, lname, job from names, roles where names.ref = roles.ref;
+Prepare1=select * from v1;
+ColumnIndex2=fname
+ColumnIndex3=lname
+ColumnIndex4=job
+Next5=
+ColumnTextL6=0,tom
+ColumnTextL7=1,jones
+ColumnTextL8=2,sales
+Next9=
+ColumnTextL10=0,jim
+ColumnTextL11=1,davies
+ColumnTextL12=2,engineer
+Next13=
+ColumnTextL14=0,bob
+ColumnTextL15=1,smith
+ColumnTextL16=2,engineer
+Next17=
+ColumnTextL18=0,dave
+ColumnTextL19=1,house
+ColumnTextL20=2,consultant
+Next21=
+ColumnTextL22=0,jane
+ColumnTextL23=1,hobbs
+ColumnTextL24=2,manager
+St_Close25=
+EndBlock26=
+
+[view2]
+Exec0=create view v2 as select fname, job, wage from names, roles, sal where names.ref = roles.ref and roles.band = sal.band;
+Prepare1=select * from v2;
+ColumnIndex2=fname
+ColumnIndex3=job
+ColumnIndex4=wage
+Next5=
+ColumnTextL6=0,tom
+ColumnTextL7=1,sales
+ColumnReal8=2,24000
+Next9=
+ColumnTextL10=0,jim
+ColumnTextL11=1,engineer
+ColumnReal12=2,24000
+Next13=
+ColumnTextL14=0,bob
+ColumnTextL15=1,engineer
+ColumnReal16=2,24000
+Next17=
+ColumnTextL18=0,dave
+ColumnTextL19=1,consultant
+ColumnReal20=2,30000
+Next21=
+ColumnTextL22=0,jane
+ColumnTextL23=1,manager
+ColumnReal24=2,45000
+St_Close25=
+EndBlock26=