dbo.JionStr函数的使用方法

DIM TEMPVALUE200 AS STRING=SQLQUERY(" UPDATE  XSSK_MAIN SET DGTCBL=B.DGY FROM(SELECT DBO.JIONSTR( CAST(XM AS VARCHAR(50)) +':'+CAST(TCBL AS VARCHAR(50))) AS DGY ,SYSTEM_ID FROM SKGDY WHERE SYSTEM_ID='" &FDATA("TSYSTEM_ID") &"' GROUP BY  SKGDY.SYSTEM_ID )B WHERE XSSK_MAIN.SYSTEM_ID=B.SYSTEM_ID AND XSSK_MAIN.SYSTEM_ID='" &FDATA("TSYSTEM_ID") &"'")DIM TEMPVALUE200 AS STRING=SQLQUERY(" UPD