How resolve sqlite field contained in one Index

Hi Dear,

currently i’m working on a project home to control the items in the store and in this application i use sqlite as storage, lapse of time running i found a bug of kind in sqlite, when i retrieve data there are fields that are joined in one index.

For Example :

**CREATE TABLE **

Screenshot_2

blocks

when i select index 7, Tags field and tglHari field contained.

this’s a result when i select index number 7 :

strong text

I think we are unable to understand your query. You are getting wrong value in index 7 or correct value ??

1 Like

I got the worng value.

underline in the picture is the 7th index value which displays two data at once.

this is a schema table.
Screenshot_2

this’s a query.
blocks

this’s a result when my app runing.

How does your select statement look like?
What do you get if you send the following statement to the database?

SELECT Tags FROM database_01
WHERE idBarcode= 123456789

How do you insert the data into the table?
Taifun

2 Likes

SQLite works with SQL commands.
Then you will have to use the Component Sqlite blocks and execute the Select command as Taifun mentioned.

Please Read
:point_down:

And search in comunnity…:+1:

1 Like

thank you!

this’s my blcok code. my app resolved.

Please post the solution (which you got here in the community) as your solution will help others.
:+1:

2 Likes