如何获得sql查询结果问题？再线等

Question

如何获得sql查询结果问题？再线等例如
MC_DM.tempquery.Active := false;
MC_DM.tempquery.SQL.Clear;
MC_DM.tempquery.SQL.Add('select DCOUNT("cpxxbds","MCF_cpxxxx","cpxxbds=1") AS cpxxbdtj,DCOUNT("cpxxbds","MCF_cpxxxx","cpxxbds=2") AS cpxxbstj,DCOUNT("cpxxsds","MCF_cpxxxx","cpxxsds=1") AS cpxxsdtj,'
+'DCOUNT("cpxxsds","MCF_cpxxxx","cpxxsds=2") AS cpxxsstj,DCOUNT("cpxxgds","MCF_cpxxxx","cpxxgds=1") AS cpxxgdtj,DCOUNT("cpxxgds","MCF_cpxxxx","cpxxgds=2") AS cpxxgstj from MCF_cpxxxx');
MC_DM.tempquery.Active := true;我要把sql查询出的 cpxxbdtj，cpxxbstj 等传出来！
请问如何写

Answer 1

tempQuery.fieldByName('cpxxbdtj').asstring
tempQuery.fieldByName('cpxxbstj').asstring

Answer 2

同上，还有 Query.FieldValues('cpxxbdtj');
           Query.FieldValues('cpxxbstj');