Delphi 7.
SDAC 3.70.0.24
I use a TMSTable as a master lets call it table A, a TMSTable as a detail lets call it table B, but I also have another TMSTable unlinked that points to the same DB table as table B. Now the unlinked TMSTable works fine, but the detail table shows the detail records as entries, but without any actual data in them. Ie the grid shows 2 rows of empty data. I use the CRDBGrid that came with the SDAC version stated above.
Please advise. I have used this technique in the past a number of times but now it seems to bug. Also it seems like some sort of "reset" to the engine must be made in order for it to work properly. I dont know if this makes sense but i would love to hear from you. Please dont ask me to replicate the problem, as it wont happen on an empty datamodule with just 3 components on it. If however it is something you have come across, please help
Problem with Master Detail Tables
Ok I tried what you said to no avail, and after a lot of head-banging I had an idea, to change the grid to the regular one (VCL) and voila!! It works. So my guess is there is either a bug with CRDBGrid, or some setting has to be altered for some reason? Please advise
Edit: Ok seems that was not so accurate after all. Seems that the grid is not bugged, because changing back to it everything works fine again. It is a bit odd though. I cant understand why this happened in the first place.
Edit: Ok seems that was not so accurate after all. Seems that the grid is not bugged, because changing back to it everything works fine again. It is a bit odd though. I cant understand why this happened in the first place.
The information you have provided is not enough to determine the reason of this behaviour. I have no idea except incorrectly created columns in the grid at design time. When you reproduce this problem with CRDBGrid again, you can send me at evgeniyd*crlab*com a complete small sample to demonstrate it, including script to create and fill table.