android - Getting object from DB returns empty object or app crashes -

In my DB Manager class, I have a way of recovering the selected group with group_db and trip_db parameters.

   
 public selected_ group get_selected_group_by_group_id_and_trip_id (int trip_id, int group_id) {open_readable (); Cursor cursor = db.query (static.tablets_names.TABLE_NAME_SELECTED_GROUPS, blank, "trip_id =" + trip_id + "& group_id =" + group_id, empty, blank, empty, empty); Int sg_id = 0; Int sg_trip_id = 0; Int sg_group_id = 0; While (cursor.movteonxt ()) {sg_id = cursor.getInt (0); Sg_trip_id = Cursor.Gist (1); Sg_group_id = cursor.getInt (2); } Selected_groupsg = new selected_groups (sg_id, sg_trip_id, sg_group_id); Cursor.close (); Close (); Return sg; }

However in this case the cursor skips the entire while loop and I am getting a selected group with initial values, i.e. _id = 0

So I tried it like this:

  gets the public chosen group - selected / group_by_graph_id_ and_trop_id (int trip_id, int group_id) {open_readable (); Cursor cursor = db.query (static.tablets_names.TABLE_NAME_SELECTED_GROUPS, blank, "trip_id =" + trip_id + "& group_id =" + group_id, empty, blank, empty, empty); Cursor.moveToFirst (); Int sg_id = cursor.getInt (0); Int sg_trip_id = cursor.getInt (1); Int sg_group_id = cursor.getInt (2); Selected_Group sg = New Selected_Group (sg_id, sg_trip_id, sg_group_id); Cursor.close (); Close (); Return sg; }

In this case, the app crashes with the following error message:

  08-01 14: 31: 17.416: E / Andorrentime ( 13385): Fatal avisepion: Main 08-01 14: 31: 17.416: E / Android Random (13385): android.database.CursorIndexOutOfBoundsException: Index 0 0 08-01 14: 31: 17.416: Size of E / Andorrentime (13385) Requested with: At android.database.AbstractCursor.checkPosition (AbstractCursor.java:400) 08-01 14: 31: 17.416: E / Android Time (13385): On the Android Database. Abovewondowword Cursors. Checkpoint (Abbottwonded Cursors.Javier 36) 08-01 14: 31: 17.416: E / Android Rendime (13385): On Android Databases Abob Winder cursor.gate (Abbottwonded Cursor. Java: 68) 08-01-14: 31: 17.416: E / Androindertime (13385): at com.mycompany.myapp. Tasks. Task_DB_Manager.get_selected_group_by_group_id_and_trip_id (Task_DB_Manager.java ** 42) 08-01-14: 31: 17.416: E / Android Time (13385): 08.01 14 at com.mycompany.myapp.activities.Activity_Add_Edit_Trip.onClick (Activity_Add_Edit_Trip.java .63) : 31: 17.416: E / Android Random (13385): Android. View.View.performClick (see .Java 3511) 08-01 14: 31: 17.416: E / Android Time (13385): $ PerformClick.run at android.view.View (see .Java14105) 08-01 14: 31: 17.416 : E / AndroidDime (13385): Android.OSHandlerHandley Callback (HandlerJava: 605) 08-01 14: 31: 17.416: E / Android Random (Android): Android. OS Handler Dispatch Message (Handler. Java) 08-01 14: 31: 17.416: E / Android Rendime (13385): Android. Los. Looper Oops (Looper Java: 137) 08-01 14: 31: 17.416: E / Android Random (13385): Android. App ActivateTrade.Mine (ActivityTrad.Java 4424) 08-01 14: 31: 17.416: E / Android Time (13385): Java.lang.reflect.Method.invokeNative at (original method) 08-01 14: 31: 17.416: E / AndromedaTime (13385): at java.lang.reflect.Method.invoke (Method 11.Pass 11) 08- 01 14: 31: 17.416: E / Android Random (13385): com.android.internal.os.ZygoteInit $ MethodAndArgsCaller Run (ZygoteInit.java:784) 08-01 14: 31: 17.416: E / Android Time (13385): Internal.os.ZygoteInit.main on Com.android (Geogotinet. Java 5151) 08-01 14: 31: 17.416: E / Android Rendime (13385): Dlvic. System Netstart.mine (default method)

