Large datasets, millions of records, need special programming to maintain speed in DBGrids. I want to know if there are any ready-made components for Delphi (DBGrids) that do this automatically? EDIT For Example: Some databases have features such as fetch 1st X records (eg 100 records). When I reach the bottom with scrolling, I want t...
I am using a DBGrid component in delphi. I wonder how I can set the format of a column. I have real values that I want to be displayed as currency in the grid. Someone knows how? ...
I have a DBGrid on a form. The DBGrid has many columns, so an horizontal scroller is displayed. I scroll the DBGrid view to the right to see more columns. If I select a row, the DBGrid view is automatically reset to view the first column (As if I scroll back to the left most position). Is there a way to prevent that? ...
Hello I want to give 3 options for a column in a DBGrid. How to achieve this. How to drop and incorporate a combobox for the same in dbgrid. regards sridhar ...
Well, this seems a little tricky (if not imposible). I'm tryin to make my DBGrid sort its data by clicking on column's title. The thing is that I'm (sadly) working with Delphi3, I'm not using ADO DataSets and the query gets a lot of rows, thus I can't reopen my TQuery changing the "order by" clause on clicks. Someone has implemented so...
I gave up on Delphi's DBGrid nearly a decade ago because it is simply no good. Since then, I have used Virtual TreeView which offers a lot of value but it has a few issues. Like the current state of development (e.g. None) and the fact that there is no good data-bound version. DevExpress's QuantumGrid is famous for the rich feature set b...
I'm working with delphi2009 and i really need to create a button that can print all my data in a dbgrid. I appreciate all the help i can get. ...
Well I have an issue with DBGrid vertical scrolling. When I scroll it vertically with mousewheel or vertical scrollbar it moves selected row up and down. I want to make it scroll not selected row but entire grid. Just like it works in Microsoft Excel for example (just to let you know what I mean). Any suggestions? ...
Although the question seems simple, I couldn't find the answer to it. I have a DBGrid component with lots of columns, and as a result they don't fit into the page and scrollbar appears. I also have column-autofix mechanism, which makes each column have width of the longest element in the table. When I scroll DBGrid to the right-end the...
Hi, Having tried VCLSkin from http://link-rank.com, i came to an issue where column header skin didn't work on TStringGrid descendants including TDBGrid. I want it to display header similar like TListView colum header in report mode. Anyone has code to solve this problem? PS: already looked http://andy.jgknet.de/blog/?page%5Fid=206, ...
Well, some kind of n00b question from me. I've surfed the net and similar questions here but haven't found any right answers for such simple (as I thought) problem. I have a DBGrid. I select one row and make some actions with another data linked to this row. After I finished, my DBGrid being refreshed and selected row resets to first. I...
I have a grid component (DBGrid) which has lots of columns on it. Because of large number of columns, a scrollbar was created, and thus some part of grid remains hidden. I need to find out what is the real width of DBGrid, including the part which is not shown due to scroll bar. But Width property gives only the width of the component it...
I have a DBGrid, I need to run some code, each time the horizontal scrollbar is used. I couldn't find such event in DBGrid. Can you advise something? ...
i need to get the value of the selected cell of a DBGrid in Delphi (i have no idea how to do it, i tryed dbGrid's OnMouseMove pt : TGridCoord; ... pt:=dbGrid.MouseCoord(x, y); ) [Edited] I can use the OnCellClick to get the value of the cell with "Column.Field.AsString", but i want to get the value from the first column when i click on...
I need to dynamically change position of certain column in DBGRid. Let's say I need to place column number 21 on position 10. I use: DBGrid.Columns[21].Index:=10; But, this also changes the array itself, that means, that next time I want to access this column, I will need to write DBGrid.Columns[10], this makes it a little unclean, I ...
how to search dbgrid column with query not table ...
I'm working on converting the codebase of an "open-source" project to something that will actually work. I put the term in quotes because what the original authors did was take a commercial product and say "OK, we've made enough money off this now. Here's the source code. Do whatever you'd like to with it." Unfortunately, the codebas...
Hi, this is my third question here, so far excellent responses ^^ I'm having no problems in browsing, editing the data, but insertions... Here is my doubt: In a finance/stock software i have a form to create a new order, naturally i need to insert a new row in t_orders table and insert items in t_orderitems table with orderId field lin...
I need to refresh dbgrid constantly, in real time. Close and open dataset works fine, but blink the dbgrid. What can I do to avoid this? I'd like a solution like Ajax, that update only the necessary. Thanks ...
Is it possible? How? ...