Retrive multiples values with raw query

chennaione / sugar

Insanely easy way to work with Android Database.

http://satyan.github.com/sugar/

MIT License

2.62k stars 583 forks source link

Retrive multiples values with raw query #205

Open brunocascio opened 9 years ago

brunocascio commented 9 years ago

How do it ?

`Iterator LI = ExpenseEntity.whichMethod( ExpenseEntity.class, "SELECT id, day, month, year, price, description, SUM(price)"

" FROM EXPENSE_ENTITY"
" WHERE year = ?", year);`

Pascal66 commented 9 years ago

You cant, facility to choose column isnt enabled must be "SELECT * " Look at l130 of sugarrecord class : Cursor c = sqLiteDatabase.query(NamingHelper.toSQLName(type), null, whereClause, whereArgs, groupBy, null, orderBy, limit);