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





X





Pinterest





Email





Other Apps




Comments





Post a Comment



Popular posts from this blog




Member with no value in F# -



  After   I am trying to convert F # to the following C # code:    [StructLayout (LayoutKind.Sequential, charset = CharSet.Ansi)] Private class DOCINFOA {[MarshalAs (UnmanagedType.LPStr)] public string nomeDocumento; [Marshall (UnmanagedType.LPStr)] Public string arquivoSaida; [Marshall (UnmanagedType.LPStr)] Public String Tipodo; }    I am doing the following:    Named place printer module RawPrinterHelper = [& LT; StructLayout (LayoutKind.Sequential, charset = CharSet.Ansi) & gt;] Type DOCINFOA = [& LT; MarshalAs (UnmanagedType.LPStr) & gt;] Member this.nomeDocumento [& LT; MarshalAs (UnmanagedType.LPStr) & gt;] Member this.arquivoSaida [& LT; MarshalAs (UnmanagedType.LPStr) & gt;] Member This Tipoda [/ code>   But I get:  One type of definition is necessary for one or more members . Can I vacate these members?      you  val  code> member :    [& lt; StructLayout (LayoutKind.Sequential, charset = CharSet.Ansi) & gt;] Type DOCINFOA = [...





Read more





java - Joda Time Interval Not returning what I expect -



    मेरे पास निम्न प्रोग्राम है    import java.util। *; Import java.text। *; आयात करें org.joda.time। *; सार्वजनिक श्रेणी के स्कोप कंट्रोल {सार्वजनिक स्थिर अंतराल मिलनसार () {दिनांक समय currDate = नया दिनांक समय (2008, 4, 4, 15, 30, 0, 0); दिनांक समय epochDate = नया दिनांकटाइम (2000, 1, 1, 12, 0, 0, 0); अंतराल अंतराल = नया अंतराल (युरोप डेट, करोडेट); वापसी अंतराल; } सार्वजनिक स्थिर शून्य मुख्य (स्ट्रिंग [] आर्ग्स) {डबल दिनबात = मिलते समय ()। ToDurationMillis () / 1000/60/60/24; StdOut.println (daysBtween); }}    मुझे आउटपुट मिल रहा है: 3016.0   लेकिन जो मैं देख रहा हूं वह है: 3016.1458333333   मैं क्या कर रहा हूँ ?      toDurationMillis एक लंबा लौटा देता है, और प्रत्येक प्रभाग को int के रूप में घोषित किया जाता है। जावा इस प्रकार इनट्स को लॉन्ग में परिवर्तित कर देगा और डिवीजन को लंबे समय तक लौटाना होगा। परिणाम को अंत में दोहरे रूप में परिवर्तित करना। डबल्स का उपयोग करके अभिव्यक्ति करने के लिए जावा को बताने के लिए, अभिव्यक्ति के किसी भी घटक को दोहरे रूप में घोषित करें। उदाहरण के लिए:    ...





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

Search This Blog

Alcantara

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

Comments

Post a Comment

Popular posts from this blog

Member with no value in F# -

java - Joda Time Interval Not returning what I expect -

c# - Showing a SelectedItem's Property -