Link to home
Start Free TrialLog in
Avatar of visionetv
visionetvFlag for United States of America

asked on

Displaying SQL data in rows with different cell lengths

Hello Experts;

Using Delphi 7 is there a component or method I can use to display data from a SQL database where the first nine fields are contained in one row and the tenth field is in a row below the first nine. The data display sequence repeats for additional rows except when the tenth field is null, then the next nine fields are displayed.

Inserting a row in a Tstringgrid doesn’t work because the text field has to be loaded into the first cell and can only be read by expanding the column width which hides the data in the nine columns above the single cell. A sketch of what I am trying to do is attached.

User generated imageThank you,
Visionetv
SOLUTION
Avatar of Sinisa Vuk
Sinisa Vuk
Flag of Croatia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of visionetv

ASKER

Hi Sinisa Vuk

Thank you for the tips, I'll try out your suggestions.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you for the component information.