German DBUtils / How to show in Listview

H

Hodi

Member

Licensed User

Longtime User

• May 15, 2012

• #1

Hi,


I want to use an edittext to select special rows from my SQL database and show them in Listview.

Is it possible to use something like this code?:

DBUtils.ExecuteListView(SQL1, "SELECT col1, col2 FROM Table1 WHERE col1= Edittext1",Null, 0, Listview1, True)


Thanks in advance,
Hodi

 

klaus

Expert

Licensed User

Longtime User

• May 29, 2012

• #2

No, you should use:

B4X:

DBUtils.ExecuteListView(SQL1, "SELECT col1, col2 FROM Table1 WHERE col1= '" & Edittext1.Text & "',Null, 0, Listview1, True)

There is no need to post almost the same question in three different Threads.
Explain what you want to do in one thread and you will get a concrete answer.

Best regards.

 

Last edited: May 29, 2012

H

Hodi

Member

Licensed User

Longtime User

• May 29, 2012

• #3

Thanks Klaus - I will check this later.

Sorry for the double question in different treads but I wrote it from my mobile and it seams that it doesn't worked.

Thanks.
Hodi

 

I

Itila Tumer

Active Member

Licensed User

Longtime User

• Feb 24, 2014

• #4

I'd like to add a photo to DB
which is taken from Tablet Cam. which type should ı use ? text/blob/ .. . and how could ı take the photos from device after took a photo ?????

 

klaus

Expert

Licensed User

Longtime User

• Feb 24, 2014

• #5

Du solltest Deine Frage im englischen Questions Forum stellen.
Dies ist ein deutsch sprachiges Forum.

You should post this question in the english Questions forum !
You asked in the German forum.