How can i show my SQLite data in textbox or label column wise

Discuss
, , , , ,
#9

If you can, show the summary (not necessarily your blocks) of how you solved it. It will be useful in helping others.

1 Like
#10

This is the solution. but now i want LIKE statement (not case sensitive) in SQLite for searching
anybody help me for that
Untitled

#11

Select with the Where like clause,?

#12

Select yourfield1,yourfield2 FROM yourtable Where yourfield1 like variable%
Or %variable or %variable%

They are just examples.

Find :
1-all starting with the content of the variable
Variable = Jo
Return = João , José , Jonh ,Joana , Joelson
2-all that end with the value of the variable
variable = Ana
Return= Liana , Joana , Fabiana
3-all containing the value of the variable in any position
variable = Silva
Return = João da Silva, Carlos da Silva Fernandes, André Silva Souza Tavares

1 Like
#13

i tried like that but its not working
please share blocks for this example

#14

only this statement is working…

select id, name, mobile from tb_client where name like?

#15

After the like you should put the value you want to search for in SqlLite. It can be a variable that received the value of a textbox’s TEXT property or the textbox’s TEXT property itself.
select id, name, mobile from tb_client where name like textbox.tex+join+% ( example )

1 Like
#16

see what i did… its not working. what is wrong here

Untitled
Untitled791×253 15.2 KB

or if you have any idea how to filter search in dynamic list
if SQLite command not good for searching then i’ll go with dynamic list search so give me an example for searching SQLite or dynamic list

#17

Good Morning
1- I can’t see your entire Select command .
2- Remove the + sign, leave only the% sign.
Try…

1 Like
#18

select id, name, mobile from tb_client where name like
but not working

#19

select id, name, mobile from tb_client where name like %search
Or
select id, name, mobile from tb_client where name like search%

Please check the contents of the search variable.

How can filter or search in SQLite with Like Statement
#20

Untitled
Untitled791×253 15.2 KB

see what i did… its not working. what is wrong here
or if you have any idea how to filter search in dynamic list
if SQLite command not good for searching then i’ll go with dynamic list search so give me an example for searching SQLite or dynamic list

1 Like
#21

Again that question? I answered you …
Did you Read and Try ?

#22
1 Like
#23

I now joined the 2 threads…
Taifun

#24

thanks my friend
its working

#25

sorry for the mistake to post 2 times

#26

Don’t forget to check Resolved in my tip. :grin:

#28

You have already created your post. Delete this message.

#30