Questions about Delphi visual component DBGrid might have this tag.
Questions tagged [dbgrid]
236 questions
0
votes
1 answer
How set element align half all form in Delphi 7?
Hello I create a form and put into the form two DBGrid. And set align Left to right of both. When i run the program and maximized window DBGrid width not changing. what i need to change width both of DBGrid to 50% of window?
![](../../users/profiles/1763000.webp)
iProgrammer
- 97
- 1
- 11
0
votes
1 answer
how to display to a dbgrid my query in this code?
hello is it possible for this code to display to a tdbgrid the search results in a list like style? (e.g. if i searched for john, all the data conataining john on a certain field will be displayed to the tdbgrid)
procedure…
![](../../users/profiles/2176698.webp)
Chunk Chunk
- 123
- 5
- 17
0
votes
0 answers
Keyboard language changes to default when editing a dbgrid with Delphi XE2
Default input language in Windows is English US. If you change to another language (in my case Greek) and then try to edit a cell on a dbgrid it automatically changes to default (English) either just by positioning the mouse on the cell or after…
![](../../users/profiles/2267406.webp)
Damien
- 1
0
votes
1 answer
Delete and refresh a record in DBgrid where u maintain the same position
I have a small database I'm using dbgo, I have a DBgrid displaying my records, I need to know how to delete a record and refresh the database where the index arrow stays in the same position or at least go to the next? but currently my index arrow…
![](../../users/profiles/1336118.webp)
Dreamer64
- 754
- 1
- 11
- 25
0
votes
1 answer
Delphi Edit DBGrid and Update Database in Read Only Mode?
So I have a DBGrid filled with an SQL query. I want the query to be read only so the table isn't locked up while the program is running. The problem is when it is set to read only I can't edit the table at all.
What I want to do is be able to edit…
![](../../users/profiles/1970794.webp)
user1970794
- 223
- 3
- 14
0
votes
1 answer
Error when you change the order of columns in Dbgrid
I wrote the code for the form rendering settings database table Dbgrid in another form. It depends on the selected items are defined Chetsklistboks visible columns in Dbgrid. I also wrote the code to move with drag & drop items and columns…
![](../../users/profiles/1851132.webp)
user1851132
- 241
- 1
- 4
- 15
0
votes
1 answer
How to fix owner draw anomaly in DBGrid?
Continuing with the project started in:
How to auto fit/scale DBGrid's (or other similar) columns widths according to its contents?
I used the @alzaimar answer to auto fit the columns according to their content width, but he showed me how to…
![](../../users/profiles/1062933.webp)
Please_Dont_Bully_Me_SO_Lords
- 7,193
- 15
- 68
- 136
0
votes
2 answers
Editable DBGrid?
I am a beginner in Delphi and I need help with the following problem. I have to implement an editable DBGrid on my form. The DBGrid displays results from a query joining 3 tables. I managed to make the DBGrid editable but the edits have no effect on…
![](../../users/profiles/1677227.webp)
Rick77
- 241
- 3
- 19
0
votes
2 answers
Java DB grid component that allows to save/load column layout
Could you please suggest database grid component that allows to save or load column layout (things like sequence, names, width) to/from files.
I am also interested in an approach that would allow to implement this functionality using standard…
![](../../users/profiles/507960.webp)
Cybex
- 301
- 3
- 20
0
votes
1 answer
Select field from dbgrid
I have a DBGrid that is linked to DataSource (that is linked to TADOTable). All this runs through a TADOConnection and connects to a MS Access
The grid contains various values and I would like to edit it when I click on a specific field.
I'm not…
![](../../users/profiles/1524774.webp)
coder123
- 67
- 4
- 10
0
votes
1 answer
how to show parent category in delphi 2010?
OK, I'm using Embarcadero Delphi 2010. Currently I'm using an Access database file named flib.mdb within that file, I make a table named MCategory which has 4 (four) columns named: codecategory as Text and Primary Key, parentcategory as Text,…
![](../../users/profiles/1044601.webp)
Galvion
- 1,253
- 6
- 21
- 33
-1
votes
2 answers
delphi DBGrid display JOIN results
I am working with BDS 2006,MySQL DB (MyDAC components used for connection) and i have a DBGrid component on my form which displays the records from my DB table.
Now i need to JOIN two tables and display the results in my DBGrid
The Resulting view…
![](../../users/profiles/944738.webp)
Shirish11
- 1,517
- 2
- 16
- 37
-1
votes
1 answer
DBGrid / DataSet fails to sort as per sql statement set in CommandText
I'm using the following in my CommandText property of the DataSet I'm using:
SELECT *
FROM table_name
ORDER BY FIELD(priority, 'urgent', 'normal'),
FIELD(state, 'wait', 'executed', 'done')
It should sort the data I'm displaying in the…
![](../../users/profiles/6917318.webp)
t1f
- 2,546
- 3
- 22
- 47
-1
votes
1 answer
Delphi - Using DBGrid to select rows from a search
I have searched a database using a query.
The results of the search are displayed in a DBGrid component for the user to select the row s/he wishes to proceed with.
DBGrid always sets the record pointer to the first record in the results set, so…
![](../../users/profiles/451790.webp)
David Kinraid
- 1
- 1
- 1
-1
votes
1 answer
How do I display values in a DBGrid that are different from those in the database?
PROBLEM
I have DBGdrid and there are columns what show ID's from an MS Access database. How can I change them to real values like item name, client name, employee name?
I have code (test code, I just tried to get all items names from table and I…
![](../../users/profiles/4879361.webp)
Rinalds Gudriks
- 65
- 1
- 12