mORMot Open Source

lele9

Member

Registered: 2011-10-28

Posts: 170

tadvstringgrid and filter

hi,
i have an instance of TSQLTableToGrid with tadvstringgrid from tms.
if i try to realize a narrowdown filter like this example:
http://www.tmssoftware.com/site/asg78.asp
Filter empty the grid.

I try to fill the grid by hand from TSQLTableJSON and filter work great!

I would like to use TSQLTableToGrid, any solution?
thanks,
Emanuele.

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,660

Website

Re: tadvstringgrid and filter

As was already answered to you in http://synopse.info/forum/viewtopic.php?id=586, the TSQLTableToGrid  expect a plain TDrawGrid instance, and won't work with TAdvStringGrid.

The TAdvStringGrid from TMS did override some methods, so it won't work directly with TSQLTableToGrid.

The newly added FillStringGrid() function is ready to fill a regular TStringGrid just like TAdvStringGrid.
See http://synopse.info/fossil/info/2af8e888d3

Of course, the issue is that you can't have access to the advanced features of TSQLTableToGrid (like key lookup incremental search - with soundex, very fast sorting, on the fly Unicode display of the content...). But I do not see TSQLTableToGrid with TAdvStringGrid, except by overriding TAdvStringGrid methods with TSQLTable methods for on the fly display or quick sort: this is possible by using the TAdvStringGrid in virtual mode, but it out of scope of our framework. You'll have to ask TMS support for this.

lele9

Member

Registered: 2011-10-28

Posts: 170

Re: tadvstringgrid and filter

im sorry you are right!