forlano Messages: 1185 Registered: March 2006 Location: Italy
Senior Contributor
Hello,
I have a so weird wish that if nobody will answer I'll not complain .
I want to use the SqlArray with build in sqlite facilities, but the table consist of one only row with 12 fields. They are too many to be displayed horizontally but would be ok if the they were displayed vertically... just a transposition of column and row.
I wonder if there is a simply trick that do the job.
forlano Messages: 1185 Registered: March 2006 Location: Italy
Senior Contributor
sergeynikitin wrote on Fri, 12 August 2011 12:07
I use GridCtrl + my own Display class of header. Even place Images in header.
Like this ...
It is very nice. But I have not seen a SqlGrid control equivalent to SqlArray.
I would like to bind the data to the table and sqlarray looks perfect.
Now I am doing some test... EditCtrl in SqlArray via AddCtrl but the SqlArray is set to Hide().
forlano Messages: 1185 Registered: March 2006 Location: Italy
Senior Contributor
sergeynikitin wrote on Fri, 12 August 2011 14:41
Can you use custom Display() for HeaderCtrl?
It will be same way.
I used in the past Display() to customize background and font in columns and cells. But never tried with HeaderCtrl. I will look for examples in the forum as at the moment I have no idea how to display a row as a column.
Can you use custom Display() for HeaderCtrl?
It will be same way.
I used in the past Display() to customize background and font in columns and cells. But never tried with HeaderCtrl. I will look for examples in the forum as at the moment I have no idea how to display a row as a column.
Spasiba,
Luigi
HeaderCtrl tabs do not have Display (yet?).
But it should be possible to achieve what you want using the SetImage... Not very elegant, but possible
forlano Messages: 1185 Registered: March 2006 Location: Italy
Senior Contributor
mirek wrote on Sun, 28 August 2011 19:29
HeaderCtrl tabs do not have Display (yet?).
But it should be possible to achieve what you want using the SetImage... Not very elegant, but possible
Mirek
Any solution, even the weirdest, would be in this moment the most elegant.
That could be called SqlColumn ctrl useful to keep easily together the many variable stored in one row table.
I was thinking at these steps to modify the look of ArrayCtrl:
1) hide Header;
2) realize a two columns array with a row for each field of the one row table;
3) in the left column set via SetCtrl a button not clickable just to use its label and give us the look of the left header;
4) in each row of the right column set a proper ctrl.
5) collect all the values of the right column and send to the table.
Perhaps GridCtrl could be more useful with regard the left column that I should get for free.
I'll try to perform some test.
Are there better solution to use the built in capability of SqlArray?