How can I force the TBDGrid to show data?

I have a TBDGrid, when a user input an item no. at column 1, its description will be displayed.
For each item, it may or may not have the accessories.
How can the accessories data to be added to the same grid ?
yyjulieAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
terencebehConnect With a Mentor Commented:
Well, you can use the dbgrid as AddItem Mode. And you will need some coding when you want to save the data. Example, loop through every row in the grid and update your database.
0
 
terencebehCommented:
You can use the same procedure that you are filling the description to display the value.

Or, alternatively, write a procedure to retrieve the accessories from the database and use:
dbg.columns("accessories").value = ???

0
 
yyjulieAuthor Commented:
However, the accessory data should be added to the next row (not the same row) of the grid.  What can i do?
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
terencebehCommented:
in that case you use the dbgrid.movenext to fill in the next row for the accesories.
0
 
yyjulieAuthor Commented:
Or let me to describe my situation clearer.

I have a form for borrowing computer hardware.
Within the form, it contains the master data. and a TDBGrid (unbound extended mode)  for detail data, i.e. the borrowed item, e.g. printer.

for each item, it may or may not have accessories, e.g. printer cable.

if a user input the item no. in the grid, its description will be displayed, at the same time, if the item has accessories, the accessories data will be shown in the following rows.

How can i do that?



0
 
clifABBCommented:
If I understand, basically you want a tree view.

Would it be possible to use the Treeview control instead of a grid?

Another choice, which I have done in the past, it to have a second grid (hidden until needed) which acts like a dropdown list for whatever item you select on the main list.
0
 
yyjulieAuthor Commented:
Thank you, it's a great hint.


0
 
yyjulieAuthor Commented:
In fact, I have a question, is it possible that the data is saved only when a user press a command button after filling in data to the grid as he/she like.

I don't want the data immediately be updated or inserted by the unboundAddData event.

Can I use an array as the buffer to store the user's input, and then save the array to the database after pressing a command button? Is it a stupid way? Or is there already a method used in True DBGrid which can provide the same effect?
0
 
yyjulieAuthor Commented:
I've got an idea,  we can use XArray.
0
All Courses

From novice to tech pro — start learning today.