這個循環怎么寫?

Question

我想將它插入到DBGrid中
   Pdline model_id work_order                    process           qty
    50007 50000014 2057005                             0            2
    50007 50000014 2057005                        500004            1
    50007 50000014 2057005                        500010            1
    50007 50000014 2057005                        500021            5
    50007 50000014 2057005                        500026            1
    50007 50000014 2057005                        500043            8
    50007 50000014 2057005                        500045            6
    50007 50000014 2057005                        500067           14
    50007 50000014 2057005                        500068         2486
    50007 50000014 2057171                             0           61
    50007 50000014 2057171                        500011            1
    50007 50000014 2057171                        500013            1
    50007 50000014 2057171                        500030            1
    50007 50000014 2057171                        500043            6
    50007 50000014 2057171                        500045            8
    50007 50000014 2057171                        500066            2
    50007 50000014 2057171                        500068         3347
輸出的格式為:
Pdline model_id work_order  500004 500010 500013 500021 500026 500043 500045 500066 500068
50007  50000014 2057005       2      1      0      5      1       8      6     0     2486
50007  50000014 2057171       0      0      1      0      0       6      8     2     3347

Answer 1

我想將它插入到DBGrid中
///如何插入DBGrid呢????插入StringGrid吧!!

Answer 2

以下是一個叫g_sn_status表中的記錄pdline(線別)﹐model_id(机种),work_order(工單)process(制程) qty(該制程的在制品數量)
   Pdline model_id work_order                    process           qty
    50007 50000014 2057005                             0            2
    50007 50000014 2057005                        500004            1
    50007 50000014 2057005                        500010            1
    50007 50000014 2057005                        500021            5
    50007 50000014 2057005                        500026            1
    50007 50000014 2057005                        500043            8
    50007 50000014 2057005                        500045            6
    50007 50000014 2057005                        500067           14
    50007 50000014 2057005                        500068         2486
    50007 50000014 2057171                             0           61
    50007 50000014 2057171                        500011            1
    50007 50000014 2057171                        500013            1
    50007 50000014 2057171                        500030            1
    50007 50000014 2057171                        500043            6
    50007 50000014 2057171                        500045            8
    50007 50000014 2057171                        500066            2
    50007 50000014 2057171                        500068         3347
我想把這些資料輸出到DBGrid的格式變成為下面的這种﹐也就是一個行轉列的問題:
Pdline model_id work_order  500004 500010 500013 500021 500026 500043 500045 500066 500068
50007  50000014 2057005       2      1      0      5      1       8      6     0     2486
50007  50000014 2057171       0      0      1      0      0       6      8     2     3347