SQL Query result to a matrix:

-
SQL Query result to a matrix:

I need way to show on a form a SQL query result in a form of matrix.
What do you suggest, how to achive this?


Example:
result of query:

|Empl. |State |Date |Classroom|
---------------------------------------------
Ivan England 19.02.2017 C1
Marko Germany 19.02.2017 C2
Henrry England 19.02.2017 C3
Daniel Hungary 20.02.2017 C7
John USA 21.02.2017 C9
Ivan England 22.02.2017 B5
.
.
.

I need to show this on a app. form (VCL) in next format:

| 19.02.2017 | 20.02.2017 | 21.02.2017 | 22.02.2017 |
---------------------------------------------------------------------
Ivan | England | C1 | X | X | B5 |
Henrry | England | C1 | X | X | X |
Marko | Germany| C2 | X | X | X |
Daniel | Hungary | X | C7 | X | X |
John | USA | X | X | C9 | X |

It should look as planer.
Any Idea?

With best regards
Tom

Comments

  1. Tomislav SalarFebruary 20, 2017 at 9:41 AM

    David Berneda
    Ok... I would like to try it...
    Where I can download it? My project is not commercial (still...)...
    I use Berlin Starter version...

    With best regards
    Tom

    ReplyDelete
  2. David BernedaFebruary 20, 2017 at 10:10 AM

    oops, TeeBI installer does not work with Starter version, because the Starter version compilers cannot be called from other processes (command line) so all packages must be opened and installed manually.

    Anyway if you want to download the sources and try the installation, the url is: http://www.steebi.com/files/code/beta/vcl_fmx/

    ReplyDelete
  3. Tomislav SalarFebruary 21, 2017 at 6:15 AM

    David Berneda I don't think that this will work... They use a FireDAC component which is not included in a Starter...

    ReplyDelete

Post a Comment