no1see
Active Member
Hi,ALL
Can anyone tell me how to make this Simple SQL into ER
"SELECT SUM(SDUORG) FROM F4211 GROUP BY SDAN8,SDLITM,SDMCU"
I wanna know how to get SUM(SDUORG) in Tools Deverlopment.
P.S.
I know that
1st, I should Use Table I/O to SELECT
2nd,Use the Fetch Next
3rd,Use While to Fetch all the Records
....
But I can't do a SUM after Fetch the Records
EX. If I have 5 different [SDUORG] fetched ,how can I make this 5 [SDUORG] to do a SUM?
Can Anyone give a SAMPLE to convert this Simple SQL to a ER.
Thanks very much~~~
Can anyone tell me how to make this Simple SQL into ER
"SELECT SUM(SDUORG) FROM F4211 GROUP BY SDAN8,SDLITM,SDMCU"
I wanna know how to get SUM(SDUORG) in Tools Deverlopment.
P.S.
I know that
1st, I should Use Table I/O to SELECT
2nd,Use the Fetch Next
3rd,Use While to Fetch all the Records
....
But I can't do a SUM after Fetch the Records
EX. If I have 5 different [SDUORG] fetched ,how can I make this 5 [SDUORG] to do a SUM?
Can Anyone give a SAMPLE to convert this Simple SQL to a ER.
Thanks very much~~~