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