Missing Comma Error

[subbu]

Hi,
I ma getting the Missing Comma Error while framing the
INSERT SQL QUERY.I have pasted the string below.I am
trying from morning without luck

Any help in this regard is highly appreciated

Regds
subbu

sSQL = "INSERT INTO SPS_REQUEST (sps_audit_log_id,
cis_number,
transaction_code,tibco_xmit_id,tibco_xmit_id_seq," & _
"request_type_code,service_delivery_site_id,service_sequenc
e_id,customer_id,customer_account_id,customer_agreement_id,
" & _
"WORK_TASK_ID_1,ACTIVITY_NAME_1, BUSINESS_REVIEW_FLAG,
RESPONSIBLE_EMPLOYEE_NO," & _
"REQUEST_COMPLETED_STATUS,REQUEST_COMPLETED_COMMENTS,
SERVICE_PROFILE_CODE," & _
"service_wire_count,service_drop_type_code,pricing_structur
e_code) Values (" & _
4001 & "," + straliasName + "," + strTranCode + "," +
strauditLogId + "," + strxmitId + "," + strxmitIdSeq + ","
+ strrequestTypeCode + "," & _
strserviceDeliverySiteId + "," + strserviceSequenceId
+ "," + strcustomerId + "," + strcustomerAccountId + "," +
strAgreementId + "," + strtaksId + "," + strdesc + "," +
strbusinessreviewflag + "," + strcompletedEmployeeNumber
+ "," + strrequestStatus & _
strprofileCode + "," + strserviceWireCount + "," +
strdropTypeCode + "," + strpricingStructureCode + ")"

 

[Dan Artuso]

Hi,
The easiest thing to do, and also something you should ALWAYS do,
is to put a:
Debug.Print sSQL
in your code so that you can see
where the syntax error is in your evaluated string.

It's much easier than going through a long SQL statement and looking
for errors.