|
sl@0
|
1 |
[views]
|
|
sl@0
|
2 |
Delete0=c:\test3.db
|
|
sl@0
|
3 |
ExpectedError0=KErrNotFound
|
|
sl@0
|
4 |
Create1=c:\test3.db
|
|
sl@0
|
5 |
NewBlock2=create1
|
|
sl@0
|
6 |
NewBlock3=create2
|
|
sl@0
|
7 |
NewBlock4=create3
|
|
sl@0
|
8 |
NewBlock5=view1
|
|
sl@0
|
9 |
NewBlock6=view2
|
|
sl@0
|
10 |
EndBlock7=
|
|
sl@0
|
11 |
|
|
sl@0
|
12 |
[create1]
|
|
sl@0
|
13 |
Exec0=create table names(pkey int primary key, fname text, lname text, ref int);
|
|
sl@0
|
14 |
Exec1=insert into names(pkey, fname, lname, ref) values(1, "tom", "jones", 2);
|
|
sl@0
|
15 |
Exec2=insert into names(pkey, fname, lname, ref) values(2, "jim", "davies", 1);
|
|
sl@0
|
16 |
Exec3=insert into names(pkey, fname, lname, ref) values(3, "bob", "smith", 1);
|
|
sl@0
|
17 |
Exec4=insert into names(pkey, fname, lname, ref) values(4, "dave", "house", 3);
|
|
sl@0
|
18 |
Exec5=insert into names(pkey, fname, lname, ref) values(5, "jane", "hobbs", 4);
|
|
sl@0
|
19 |
EndBlock6=
|
|
sl@0
|
20 |
|
|
sl@0
|
21 |
[create2]
|
|
sl@0
|
22 |
Exec0=create table roles(ref int primary key, job text, band text);
|
|
sl@0
|
23 |
Exec1=insert into roles(ref, job, band) values(1, "engineer", "A");
|
|
sl@0
|
24 |
Exec2=insert into roles(ref, job, band) values(2, "sales", "A");
|
|
sl@0
|
25 |
Exec3=insert into roles(ref, job, band) values(3, "consultant", "B");
|
|
sl@0
|
26 |
Exec4=insert into roles(ref, job, band) values(4, "manager", "C");
|
|
sl@0
|
27 |
Exec5=insert into roles(ref, job, band) values(5, "VP", "D");
|
|
sl@0
|
28 |
EndBlock6=
|
|
sl@0
|
29 |
|
|
sl@0
|
30 |
[create3]
|
|
sl@0
|
31 |
Exec0=create table sal(band text primary key, wage real);
|
|
sl@0
|
32 |
Exec1=insert into sal(band, wage) values ("A", 24000);
|
|
sl@0
|
33 |
Exec2=insert into sal(band, wage) values ("B", 30000);
|
|
sl@0
|
34 |
Exec3=insert into sal(band, wage) values ("C", 45000);
|
|
sl@0
|
35 |
Exec4=insert into sal(band, wage) values ("D", 60000);
|
|
sl@0
|
36 |
EndBlock5=
|
|
sl@0
|
37 |
|
|
sl@0
|
38 |
[view1]
|
|
sl@0
|
39 |
Exec0=create view v1 as select fname, lname, job from names, roles where names.ref = roles.ref;
|
|
sl@0
|
40 |
Prepare1=select * from v1;
|
|
sl@0
|
41 |
ColumnIndex2=fname
|
|
sl@0
|
42 |
ColumnIndex3=lname
|
|
sl@0
|
43 |
ColumnIndex4=job
|
|
sl@0
|
44 |
Next5=
|
|
sl@0
|
45 |
ColumnTextL6=0,tom
|
|
sl@0
|
46 |
ColumnTextL7=1,jones
|
|
sl@0
|
47 |
ColumnTextL8=2,sales
|
|
sl@0
|
48 |
Next9=
|
|
sl@0
|
49 |
ColumnTextL10=0,jim
|
|
sl@0
|
50 |
ColumnTextL11=1,davies
|
|
sl@0
|
51 |
ColumnTextL12=2,engineer
|
|
sl@0
|
52 |
Next13=
|
|
sl@0
|
53 |
ColumnTextL14=0,bob
|
|
sl@0
|
54 |
ColumnTextL15=1,smith
|
|
sl@0
|
55 |
ColumnTextL16=2,engineer
|
|
sl@0
|
56 |
Next17=
|
|
sl@0
|
57 |
ColumnTextL18=0,dave
|
|
sl@0
|
58 |
ColumnTextL19=1,house
|
|
sl@0
|
59 |
ColumnTextL20=2,consultant
|
|
sl@0
|
60 |
Next21=
|
|
sl@0
|
61 |
ColumnTextL22=0,jane
|
|
sl@0
|
62 |
ColumnTextL23=1,hobbs
|
|
sl@0
|
63 |
ColumnTextL24=2,manager
|
|
sl@0
|
64 |
St_Close25=
|
|
sl@0
|
65 |
EndBlock26=
|
|
sl@0
|
66 |
|
|
sl@0
|
67 |
[view2]
|
|
sl@0
|
68 |
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
|
69 |
Prepare1=select * from v2;
|
|
sl@0
|
70 |
ColumnIndex2=fname
|
|
sl@0
|
71 |
ColumnIndex3=job
|
|
sl@0
|
72 |
ColumnIndex4=wage
|
|
sl@0
|
73 |
Next5=
|
|
sl@0
|
74 |
ColumnTextL6=0,tom
|
|
sl@0
|
75 |
ColumnTextL7=1,sales
|
|
sl@0
|
76 |
ColumnReal8=2,24000
|
|
sl@0
|
77 |
Next9=
|
|
sl@0
|
78 |
ColumnTextL10=0,jim
|
|
sl@0
|
79 |
ColumnTextL11=1,engineer
|
|
sl@0
|
80 |
ColumnReal12=2,24000
|
|
sl@0
|
81 |
Next13=
|
|
sl@0
|
82 |
ColumnTextL14=0,bob
|
|
sl@0
|
83 |
ColumnTextL15=1,engineer
|
|
sl@0
|
84 |
ColumnReal16=2,24000
|
|
sl@0
|
85 |
Next17=
|
|
sl@0
|
86 |
ColumnTextL18=0,dave
|
|
sl@0
|
87 |
ColumnTextL19=1,consultant
|
|
sl@0
|
88 |
ColumnReal20=2,30000
|
|
sl@0
|
89 |
Next21=
|
|
sl@0
|
90 |
ColumnTextL22=0,jane
|
|
sl@0
|
91 |
ColumnTextL23=1,manager
|
|
sl@0
|
92 |
ColumnReal24=2,45000
|
|
sl@0
|
93 |
St_Close25=
|
|
sl@0
|
94 |
EndBlock26=
|