Dandy-Dev
(Dandy-Dev)
October 3, 2021, 7:39am
#1
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 **
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
Dandy-Dev
(Dandy-Dev)
October 3, 2021, 1:16pm
#4
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.
Dandy-Dev
(Dandy-Dev)
October 3, 2021, 1:19pm
#5
this’s a query.
this’s a result when my app runing.
Taifun
October 3, 2021, 1:37pm
#6
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
Rogerio_Rios
(Professional Support)
October 3, 2021, 1:43pm
#7
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
And search in comunnity…
1 Like
Dandy-Dev
(Dandy-Dev)
October 3, 2021, 1:57pm
#8
thank you!
this’s my blcok code. my app resolved.
Rogerio_Rios
(Professional Support)
October 3, 2021, 2:03pm
#9
Please post the solution (which you got here in the community) as your solution will help others.
2 Likes