sl@0: [views]
sl@0: Delete0=c:\test3.db
sl@0: ExpectedError0=KErrNotFound
sl@0: Create1=c:\test3.db
sl@0: NewBlock2=create1
sl@0: NewBlock3=create2
sl@0: NewBlock4=create3
sl@0: NewBlock5=view1
sl@0: NewBlock6=view2
sl@0: EndBlock7=
sl@0: 
sl@0: [create1]
sl@0: Exec0=create table names(pkey int primary key, fname text, lname text, ref int);
sl@0: Exec1=insert into names(pkey, fname, lname, ref) values(1, "tom", "jones", 2);
sl@0: Exec2=insert into names(pkey, fname, lname, ref) values(2, "jim", "davies", 1);
sl@0: Exec3=insert into names(pkey, fname, lname, ref) values(3, "bob", "smith", 1);
sl@0: Exec4=insert into names(pkey, fname, lname, ref) values(4, "dave", "house", 3);
sl@0: Exec5=insert into names(pkey, fname, lname, ref) values(5, "jane", "hobbs", 4);
sl@0: EndBlock6=
sl@0: 
sl@0: [create2]
sl@0: Exec0=create table roles(ref int primary key, job text, band text);
sl@0: Exec1=insert into roles(ref, job, band) values(1, "engineer", "A");
sl@0: Exec2=insert into roles(ref, job, band) values(2, "sales", "A");
sl@0: Exec3=insert into roles(ref, job, band) values(3, "consultant", "B");
sl@0: Exec4=insert into roles(ref, job, band) values(4, "manager", "C");
sl@0: Exec5=insert into roles(ref, job, band) values(5, "VP", "D");
sl@0: EndBlock6= 
sl@0: 
sl@0: [create3]
sl@0: Exec0=create table sal(band text primary key, wage real);
sl@0: Exec1=insert into sal(band, wage) values ("A", 24000);
sl@0: Exec2=insert into sal(band, wage) values ("B", 30000);
sl@0: Exec3=insert into sal(band, wage) values ("C", 45000);
sl@0: Exec4=insert into sal(band, wage) values ("D", 60000);
sl@0: EndBlock5=
sl@0: 
sl@0: [view1]
sl@0: Exec0=create view v1 as select fname, lname, job from names, roles where names.ref = roles.ref;
sl@0: Prepare1=select * from v1;
sl@0: ColumnIndex2=fname
sl@0: ColumnIndex3=lname
sl@0: ColumnIndex4=job
sl@0: Next5=
sl@0: ColumnTextL6=0,tom
sl@0: ColumnTextL7=1,jones
sl@0: ColumnTextL8=2,sales
sl@0: Next9=
sl@0: ColumnTextL10=0,jim
sl@0: ColumnTextL11=1,davies
sl@0: ColumnTextL12=2,engineer
sl@0: Next13=
sl@0: ColumnTextL14=0,bob
sl@0: ColumnTextL15=1,smith
sl@0: ColumnTextL16=2,engineer
sl@0: Next17=
sl@0: ColumnTextL18=0,dave
sl@0: ColumnTextL19=1,house
sl@0: ColumnTextL20=2,consultant
sl@0: Next21=
sl@0: ColumnTextL22=0,jane
sl@0: ColumnTextL23=1,hobbs
sl@0: ColumnTextL24=2,manager
sl@0: St_Close25=
sl@0: EndBlock26=
sl@0: 
sl@0: [view2]
sl@0: Exec0=create view v2 as select fname, job, wage from names, roles, sal where names.ref = roles.ref and roles.band = sal.band;
sl@0: Prepare1=select * from v2;
sl@0: ColumnIndex2=fname
sl@0: ColumnIndex3=job
sl@0: ColumnIndex4=wage
sl@0: Next5=
sl@0: ColumnTextL6=0,tom
sl@0: ColumnTextL7=1,sales
sl@0: ColumnReal8=2,24000
sl@0: Next9=
sl@0: ColumnTextL10=0,jim
sl@0: ColumnTextL11=1,engineer
sl@0: ColumnReal12=2,24000
sl@0: Next13=
sl@0: ColumnTextL14=0,bob
sl@0: ColumnTextL15=1,engineer
sl@0: ColumnReal16=2,24000
sl@0: Next17=
sl@0: ColumnTextL18=0,dave
sl@0: ColumnTextL19=1,consultant
sl@0: ColumnReal20=2,30000
sl@0: Next21=
sl@0: ColumnTextL22=0,jane
sl@0: ColumnTextL23=1,manager
sl@0: ColumnReal24=2,45000
sl@0: St_Close25=
sl@0: EndBlock26=