Autocomplete from SQL Database

[heejit]

Is there any widget or a way to autocomplete data from sql database.

I have 10,000+ items in sql database.

I want user to type few letter on press of Enter key display filtered list of item fro typed letters so user can select the appropriate item.

[kkoreilly]

You could fetch all the items and then use a Chooser with SetEditable(true) and those items; see the choosers page.

[kkoreilly]

Have you considered using text editors? You could use that to replicate the same SQL input thing you described above.

[heejit]

It is not full sql input just the argument something like this

select id,nm from items where nm like '%TextEditor.Text%'

[heejit]

Autocomplete like in E-Commerce websites

[kkoreilly]

You could trying using an Editable Chooser and then change the Chooser.Items in OnInput based on the current ch.ChildByName("text-field").(*core.TextField).Text() using your SQL query.

[heejit]

Let me try it