回复 7楼 tlliqi
我用的spt,用ID字段判断是否为新的记录
代码如下:
CLEAR ALL
USE call_reco IN 1
SELECT 1
GO BOTTOM
finaID=ALLTRIM(ID)
exeA='SELECT ID,Caller,TrunkCaller,Agent,TallTimeStart,TallTimeEnd,TrunkCh,ZxCh,Flag,;
TallWay,TallArea,Memo,EmployeeNumber,RingTimer,TrunkDtmf,HangupType,IvrFlow,;
IvrTimeStart,IvrTimeEnd,ListTimeStart,FilePath,ShareFilePath,HttpFilePath,'
exeB='conOutCallerEvaluate,conOutCallerEvaluateSound,Enabled;
FROM [AiLink].[dbo].[Thing_CallPhone] WHERE id>'+finaID
myConnHandle=SQLCONNECT('kefu','sa','*******')
**我把密码掩盖了
SQLEXEC(myConnHandle,exeA+exeB,"NewCallRecord")
SELECT 1
APPEND FROM NewCallRecord
SQLDISCONNECT(myConnHandle)
[此贴子已经被作者于2016-2-6 11:15编辑过]