sConnectString = "DSN=QBVB;OLE DB Services=-2;" sSQL = "SELECT Name FROM Terms" Set Softcn= New ADODB.Connection Set softrs= New ADODB.Recordset Softcn.Open sConnectString
strSQL="INSERT INTO BillItemLine (VendorRefListID, RefNumber,ItemLineLinkToTxnTxnID, ItemLineLinkToTxnTxnLineID,FQSaveToCache)Select VendorRefListID, {fn CONCAT('POLink', RefNumber)},TxnID, PurchaseOrderLineTxnLineID,1 as FQSaveToCache from PurchaseOrderLine where RefNumber='477701'"
SoftRS.Open strSQL, SoftCN, adOpenDynamic, adLockOptimistic
strSQL="INSERT INTO Bill(VendorRefListID, APAccountRefListID, TxnDate,RefNumber,Memo) VALUES ('80000072-1216654299','80000026-1215720574', {d'2008-07-17'},'477701', 'None')"
SoftRS.Open strSQL, SoftCN, adOpenDynamic, adLockOptimistic
it giving Error Parsing Complete Xml Return string for Bill insert
what is problem |