AutoComplete Lookup fields OR DBGrid embedded DBLookUpComboBox
lazarus / 16-Databases

----------------------------------------------------------------------
JZS · 2014-04-10 13:46

Hi all,

Is it possible to make Lookup fields AutoComplete?

My requirement description:

I am forced to use SpreadSheet style (not by choice!) so I have to
include DropDownList in on of the columns of a DBGrid (possibility to
have more than one column) and the user has to start typing until
match is found otherwise the data shall not get posted.

I had several tries on attaching DBLookUpComboBox on the desired
column of DBGrid, but had difficulties in the functionality. Generally
hard to maintain usability to be nice and friendly.

So finally I tried LookUp fields, it's nice and it saves OK, but one
thing that is missing AutoComplete.
It's a must to have AutoComplete as a feature.

So what am after is, a way to have AutoComplete Lookup field. Or nice
embedding of DBLookUpComboBox in DBGrid.

Any ideas,

Thanks in advance.

I use Laz1.2 on Win32 with Standard sqldb/mysql ctrls.

----------------------------------------------------------------------
mangakissa · 2014-04-10 19:54

Jedi has a TjvLookupcombo, which has this ability. But not for
Lazarus/FPC.
RXLib has basic the same Lookupcombobox (should be). RXLib is the
earlier version of Jedi.

My only problem was; crashing when I tried to select a value in the
box.

----------------------------------------------------------------------
taazz · 2014-04-10 20:08

Quote from: mangakissa on April 10, 2014, 09:54:45 pmRXLib is the
earlier version of Jedi.

that is false, JEDI started up small with jcl and then a number of
contribution where made including multiple suits and a lot of smaller
single components. After JEDI had enough momentum to sustain it self
as a library the RX contribution came after the library was left
unattented for a few years. So RX parts are in JEDI library but JEDI
has its own history and standing and can not be considered as the RX
evolution.

----------------------------------------------------------------------
JZS · 2014-04-11 00:26

Quote from: mangakissa on April 10, 2014, 09:54:45 pmRXLib has basic
the same Lookupcombobox (should be).

Tried RXLib, its DBLookUpCombo doesn't interact smoothly as Lazarus'
does. Even it has the same issue.

Quote from: mangakissa on April 10, 2014, 09:54:45 pmMy only problem
was; crashing when I tried to select a value in the box.
Users will be selecting values from the box 
I do not want that to be my only problem.

I can not move toward potential catastrophic stage and start all over
again.

I prefer Laz default components unless another sufficient
solution/component(s) exist.

----------------------------------------------------------------------
mse · 2014-04-11 06:44

Quote from: JZS on April 11, 2014, 02:26:16 amI prefer Laz default
components unless another sufficient solution/component(s) exist.
Just for inspiration: MSEgui has tdbwidgetgrid where any edit wiget
can be inserted in order to build a data column. For miscellaneous
lookup tasks there are tdbdropdownlistedit, tdbdropdownlisteditdb,
tdbenumedit, tdbenumeditdb, tdbenumeditlb, tdbenum64editdb,
tdbenum64editlb, tdbkeystringedit, tdbkeystringeditdb,
tdbkeystringeditlb, tdropdownlisteditdb..., all with "auto
completion"  facility.

----------------------------------------------------------------------
JZS · 2014-04-12 13:17

Quote from: mse on April 11, 2014, 08:44:30 amMSEgui
Sounds interesting, downloaded, waiting to have time for exploring.

@mangakissa,
Interesting package (i.e. RXLib) but seems like I will go with the way
of avoid troubles.
Probably avoiding the whole idea of SpreadSheet style and enforce my
point of view.

Thank you all.