开发者

Android SQLite no data from View

开发者 https://www.devze.com 2023-04-02 20:40 出处:网络
I\'m developing a Andro开发者_Python百科id App. This App have an SQLite Database. This Database have 6 Tables an 5 Views. If I try to get Data from a View, there is no Data. At the Debugging I looked

I'm developing a Andro开发者_Python百科id App. This App have an SQLite Database. This Database have 6 Tables an 5 Views. If I try to get Data from a View, there is no Data. At the Debugging I looked in the Cursor and the Columns are listed but not data. Count is -1.

The I copy the Database via DDMS to my PC and open it in SQLlite Manager(Firefox Plugin) and start the same Query (Copy at Debugging from Code) and there are Data from the same Database with the same query.

It is possible, that the Android Device (HTC Sensation) and the Emulator are not powerful enough to run such difficult Querys?


In sqlite the field names in views are retrieved during the query unless you specify the field names during the view creation.

Is the field KUNO existing in the view_all_sms or is it the field Contact_ID?

Try:

Select * From view_all_sms_wcd where Contact_ID = '1' order by ST_DTE asc
0

精彩评论

暂无评论...
验证码 换一张
取 消