German DBUtils / How to show in Listview

[Hodi]

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]

No, you should use:

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.

 

[Hodi]

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

 

[Itila Tumer]

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]

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.