查询记录,若不存在则插入,存在则不做任何操作:
CString strsql="INSERT INTO PRDLIST(productkey) SELECT distinct '"+articleKey+"' from PRDLIST WHERE NOT EXISTS(SELECT * FROM PRDLIST WHERE productkey = '"+articleKey+"')";
((static_cast<CMyApp *>(AfxGetApp()))->g_pDb)->Execute(strsql);