Android

I have table not found in SQLite database table.

11-Aug-15 5:42

See https://www.google.com/search?q=Draggable+Button+in+Xamarin.Android[^].

Member 1141933410-Aug-15 22:19

Member 11419334

10-Aug-15 22:19

Here is my logcat:
08-11 13:40:18.540 15571-15571/com.test.krunal.test E/SQLiteLog﹕ (1) no such table: mydb
08-11 13:40:18.547 15571-15571/com.test.krunal.test E/SQLiteDatabase﹕ Error inserting name=krunal dates=2015-08-11 01:39:56 mobno=7878879383 mailid=abc@abc.com bday=03/08/1994
android.database.sqlite.SQLiteException: no such table: mydb (code 1): , while compiling: INSERT INTO mydb(name,dates,mobno,mailid,bday) VALUES (?,?,?,?,?)

Here is my DatabaseHelper.java file

package com.test.krunal.test;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;

import java.sql.SQLException;

public class DatabaseHelper {
public static final String KEY_ROWID="_id";
public static final String KEY_NAME="name";
public static final String KEY_BDAY="bday";
public static final String KEY_MOBNO="mobno";
public static final String KEY_MAIL="mailid";
public static final String KEY_DATE="dates";

private static final String DATABASE_NAME="mydb";
private static final String DATABASE_TABLE="mytable";
private static final int DATABASE_VERSION=1;

private DbHelper ourhelper;
private Context ourcontext;
private SQLiteDatabase ourdatabase;

public DatabaseHelper(Context c){
ourcontext=c;
}
public DatabaseHelper open() throws SQLException{
ourhelper = new DbHelper(ourcontext);
ourdatabase= ourhelper.getWritableDatabase();
return this;
}

public long createentry(String name, String bday, String mobno, String mail, String dater) {
ContentValues cv=new ContentValues();
cv.put(KEY_NAME,name);
cv.put(KEY_BDAY,bday);
cv.put(KEY_MOBNO,mobno);
cv.put(KEY_MAIL, mail);
cv.put(KEY_DATE, dater);
return ourdatabase.insert(DATABASE_NAME,null,cv);
}
public void close() {
ourhelper.close();
}
public String getdata() {
String[] columns=new String[]{KEY_NAME,KEY_BDAY,KEY_MOBNO,KEY_MAIL,KEY_DATE};
Cursor c=ourdatabase.query(DATABASE_TABLE, columns, null, null, null, null, null);
String result="";
int iName= c.getColumnIndex(KEY_NAME);
int iBday= c.getColumnIndex(KEY_BDAY);
int iMob= c.getColumnIndex(KEY_MOBNO);
int iMail= c.getColumnIndex(KEY_MAIL);
int iDate= c.getColumnIndex(KEY_DATE);
for (c.moveToFirst();c.isAfterLast();c.moveToNext()){
result= result +c.getString(iName) +" "+c.getString(iBday) +" "+
c.getString(iMob)+" "+c.getString(iMail)+" "+c.getString(iDate)+
"\n";
}
return result;
}

private static class DbHelper extends SQLiteOpenHelper{

public DbHelper(Context context) {
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}

@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("CREATE TABLE " + DATABASE_TABLE +" (" +
KEY_ROWID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
KEY_NAME + " TEXT NOT NULL, " +
KEY_BDAY + " TEXT NOT NULL, " +
KEY_MOBNO + " TEXT NOT NULL, " +
KEY_MAIL + " TEXT NOT NULL, " +
KEY_DATE + " TEXT NOT NULL);"
);
}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("DROP TABLE IF EXISTS " + DATABASE_TABLE);
onCreate(db);
}
}
}

And here is My form.java in which Button executes following code in Onclicklistener.

boolean ok=true;
                    try
                    {
                        String name=etname.getText().toString();
                        String bday=etbdate.getText().toString();
                        String mobno=etmobno.getText().toString();
                        String mail=etmailid.getText().toString();
                        String dater=date.toString();

                        DatabaseHelper entry=new DatabaseHelper(Form.this);
                        entry.open();
                        entry.createentry(name, bday, mobno, mail, dater);
                        entry.close();

                        Toast.makeText(getApplicationContext(), "Database Uploaded ", Toast.LENGTH_LONG).show();

                    }
                    catch(Exception ex)
                    {
                        ok=false;
                        catcherror(ex.toString());
                    }

Re: I have table not found in SQLite database table.

Richard MacCutchan10-Aug-15 23:29

how to change the actionbar background color

10-Aug-15 23:29

Java

return ourdatabase.insert(DATABASE_NAME,null,cv);

That is the name of your database, not the table it contains.

Member 118975669-Aug-15 21:16

Member 11897566

9-Aug-15 21:16

dear expert,

as my question in my subject, I can't change the default color of the action bar and I'm following the android documentation and I understand how it works because I have changed the background color in the main content but in the action bar its not working..

I'm using an ecplise ide and have installed the latest SDK for android which is 5.1.1

modified 10-Aug-15 3:26am.

Re: how to change the actionbar background color

Richard MacCutchan9-Aug-15 21:59

Re: how to change the actionbar background color

9-Aug-15 21:59

Member 11897566 wrote:
its not working

