The SQL statement is as follows:
Select Z.ID, Z.DJBH, Z.RQ, K.BH, K.MC, Z.JE, IIF (Z.ZT, 'Abort ", IIF ((Select Count (*) from CCGDM
WHERE M.ZBID = Z.ID AND VAL ("Select SUM (SL) from cgsh where ddid = m.zbid and hpid = m.hpid), '0.000'))
Z.rq between # 2005-03-01 # and # 2005-03-27 # Order by z.rq, z.djbh
After opening the data set, a value is not a valid TIMESTAMP.
Please help, thank you.