Question, data show a record of sqlite

[marbellapc]

The problem is that I have created in sqlite3 db, works well in the ListView shows me the records with the product name, but when I click on a record, I always display them last data record in the list when I click on the ListView.

Sub ListView1_ItemClick (Position As Int, Value As Object)
   RemoveViews
   Activity.LoadLayout("Product")
   ItemSelected = Value
   
   Label_Titulo.Text         = Cur.GetString("Titulo")
   Label_Fecha.Text          = Cur.GetString("Fecha")
   ImageView_Foto.Bitmap     = LoadBitmap(File.DirAssets, Cur.GetString("Imagen")) ' Pruebas de imagen
   Label_Producto.Text       = Cur.GetString("Producto")
   Label_Localidad.Text      = Cur.GetString("Localidad")

    End Sub

I changed several times how to do the query but without success, keeps giving the data of the last record of the list of ListView.

Sub ListView1_ItemClick (Position As Int, Value As Object)
   RemoveViews
   Activity.LoadLayout("Product")
   ItemSelected = Value

    Cur = SQL1.ExecQuery("SELECT Titulo, Imagen, Localidad, Producto, Fecha, Ingredientes, Proceso FROM Countries")
 For i = 0 To Cur.RowCount - 1
    Cur.Position = i
   Label_Titulo.Text         = Cur.GetString("Titulo")
    Label_Fecha.Text         = Cur.GetString("Fecha")
   ImageView_Foto.Bitmap     = LoadBitmap(File.DirAssets, Cur.GetString("Imagen"))
   Label_Producto.Text       = Cur.GetString("Producto")
   Label_Localidad.Text      = Cur.GetString("Localidad")
 Next
'    Cur.Close
End Sub

I have relied on the example of jpvniekerk, but can not get the labels show the data for the record down.
http://www.b4x.com/forum/basic4andr...arebones-view-examples-sqlite.html#post120915

I hope you can help me out and guide me in what I'm doing wrong.

Greetings and thanks in advance

 

[klaus]

You didn't include the database in your zip file.

Best regards.

 

[mc73]

Why see you looping inside the click? You should set the cursor position to the selected ID and get its data. Haven't checked your code, so please disregard my message if what I saw was just 'bad' copy-paste.

 

[Mahares]

Replace this line:

Cur = SQL1.ExecQuery("SELECT Titulo, Imagen, Localidad, Producto, Fecha, Ingredientes, Proceso FROM Countries"

with this line: You will be good to go.

Cur = SQL1.ExecQuery("SELECT Titulo, Imagen, Localidad, Producto, Fecha, Ingredientes, Proceso FROM Countries" _
   & " WHERE Titulo= '" & ItemSelected & "'" )

 

[marbellapc]

Klaus, the database is within the zip file if File folder.

Mahares, perfect, I had not thought of that, had tested

Cur = SQL1.ExecQuery("SELECT Titulo, Imagen, Localidad, Producto, Fecha, Ingredientes, Proceso FROM Countries WHERE ID= " & ItemSelected)

And kept giving clear error, but change it so I've put, wow, perfect.

Thank you very much to all, you are the best, and you are always there for newbies like me, Greetings

and again thank you very much

 

[klaus]

Hi marbellapc,

Sorry, I expected finding the database in the Files Tab in the IDE.
I didn't look in the Files directory.

I played a bit with your program, below some comments:
You can repalce these lines
SQLText = "SELECT * FROM Countries ORDER by Titulo"
by this.
SQLText = "SELECT Titulo FROM Countries ORDER by Titulo"
As you display only the Titulo column no need to read all the rest.

Here you can replace
Cur = SQL1.ExecQuery("SELECT Titulo, Imagen, Localidad, Producto, Fecha, Ingredientes, Proceso FROM ...
by
Cur = SQL1.ExecQuery("SELECT * FROM ...
because you read all columns.

Attached the modified version.

Best regards.

 

[marbellapc]

Hello Klaus,
You're absolutely right, I have to change sqlite statements and further optimize the code to leave cleaner.

I focused on how to display the records and pay no attention to those details.

best Regards

And thank you very much for your advice and help

 

[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]

Did you search in the forum ?
The two tutorials below should give you the solution.
Look at the SQLTutorial, ou should use Blob,
Look at this turorial Take picture with internal camera.

 

[Itila Tumer]

Can ı save in DB after took a photo. I am making ID Card,so that why need that

 

[klaus]

Did you have a look at the two tutorials in my previous post ?
This turorial Take picture with internal camera. shows how to take a picture
and this SQLTutorial how to save the picture to the DB.

 

[Itila Tumer]

Yes
thank you, but ı have trauble .Is that possible to send to my Table in my PERSON DB ? and read from it again

 

[klaus]

Yes.
You must add a column in the persons.db with BLOB type and add the images.

 

[Itila Tumer]

I mean
yes it works but
I want to make one program
and after took picture
, is that the same for sending Table Database

 

[Itila Tumer]

 

[klaus]

... is that the same for sending Table Database

What do you mean with this ?

 

[Itila Tumer]

I 'll make an effort a little bit more. if ı can not
İ'll tell you where I 'll take an error. Thanks

 

[Itila Tumer]

my main is how can I make a connection in table DB image with main shema /

 

[klaus]

I have never done this either, so I could give you only the principles.

As I don't know how you want to manage the database it's difficult to give concrete advices.
What is edtImage ?
If I understand your sketch, it's an edit screen where you should display the image if there exist one in the database.
With the button you can take an image and with another button update the database.

 

[Itila Tumer]

Thank you yes
ı was trying to describe it , could you help me about it?? I am quite beginner at this program .