You need to explain what that actually means. We cannot guess what you have done, or what results you see.

Member 118975669-Aug-15 22:44

Member 11897566

9-Aug-15 22:44

what I mean by not working is that its not taking effect when I run in on my device, and I don't have any errors in the logcat window or any. but when I change the background color of the main content or inside the linear layout for ex. and run on my device and it does take effect it changed the background color.

I use the theme.holo.light. and the way I code it like this.

in the style.XML inside resource tag

<item name="android:background">#rrggbb color code</item

Re: how to change the actionbar background color

Richard MacCutchan10-Aug-15 1:06

10-Aug-15 1:06

That does not look valid, see https://developer.android.com/training/basics/actionbar/styling.html[^].

Table rows not scrolling

pkfox24-Jul-15 20:53

24-Jul-15 20:53

Hi all, I have a TableLayout nested within a ScrollView / LinearLayout, I add rows to the table dynamically when the application starts, the problem I have is I'm only seeing a third of my tables rows e.g. if I have 30 rows I can only scroll down to row 10 - my layout is as shown below - can anyone see anything wrong with this layout ? It displays and works perfectly for the rows that are visible ( please excuse the formatting )

HTML

<ScrollView
       android:layout_width="fill_parent"
       android:layout_height="fill_parent"
       android:fillViewport="true">
      <LinearLayout
           android:layout_width="fill_parent"
           android:layout_height="fill_parent">
      <TableLayout
           android:layout_width="fill_parent"
           android:layout_height="fill_parent"
           android:id="@+id/tablelayoutmain"
           xmlns:android="http://schemas.android.com/apk/res/android"
           android:layout_marginTop="20dp"
           android:gravity="fill">
      </TableLayout>
    </LinearLayout>
</ScrollView>

We can’t stop here, this is bat country - Hunter S Thompson RIP

modified 25-Jul-15 5:29am.

Richard MacCutchan24-Jul-15 23:44

24-Jul-15 23:44

I just tried using that exact layout, with a dynamically filled table of 40 rows each of 5 columns, and it scrolls fine top to bottom. Maybe you need to show us something more.

pkfox25-Jul-15 1:20

25-Jul-15 1:20

Hi Richard, thanks for replying - I should have said I'm adding ListViews to my table rows which I've read are problematic in ScrollViews but if it works for ten rows it should work ( to my mind ) with any amount

We can’t stop here, this is bat country - Hunter S Thompson RIP

Richard MacCutchan25-Jul-15 2:31

25-Jul-15 2:31

Pete, would you like to share some code? It may be that the view handler is getting confused by the multi-level scrolling. My sample test just added some textviews to each row.

Richard MacCutchan25-Jul-15 3:43

25-Jul-15 3:43

I just tried it and had the same problem using a ListView in each row. It looks like the view manager is taking the count of rows in each ListView item into account when calculating how far it scrolls, and getting confused. This may well be an Android restriction rather than a bug, but who knows?

pkfox25-Jul-15 23:09

25-Jul-15 23:09

I agree, thanks very much for your efforts - do you use Android Studio ? just being nosey.

We can’t stop here, this is bat country - Hunter S Thompson RIP

pkfox26-Jul-15 1:06

26-Jul-15 1:06

Just for your information, I tried removing the LinearLayout to see what would happen and I got all of my rows but only the ListView header was visible and the ListView itself is scrollable ( but too small to be of any use ).

We can’t stop here, this is bat country - Hunter S Thompson RIP

modified 26-Jul-15 7:14am.

Richard MacCutchan26-Jul-15 1:23

26-Jul-15 1:23

Yes, I got that as well. I guess what is effectively a ScrollView inside a ScrollView on a touch screen is quite difficult for the software to manage.

I did try all this in Android Studio, but I find eclipse marginally faster on my PC. See http://www.codeproject.com/Messages/5097852/Android-Studio.aspx[^].

Afzaal Ahmad Zeeshan25-Jul-15 1:53

Afzaal Ahmad Zeeshan

25-Jul-15 1:53

Putting Richard's reply simply, we also need to see the Java code that you are using. That would explain the problem. This XML is just the layout for your application's activity, Java would show how this layout is actually rendered and other similar things. Smile | :)

The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~

pkfox25-Jul-15 23:11

25-Jul-15 23:11

Hi Afzaal, see Richards latest reply - thanks for replying.

We can’t stop here, this is bat country - Hunter S Thompson RIP

Member 1190643213-Aug-15 0:43

Member 11906432

13-Aug-15 0:43

please mention horizontal view or vertical view in your lay out then only it will get scroll.In list view scroll will be automatically called when the items get increased

pkfox14-Aug-15 3:09

How to start in Android programming

14-Aug-15 3:09

Hi there, if you read my original post you will see that my view does scroll but it only shows a third of the rows

We can’t stop here, this is bat country - Hunter S Thompson RIP

aahamdan24-Jul-15 8:42

aahamdan

24-Jul-15 8:42

Dear Expert,

I am in level 0 of android programming.
I need to know how to start learning?
What are the software used to build Android application?
What is the latest software used to build the applications?

Regards,

Re: How to start in Android programming

Richard MacCutchan24-Jul-15 22:31