Android SQLite 错误“请求带有表名的列名”

发布于 2024-10-31 04:37:35 字数 754 浏览 0 评论 0原文

运行以下形式的 sql 查询后：

SELECT table_name.column_name FROM table_name,table_name2,etc... WHERE condition1,condition2,etc...,

我收到以下错误，该错误不会关闭我的程序：

请求列名与表名--table_name.column_name

google 搜索此错误短语，我找到了 android.database.sqlite.SQLiteCursor line 314

第 314 行上方的几行有一条注释，指出此代码是对 bug 903852 的响应。但我似乎无法在 google 上找到这个 bug。

所以这是一个由两部分组成的问题：

列名是否错误 SQL 中表的名称？（我当时印象中这是一个最佳实践）
我如何找到 Android 错误报告 903852 以便我能明白问题是什么吗？（谷歌搜索 Android bug 903852 并没有工作）

原文

After running an sql query of the form:

SELECT table_name.column_name FROM table_name,table_name2,etc... WHERE condition1,condition2,etc...,

I get the following error, which does not shut down my program:

requesting column name with table name -- table_name.column_name

A google search for this error phrase led me to android.database.sqlite.SQLiteCursor line 314

A few lines above line 314 there is a comment that this code is a response to bug 903852. But I can't seem to find this bug on google.

So this is a two part question:

Is it wrong to name the column
name with the table in SQL? (I was
under the impression that this was a
best practice)
How do I find
Android bug report 903852 so that I
can understand what the issue is?
(googling Android bug 903852 doesn't
work)

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

太阳哥哥 2024-11-07 04:37:35

就我而言，当我使用时问题得到了解决

select table_name.column_name as column_name_alt WHERE ....

，后来在我的 CursorAdapter 中，在字符串数组中仅将其引用为column_name_alt。

希望这有帮助。

In my case, the problem was solved when I used

select table_name.column_name as column_name_alt WHERE ....

and later, in my CursorAdapter, referred to it in the string array only as column_name_alt.

Hope this helps.

回复收藏 0 原文

孤凫 2024-11-07 04:37:35

因此，我在创建一个将传递给 SimpleCursorAdapter 的 Cursor 时遇到了这个问题。事实证明，虽然可以在“查询”列前面添加 String[] 前缀，但随后传递给 SimpleCursorAdapter 构造函数不需要需要添加前缀才能使适配器正确映射结果集。

回复收藏 0 原文

将军与妓 2024-11-07 04:37:35

几天前我遇到了同样的问题，并使用替代方法解决了该问题。以前我使用以下方法将光标设置为指向该列。

String sqlStatement = "SELECT supplierid,suppliercode,suppliername FROM supplierinfo WHERE suppliername  LIKE '%"+query+"%' ";
        cursor = db.rawQuery(sqlStatement,null);
        if (cursor != null && cursor.getCount() > 0){
            if (cursor.moveToFirst()){
                do {
                    int supplierId = cursor.getInt( 0);
                    String supplierCode = cursor.getString(cursor.getColumnIndex( "suppliercode" )) != null ? cursor.getString( cursor.getColumnIndex( "suppliercode" ) ) : "";
                    String supplierName = cursor.getString(cursor.getColumnIndex( "suppliername" )) != null ? cursor.getString( cursor.getColumnIndex( "suppliername" ) ) : "";
                    supplierInfo =  new SupplierInfo();
                    supplierInfo.setSupplierID( supplierId );
                    supplierInfo.setSupplierCode( supplierCode );
                    supplierInfo.setSupplierName( supplierName );
                    supplierInfoList.add(supplierInfo);
                } while (cursor.moveToNext());
            }

当我将其更改为以下方法后，它对我有用。

String sqlStatement = "SELECT supplierid,suppliercode,suppliername FROM supplierinfo WHERE suppliername  LIKE '%"+query+"%' ";
        cursor = db.rawQuery(sqlStatement,null);
        if (cursor != null && cursor.getCount() > 0){
            if (cursor.moveToFirst()){
                do {
                    int supplierId = cursor.getInt( 0);
                    String supplierCode = cursor.getString(1) != null ? cursor.getString( 1 ) : "";
                    String supplierName = cursor.getString(2) != null ? cursor.getString( 2 ) : "";
                    supplierInfo =  new SupplierInfo();
                    supplierInfo.setSupplierID( supplierId );
                    supplierInfo.setSupplierCode( supplierCode );
                    supplierInfo.setSupplierName( supplierName );
                    supplierInfoList.add(supplierInfo);
                } while (cursor.moveToNext());
            }

I got the same issue few days back and solved the issue using an alternative method. Previously I used the following method to set the cursor to point the column.

String sqlStatement = "SELECT supplierid,suppliercode,suppliername FROM supplierinfo WHERE suppliername  LIKE '%"+query+"%' ";
        cursor = db.rawQuery(sqlStatement,null);
        if (cursor != null && cursor.getCount() > 0){
            if (cursor.moveToFirst()){
                do {
                    int supplierId = cursor.getInt( 0);
                    String supplierCode = cursor.getString(cursor.getColumnIndex( "suppliercode" )) != null ? cursor.getString( cursor.getColumnIndex( "suppliercode" ) ) : "";
                    String supplierName = cursor.getString(cursor.getColumnIndex( "suppliername" )) != null ? cursor.getString( cursor.getColumnIndex( "suppliername" ) ) : "";
                    supplierInfo =  new SupplierInfo();
                    supplierInfo.setSupplierID( supplierId );
                    supplierInfo.setSupplierCode( supplierCode );
                    supplierInfo.setSupplierName( supplierName );
                    supplierInfoList.add(supplierInfo);
                } while (cursor.moveToNext());
            }

After I changed this into the following method it worked for me.

String sqlStatement = "SELECT supplierid,suppliercode,suppliername FROM supplierinfo WHERE suppliername  LIKE '%"+query+"%' ";
        cursor = db.rawQuery(sqlStatement,null);
        if (cursor != null && cursor.getCount() > 0){
            if (cursor.moveToFirst()){
                do {
                    int supplierId = cursor.getInt( 0);
                    String supplierCode = cursor.getString(1) != null ? cursor.getString( 1 ) : "";
                    String supplierName = cursor.getString(2) != null ? cursor.getString( 2 ) : "";
                    supplierInfo =  new SupplierInfo();
                    supplierInfo.setSupplierID( supplierId );
                    supplierInfo.setSupplierCode( supplierCode );
                    supplierInfo.setSupplierName( supplierName );
                    supplierInfoList.add(supplierInfo);
                } while (cursor.moveToNext());
            }

回复收藏 0 原文