Search options (Page 1 of 2)

Hello Dimtry,

thanks for the sample. The search seems to work. Do you solve this via script. Can I delete the search field and button above the tablegrid2?
Regrettably the sorting is still switching back to something after a few seconds in both grids. :-(

Any chance to fix the sorting by cklicking the column header?

Cheers
gieri

Hello Dmitry,

also another behavior which I can´t solve.
When I search something, the Search is  configured that both Grids are involved. But when I search something, the TableGrid2 gets no hit but the content is there.

Also the sort in TableGrid2 get lost after a few seconds. I sort by Name (click on the column head) and after 3 Seconds the list is mixed up

Cheers

gieri

Hello Dmitry,

found out that the TabelGrid1  also lost its column order when I type something into the search. Suddenly all Columns are shown.

Cheers

gieri

Hello Dmitry,

sorry, just still have a little issue :-(
I display not all Columns in my TableGrid1 (above) and sort the grid Descending on the column ".added".

On the first start of the app, everything looks good. When I make a Mouse click into the TableGrid2 (below). The TableGrid1 is mixed up, lose the sorting and all hided Columns are displayed. How can I fix this?

Also the Column width is lost very often. Is there a parameter where I can make the Column width fix?

Project zip attached.

Cheers

gieri

Hello Dmitry,

just have a quick question how to get the update thing to the other tablegrid in my DB?
The scriptcode just have TableGrid1, but I have the other Grid with TableGrid2 in the same window. Is it possible to update both grids at the same time?

Cheers

gieri

Hello Dmitry,

thanks for the file. The refresh works now very good. Regrettably after a refresh, the table focus jumps to the first entry.
So if you have for example 50 entries, after 5 second the table view jumps to the first.

Is there any chance to fix this?

cheers

gieri

Hello Dimitry,

thanks for the sample. In fact of I don´t have any clue how to work with scripts, I don´t know if I can add you code to my existing code which I need to get a multiselction of the rows.

Current it looks like this:

procedure Form1_Button3_OnClick (Sender: string; var Cancel: boolean);
var
   i,c: integer;
   iColumn: integer;
begin
   iColumn := Form1.tablegrid1.Columns.Count-1; // in last column stored id of record (last column hided)
   c := Form1.tablegrid1.RowCount - 1; // count of records in TableGrid
   for i :=0 to c do
     if Form1.tablegrid1.Selected[i] then // if record selected
        SQLExecute('DELETE FROM retoure WHERE id = ' + Form1.tablegrid1.Cells[iColumn, i]); // SQL query for selected record
   form1.tablegrid1.dbUpdate;
end;

begin
   form1.TableGrid1.Options := form1.TableGrid1.Options + goMultiSelect;
end.

var
   Timer: TTimer;

procedure Form1_OnShow (Sender: string; Action: string);
begin
     Timer := TTimer.Create (nil);
     Timer.OnTimer := @OnTimer;
     Timer.Interval := 5000; // every 5 sec
     Timer.Enabled := True;

end;

procedure OnTimer;
begin
     Form1.tablegrid1.dbUpdate;
end;

procedure Form1_OnClose (Sender: string; Action: string);
begin
     Timer.Free;
end;

but it doesn´t work.

What have I made wrong here?

cheers

gieri

Hello derek,
that´s awsome!! Thanks a lot for your help.

I use in TableGrid1 in the Footer (Count) the Label Text before "Summe:X"
In TableGrid2 in the Footer (Count) the Label Text before "Erledigt:X"

When I click in TableGrid2, the Text before in TableGrid1desapears and only the counted number is left there. When I close and open the App again, the "Text before" Counter in TableGrid1 is back again. I think this is more like a bug, isn´t it?

Can define the Style which I use for the Heads also to the footer? Office210 for example?

cheers

gieri

Hello Tcoton,

see attached. As I mentioned, If you have a bunch of entries and you click on one, all other entries disappear. May something is wrong in fact of the script code?

Also the list of the grid doesn´t update automatically. I have to push the Search button twice to see the whole list.

Just on little question left, how could I crate a counter which shows how many entries are in the list.

Cheers

gieri