I checked with the debugger and all the parameters are being passed correctly. The SQLite browser shows that I have the same table with these parameters Have a record.

The table was created in the DB_Helper class:

  // create the selected group of groups string create_table_selected_groups = "create tab" + Constants.Table_Names.TABLE_NAME_SELECTED_GROUPS + "(_ID primary primary Antoinecrum "+", trip_id INTEGER, group_id INTEGER); "; Db.execSQL (create_table_selected_groups);

Why is not being returned? What is the problem with this code?

and operator works on binary numbers and = < There is more cooperative than / code>.

What do you want AND :

   "trip_id =" + Trip_id + "and group_id =" + group_id






-



03:22


















Get link





Facebook





Twitter





Pinterest





Email





Other Apps




Comments





Post a Comment



Popular posts from this blog




sqlite3 - UPDATE a table from the SELECT of another one -



     I have the first table  article  where some data is missing.   In the table,  articles_tmp  I have a part of the missing data.   So I want to update the  articles. Where the path path is   data in articles_tmp.path where the path is not zero .    With  SQLite , it does not work:    update article SET path = (SELECT at.path FROM Articles_tmp as AS, WHERE at.article_id = a.id and a.asp, the text is in the form and not on. It has been transmitted) where the path is null    MS Access Along with, it works fine:    Update Articles Join the Inner Articles at articles_tmp articles.id = articles_tmp.id SETP articles.path = articles_tmp.path    Can anyone help?      Sin CE SQL Server Syntax, which I provided, was not working, here this solution With whom I have come. A little modification of your original query, but with my "correlation" suggestion added. There is a SQL Bella for this:   Here is the code:    update article SET path = (SELECT path from articles_tmp AS T WHERE t.id 





Read more





c# - Showing a SelectedItem's Property -



    So I have enabled a rightclick option for my DataGrid. I want to display the only chosen property but it is not behaving like what I would like it to display my name and additional.    Public category Paymentinfo {public int PaymentNo {get; Set; } Public string date {get; Set; } Public Double Pay {get; Set; } Public Double Principle {get; Set; } Public Double Interest {get; Set; } Public Double Balance {Received; Set; }} Private Zero MenuItem_OnClick (Object Sender, RoutedEventArgs e) {MessageBox.Show (AmortGrid.SelectedItem.ToString ()); }    I'm trying to apply it without using a View Module! If I place a breakpoint where the messagebox and the recipient place it on selected ITEM, then this property will display the payment. A date-payment-principle-interest-balance is the only value that needs payment.   Was hoping that it would be something like this    MessageBox.Show (AmortGrid.SelectedItem.PaymentNo.ToString ());       When you call  ToString ()  So you get the class typ





Read more





javascript - Render HTML after each iteration in loop -



    I'm trying to gradually increase the font size of text on a web page. The code works in my place, although the new HTML / CSS does not render after every iteration of the loop and when all this is done, then display only the text of 100 px size. To see the text as if it is slowly zooming, I need to do this JavaScript is down because it is being used from a different file here is what I have ...  < Pre>  & lt; P class = "game-title" style = "font-size: 50px" & gt; Test & lt; / P & gt; Function sleep (milliseconds) {var start = new date (). GetTime (); For (var i = 0; i & lt; 1e7; i ++) {if ((new date). GetTime () - start) & gt; Milliseconds {break; CSS ('font-size', 'parseInt ($ (' game-title '). CSS (' font-size ')) + 1 + "pixels"); } While (parasont ($ ('# text'). Css ('font-size')) & lt; = 100) {sleep (1000); IncreaseSize (); Using CSS:           Use of jQuery (sample):





Read more

Search This Blog

Alcantara

android - Getting object from DB returns empty object or app crashes -

Comments

Post a Comment

Popular posts from this blog

sqlite3 - UPDATE a table from the SELECT of another one -

c# - Showing a SelectedItem's Property -

javascript - Render HTML after each iteration in loop -