没有这样的列：R1.ReadingDate错误 [英] No such a column: R1.ReadingDate Error

问题描述

我已经创建使用SQLite经理源码视图。

I have created a view in sqlite using sqlite manager.

Create View vMeterReading
as
SELECT M._id as Meter_id, M.MeterNumber, R1.ReadingDate, R1.Reading AS              CurrentReading, R2.ReadingDate AS PrevReadingDate, R2.Reading AS PrevMeterReading, R2.Rate  as Rate, R2._id,R1.TenantMeter_id
FROM (Meters AS M INNER JOIN TenantMeters ON M._id = TenantMeters.Meter_id) INNER JOIN (MeterReading AS R1 INNER JOIN MeterReading AS R2 ON R1.TenantMeter_id = R2.TenantMeter_id) ON TenantMeters._id = R1.TenantMeter_id
WHERE (((R2.ReadingDate)=(SELECT Max(R3.ReadingDate) 
      FROM [MeterReading] AS R3   
      WHERE (R3.TenantMeter_id = R1.TenantMeter_id)   
        AND (R3.ReadingDate < R1.ReadingDate)     
    ))) OR (((R2.TenantMeter_id) Is Null))
ORDER BY M.MeterNumber, R1.ReadingDate.

我曾尝试使用此视图（ SELECT * FROM vMeterReading ）的Andr​​oid和我得到的标题错误。

I have tried to use this view (select * from vMeterReading) in android and I get the error as titled.

我也连接到从命令提示符下sqlite的分贝，并试图执行相同的查询。我得到了同样的错误。

I have also connected to the sqlite db from command prompt and tried to execute the same query. I get the same error.

什么是错的sql语句？

What is wrong with the sql statement?

它运作良好，在SQL管理器（Firefox插件）。

It works well in sql manager(firefox add-on).

推荐答案

问题是由Android使用SQLite的版本是不一样的SQLite的由管理器使用的版本。 Android版本不支持我使用的连接。
下面的查询执行与出的问题。
得到这个网站这个建议 http://sqlite.1065341.n5.nabble.com/

The problem was that the SQLite version used by android is not the same as the version used by sQLite manager. The android version does not support the join i was using. The query below executes with out problems. Got this advice from this site http://sqlite.1065341.n5.nabble.com/

SELECT M._id as Meter_id, M.MeterNumber, R1.ReadingDate as ReadingDate,
R1.Reading AS CurrentReading, R2.ReadingDate AS PrevReadingDate, R2.Reading
AS PrevMeterReading, R2.Rate as Rate, R2._id as _id,R1.TenantMeter_id as TenantMeterID
FROM Meters AS M INNER JOIN TenantMeters ON M._id = TenantMeters.Meter_id
INNER JOIN MeterReading AS R1 ON R1.TenantMeter_id = TenantMeters ._id
 INNER JOIN MeterReading AS R2 ON
R1.TenantMeter_id = R2.TenantMeter_id 

WHERE (((R2.ReadingDate)=(SELECT Max(R3.ReadingDate)
      FROM [MeterReading] AS R3
      WHERE (R3.TenantMeter_id = R1.TenantMeter_id)
        AND (R3.ReadingDate < R1.ReadingDate)
    ))) OR (((R2.TenantMeter_id) Is Null))

这篇关于没有这样的列：R1.ReadingDate错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！