Missing Comma Error

  • Thread starter Thread starter subbu
  • Start date Start date
S

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 + ")"
 
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.
 
Back
Top