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