sqlite> select statustext from statustext, spmblock where spmblock.spmstatus
= statustext.statusid;
sqlite> .schema statustext
CREATE TABLE [StatusText] (
[StatusId] char(4) NOT NULL ,
[StatusText] [nvarchar] (50) NOT NULL
);
sqlite> .schema spmblock
CREATE TABLE SPMBlock (
[SPMId] [int] identity(1,1) NOT NULL ,
[DeviceId] char (3) ,
[SPMIndex] char (3) ,
[SPMStatus] char (4) ,
[BaselineMean] char (10) DEFAULT 0,
[Mean] char (10) DEFAULT 0,
[BaselineStdDev] char (10) DEFAULT 0,
[StdDev] char (10) DEFAULT 0
);
sqlite> select statustext from statustext, spmblock where spmblock.spmstatus
= statustext.statusid;
The above mentioned query just fails with no rows returned.
The tables do contain data as follows:
sqlite> select spmstatus from spmblock;
16
8
8
8
4
8
8
8
8
16
8
32
8
8
32
8
32
8
1
16
16
16
1
1
4
16
1
1
1
1
sqlite> select * from statustext;
1| Inactive
2| Learning
4| Verifying
8| No Detections
16| Mean Change
32| High Variation
64| Low Dynamics
128| Not Licensed
Any Ideas what could be going wrong here.
Prao
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
