i need help with sql,

christo garces

unread,

Nov 17, 2015, 3:35:22 AM11/17/15

to DroidScript

Hi

i am able to write data to a sql db, but my question is as follows...

i have text fields say txt1,txt2,txt3

in my select statement how can i retrieve data and push it to those txt fields

and secondly if i try write a spinner textfield to the db it gives me a spannable error

Chris Hopkin

unread,

Nov 17, 2015, 4:36:37 AM11/17/15

to DroidScript

Hi Christo

Have you looked at the Database sample? It shows you how to make a select query and set the results into a Text control. You could modify this to write each field from the result into separate Text controls.

Can you post your code that demonstrates the error with the spinner text?

Thanks

Chris

christo garces

unread,

Nov 17, 2015, 6:52:15 AM11/17/15

to DroidScript

hi

regards the first issue il gv an example

txt1 = app.CreateText(""); //SAY APPLES

txt2 = app.CreateText(""); //SAY BANANAS

ive created a db and have written these values to the db....checked and all is good

now i wana at another point in the app load these values from the db.

db.ExecuteSql("SELECT * FROM mydb WHERE blabla.......

i want apples to appear in txt1 and bananas in txt2

the second issue

txt1 = app.CreateSpinner("1,2,3,4,5,6,7");

if i try write this value into the db, when i run debug it gives me a spannable error

christo garces

unread,

Nov 17, 2015, 6:53:53 AM11/17/15

to DroidScript

do you perhaps have an example of how i could modify the code to receive data to a few text fields

christo garces

unread,

Nov 18, 2015, 1:21:07 AM11/18/15

to DroidScript

hi does anybody have any help?

christo garces

unread,

Nov 18, 2015, 1:29:36 AM11/18/15

to DroidScript

hi chris

im a newbie to droidscript, im from a vb background, so im just not understanding the process. ive used the code that youve assisted another user with, but the issue is that it returns all of the fields in one string eg 1,draw,great, i need to put the 1 into its own text field, same as the draw and the great

Steve Garman

unread,

Nov 18, 2015, 1:55:17 AM11/18/15

to DroidScript

If you want help with your spinner problem, you need to post the code you are using to try to insert it into the database

If you have a comma separated list, one way to split it into different textboxes would be

var txt1,txt2,txt3;
function OnStart()
{
    var lay = app.CreateLayout( "linear", "VCenter,FillXY" );

    txt1 = app.CreateText( "1" );
    lay.AddChild( txt1 );
    txt2 = app.CreateText( "2" );
    lay.AddChild( txt2 );
    txt3 = app.CreateText( "3" );
    lay.AddChild( txt3 );

    app.AddLayout( lay );
    var s ="1,draw,great";
    showVals(s);
}

function showVals(s)
{
    var arr = s.split(",");
    txt1.SetText(arr[0]);
    txt2.SetText(arr[1]);
    txt3.SetText(arr[2]);
}

christo garces

unread,

Nov 18, 2015, 2:10:55 AM11/18/15

to DroidScript

tx steve i will post the code snippets for both my issues as son as i get home. thank you very much

christo garces

unread,

Nov 18, 2015, 4:44:35 AM11/18/15

to DroidScript

Steve Garman

unread,

Nov 18, 2015, 10:45:48 AM11/18/15

to DroidScript

Are you getting errors when you run that code?

If so, what do the errors say and what do you have to do to produce them?

reza azer

unread,

Nov 18, 2015, 2:04:27 PM11/18/15

to DroidScript

Hi Christo

I tryed your code.I found no errors.it works

regards

Steve Garman

unread,

Nov 19, 2015, 1:05:49 AM11/19/15

to DroidScript

Perhaps this code will give you some idea what is going on when you read from the database.

function OnStart()
{

lay = app.CreateLayout( "linear", "VCenter,FillXY" );

    txt1 = app.CreateText( "1",-1,-1,"Multiline" );
    lay.AddChild( txt1 );
    txt2 = app.CreateText( "2",-1,-1,"Multiline" );
    lay.AddChild( txt2 );
    txt3 = app.CreateText( "3",-1,-1,"Multiline" );
    lay.AddChild( txt3 );
    btn=app.CreateButton("Read");
    btn.SetOnTouch(doRead);
    lay.AddChild(btn);

    //Add layout to app.
    app.AddLayout( lay );
    db =app.OpenDatabase("/sdcard/school");
}

function doRead()

{
  db.ExecuteSql( "SELECT * from studrec WHERE surname = 'garcez' ",[],OnR)

}

function OnR(results)
{

var s1 = "",s2="",s3="",item;

   var len = results.rows.length;
   for(var i = 0;i < len;i++)
   {

      item = results.rows.item(i)
      s1 += item.firstname + "\n";
      s2 += item.surname + "\n";
      s3 += item.idnumber + "\n";
   }
   txt1.SetText(s1);
   txt2.SetText(s2);
   txt3.SetText(s3);
}

christo garces

unread,

Nov 19, 2015, 1:13:11 AM11/19/15

to DroidScript

hi steve

Thank you very much for that piece of code you gave me, it has sorted my problem with retrieving data from db.

if i run the code i get spe.txt.spannablestring cannot be cast to java.lang.string , the error occurs because of the spinner, but im not sure why?

christo garces

unread,

Nov 19, 2015, 1:17:58 AM11/19/15

to DroidScript

hi

thats so strange, if you run in debug mode and change the value in the spinner, i get a spannable error

Steve Garman

unread,

Nov 19, 2015, 1:23:37 AM11/19/15

to DroidScript

Is there a line of your code that is highlighted when you get that error?

If so, what is the exact text of that line of code?

christo garces

unread,

Nov 23, 2015, 3:35:02 AM11/23/15

to DroidScript

spn.gettext()

warning spn.gettext failed (android.text.spannablestring cannot be cast to java.lang.string)

Reply all

Reply to author

Forward