android - Can't succed to write in a database -

-

Hi! I am trying to create an application that receives GPS data for days and store it in SQLT database. I have created the database and I also have a geo point array list which I am putting in my geographic points. GPS data is now fake with the help of a KML file, my problem is that even though I succeeded to display the location that has been updated with the new location, when I try to read from the Sclit database And displaying on the screen, I do not get anything, no one is displayed on the screen.

Here is my code: 

  Map activity in public square screen 4 (Private Location Manager LM; Private locale location station; Private MyLocationOverlay myLocOverlay; see private map map map; Private Map controller MC; Override public zeroes on the list of & lt; GeoPoint & gt; GeoPointsArray = New ArrayList & gt; GeoPoint & gt; (); Int Latitude; Int Latitude; @Create {Bundle Saved InstantStat} {Super. Nakrat (Saved Instantstate); setContentView ( R.layout.screen4); Lm = (LocationManager) getSystemService (context.LOCATION_SERVICE); LocationListener = New MyLocationListener (); lm.requestLocationUpdates (LocationManager.GPS_PROVIDER, 0,0, locationListener); MapView = (MapView) Find ViewById (R .id.mapview1); mapView.setBuiltInZoomControls (right); Mc = mapView.getController (); initMyLocation (); DBAdapter db = new DBAdapter (this); db.createDatabase (); for db.openDataBase () I = 0; i & lt; geoPointsArray.size () - 1; i ++) {geographic location = geoPointsArray.get (i); Db.insertData (Integer.toString (loc.getLongitudeE6 ()), Integer.toString (loc.getLatitudeE6 ()), zero, null, faucet); } Cursor c = db.getAllData (); If (c.moveToFirst) () {DisplayTitle (c); } While (c.moveToNext ()); } If (c! = Null & amp;; cisClosed ()) {db.close (); }} Private Zero Init Myelication () {myLocOverlay = New MyLocationOverlay (this, map view); MyLocOverlay.enableMyLocation (); . Adding MapView.getOverlays () (myLocOverlay); } Public Zero DisplayTitle (Cursor C) {Toast.makeText (This, "Longitude:" + c.getString (0) + "\ n" + "Latitude:" + c.getString (1) + "\ n", Toast .LENGTH_LONG) .show (); } Private class applies the MyLocationListener location laser {@Override changed the location to public zero (location location) {if (loc! = Null) {latitude = (int) (loc.getLatitude () * 1E6); Longitude = (int) (loc.getLongitude () * 1E6); Geopoint P = New GeoPoint (latitude, longitude); GeoPointsArray.add (P); Mc.animateTo (P); Mc.setZoom (17); MapView.invalidate (); MapView.setSatellite (right); }} Override public zero {// TODO auto-generated method stub} on @ProviderDisabled @ProviderEverabled {string} {} Override status switching (string provider, int status, bundle extras) on public zero { }} Protected Boolean Hydride Display () {// Tudo Auto-Generated Method Stub Return False; }}   
 I debug my code line by line and as I get this line (the first one):  
 for  ( Int i = 0; i & lt; geoPointsArray.size () - 1; i ++) {Geo-point people = Geo PointErray.Gate (I); Db.insertData (Integer.toString (loc.getLongitudeE6 ()), Integer.toString (loc.getLatitudeE6 ()), zero, null, faucet); }   
 Debugger jumps to this snippet ... Now for me this means that I do not have any sense in my geo point array and I do not have any collection in the data base And there is nothing from reading here SQLite Can someone please help me with some ideas. Thanks   
 
 
 In general  if  must be guarded for arrays  i & Lt; Size  and  i .  
 You can use the Guard to avoid mistakes:  
 For  (GeoPoint loc: geoPointsArray) {....   
  
  Edit  - In addition, your database access is being done only in  onCreate . You need to do this in your  LocationListener  if you receive updates you expect to call it.  
  onCreate  is said only once when your activity is created. You should open your database here and then get access to it when you actually get the data.

Comments

Post a Comment

Popular posts from this blog

qt - switch/case statement in C++ with a QString type -

-
I want to use switch-case in my program but the compiler generates an error. How can I use the switch statement with QString ? The compiler gives me this error: The expression of the switch type 'QString' is invalid My code is as follows : boolStopWord (the word QString) {bool flag = false; Switch (word) {case "the": flag = true; break ; "On" case: flag = true; break ; Case "in": flag = true; break ; Case "your": flag = true; break ; Case "near": flag = true; break ; Case "all": flag = true; break ; Case "this": flag = true; break ; } Return flag; } How do I use the switch statement with a Caststring ? You can not use the switch statement in C ++ language with integral or enum types. You can formally enter the square type of object in the switch statement, but this means that the compiler will look for a user-defined conversion to convert it to an integral or enum type.
Read more

python - sqlite3.OperationalError: near "REFERENCES": syntax error - foreign key creating -

-
I'm trying to create a predefined key after checking the manual and I wrote it: Db.execute ("create table" Table 2 (id, integer primary key, somedata integer) "db.execute" (table creation table 2 does not exist (name text, maintain reference (id) ") and found this: sqlite 3. Operation error: near" references ": syntax error Your second ligne is wrong db.execute ("create table if table does not exist 2 (name text, my_id integer, foreign key (my_id) reference Maintenance (ID)) ") as explained
Read more

Python's equivalent for Ruby's define_method? -

-
What is a Python equivalent for Ruby's define_method , which is the dynamic generation of class methods will allow? (As can be seen in Wikipedia) Functions are first-class objects in Python and assign them The properties of a class or an example can be a way of doing the same thing as a Wikipedia example: colors = {"black": "000", "red": "F00", "green": "0f0", "yellow": "ff0", "blue": "00f", "magenta": "fff", "cyan": "0ff", "white": " FFF "} Class MyStream (ARR): Pass for Name, Code in colors.iteritems (): def _in_colour ( W code = code): return '& lt; Span style = "color:% s" & gt;% s & lt; / Span & gt; ' % (Code, self) setter (histrive, "in_" + name, _in_ color)
Read more