sqlite sorting

[dennishea]

Help I can't seem to wrap my brain around sorting. If I have data in a colume that looks like this.

Mach
-----

Tht2d
Tht3
Twf4
T-I20

When I enter txt like Tht in txtbox I would like to load Tht2d and Tht3 in table, not twf4 and T-I20 or if I load txtbox with Twf4 that is all I want to show up in table. I can't seem to figure out how to enter partial data and match up with data in database. Any help would be appreciated.

denny

 

[BjornF]

You can do it using wildcards (e.g. *).

either with a table filter on the "local" table, e.g. Table1.Filter("FirstColumnContent LIKE 'tht*'"), or alternatively you could do a query to the SQLite database e.g. "SELECT * FROM MainTable WHERE FirstColumnContent LIKE 'tht*'"

all the best / Björn

 

[Hennell]

alternatively you could do a query to the SQLite database e.g. "SELECT * FROM MainTable WHERE FirstColumnContent LIKE 'tht*'"

For some reason in SQLite the * wildcard is actually a %, so the command should be:

"SELECT * FROM MainTable WHERE FirstColumnContent LIKE 'tht%'"

This works best with the cmd.setparameter feature as you can add the '%' in within the code:

cmd.SetParameter("Search","%" & tbxSearch.Text & "%")
cmd.CommandText = "SELECT * FROM MainTable WHERE FirstColumnContent LIKE @Search"

 

[dennishea]

Thanks BjornF and Hennell for your responses. I now am back out of the quag myer and progressing again. Thanks again to both of you for your help.

:sign0188:

dennishea :sign0060: