hi all,
I have a problem on prodataset sorting when Fill() into the tttempTable.
because the data return will base on tttemptable 's "index". therefore,
not matter how i do the "By" (sorting) in pc_query. the result also will base
on temp-table 's "index".
DEFINE TEMP-TABLE tttempTable LIKE acp_bank .
DEFINE QUERY queryTable FOR acp_bank SCROLLING.
DEFINE DATASET progressDataset FOR tttempTable.
DEFINE INPUT PARAMETER pc_query AS CHARACTER NO-UNDO.
DEFINE OUTPUT PARAMETER DATASET FOR progressDataset.
DEFINE OUTPUT PARAMETER pc_msg AS CHARACTER NO-UNDO.
QUERY queryTable:QUERY-PREPARE(pc_query).
DEFINE DATA-SOURCE dataSourceTable FOR QUERY queryTable.
BUFFER tttempTable:HANDLE:ATTACH-DATA-SOURCE(DATA-SOURCE dataSourceTable:HANDLE).
DATASET progressDataset:FILL().
I have a problem on prodataset sorting when Fill() into the tttempTable.
because the data return will base on tttemptable 's "index". therefore,
not matter how i do the "By" (sorting) in pc_query. the result also will base
on temp-table 's "index".
DEFINE TEMP-TABLE tttempTable LIKE acp_bank .
DEFINE QUERY queryTable FOR acp_bank SCROLLING.
DEFINE DATASET progressDataset FOR tttempTable.
DEFINE INPUT PARAMETER pc_query AS CHARACTER NO-UNDO.
DEFINE OUTPUT PARAMETER DATASET FOR progressDataset.
DEFINE OUTPUT PARAMETER pc_msg AS CHARACTER NO-UNDO.
QUERY queryTable:QUERY-PREPARE(pc_query).
DEFINE DATA-SOURCE dataSourceTable FOR QUERY queryTable.
BUFFER tttempTable:HANDLE:ATTACH-DATA-SOURCE(DATA-SOURCE dataSourceTable:HANDLE).
DATASET progressDataset:FILL().