Thanks everyone. The problem was in the create table query. End braces
were missing.
Regards,
Sawan
On Apr 8, 4:52 pm, Hielko <[EMAIL PROTECTED]> wrote:
> Use:
>
> log.e(TAG, "Some error message");
>
> On Apr 8, 12:23 pm, Sawan007 <[EMAIL PROTECTED]> wrote:
>
> > I am afraid I don't how to use Log to print the values. Please advice.
> > Thanks
>
> > On Apr 8, 6:37 am, "Dan U." <[EMAIL PROTECTED]> wrote:
>
> > > Have you tried using Log to print out the values you are using in your
> > > SQL queries? I bet something there is null. Do you have the stack
> > > trace to tell you what line in the code is causing the problem?
>
> > > On Apr 7, 6:24 pm, Sawan007 <[EMAIL PROTECTED]> wrote:
>
> > > > Could you please advise what is wrong with this piece of code. After
> > > > clikcing on button "Change Password" (confirmButton). I get the
> > > > Application error
> > > > An error has occurred in ... near "null":syntax error.
> > > > Please help.
>
> > > > public class password extends Activity
> > > > {
> > > > private SQLiteDatabase db;
> > > > private EditText pwd1;
> > > > private EditText pwd2;
> > > > private int passset = 1;
> > > > /** Called when the activity is first created. */
>
> > > > class Row extends Object {
> > > > public String password;
> > > > public long rowId;
> > > > }
>
> > > > public void onCreate(Bundle icicle) {
> > > > super.onCreate(icicle);
> > > > setContentView(R.layout.pass_change);
>
> > > > if(passset == 1){
> > > > // ask for pass
> > > > Intent i = new Intent(this, passverify.class);
> > > > startSubActivity(i, 0);
>
> > > > pwd1 = (EditText) findViewById(R.id.pass1);
> > > > pwd2 = (EditText) findViewById(R.id.pass2);
>
> > > > Button confirmButton = (Button)
> > > > findViewById(R.id.pass_change);
> > > > Button cancelButton = (Button) findViewById(R.id.cancel);
> > > > // populateFields();
>
> > > > confirmButton.setOnClickListener(new
> > > > View.OnClickListener() {
>
> > > > public void onClick(View arg0) {
> > > > String password1 = pwd1.getText().toString();
> > > > String password2 = pwd2.getText().toString();
> > > > if (password1.equals(password2)){
> > > > try {
> > > > db = openDatabase("sms", null);
> > > > }
> > > > catch (FileNotFoundException e1) {
> > > > db = null;
> > > > }
> > > > db.execSQL("create table password (rowid
> > > > integer primary
> > > > key autoincrement,"
> > > > + "password text not null");
> > > > Row row = new Row();
> > > > Cursor c =
> > > > db.query(true, "password", new String[] {
> > > > "rowid", "password"}, null, null, null,
> > > > null, null);
> > > > if (c.count() > 0) {
> > > > c.first();
> > > > row.rowId = c.getLong(0);
> > > > row.password = c.getString(1);
> > > > c.close();
> > > > ContentValues args = new ContentValues();
> > > > args.put("password", password1);
> > > > db.update("password", args, "rowid=" +
> > > > row.rowId, null);
> > > > } else {
> > > > //row.rowId = -1;
> > > > //row.password = null;
> > > > c.close();
> > > > /*ContentValues initialValues = new
> > > > ContentValues();
> > > > initialValues.put("password", password1);
> > > > db.insert("password", null, initialValues);
> > > > */
> > > > db.execSQL("insert into password
> > > > values('"+password1+"')");
> > > > }
> > > > }
> > > > //db.close();
> > > > setResult(RESULT_OK);
> > > > finish();
> > > > }
> > > > }
> > > > );
> > > > cancelButton.setOnClickListener(new View.OnClickListener() {
>
> > > > public void onClick(View arg0) {
> > > > setResult(RESULT_OK);
> > > > finish();
> > > > }
> > > > }
> > > > );
> > > > }
>
> > > > }- Hide quoted text -
>
> > - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[EMAIL PROTECTED]
Announcing the new M5 SDK!
http://android-developers.blogspot.com/2008/02/android-sdk-m5-rc14-now-available.html
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
-~----------~----~----~----~------~----~------~--~---
