Syntax error

  • Thread starter Thread starter phong.lee
  • Start date Start date
P

phong.lee

Hello there,

Can someone assist me with the following syntax error for the
following code:

objDatabase.Docmd.runsql "INSERT INTO Tbl_Testing (test_id,
engagement_id, stage, iteration, description," _
& "plan_start_date, plan_end_date, actual_start_date,
actual_end_date, num_planned, num_actual," _
& "num_remain, num_passed, num_failed, num_raised,
num_open, num_closed, num_critical, num_major," _
& "num_avg, num_minor, last_update)" _
& "SELECT MATRIX_CURRENT.ID, MATRIX_CURRENT.PROJECT_ID,
MATRIX_CURRENT.ITERATION, MATRIX_CURRENT.STAGE," _
& "MATRIX_CURRENT.ITERATION_DESCRIPTION,
MATRIX_CURRENT.PLANNED_START, MATRIX_CURRENT.PLANNED_END," _
& "MATRIX_CURRENT.ACTUAL_START, MATRIX_CURRENT.ACTUAL_END,
MATRIX_CURRENT.PLANNED, MATRIX_CURRENT.ACTUAL," _
& "MATRIX_CURRENT.REMAINING, MATRIX_CURRENT.PASSED,
MATRIX_CURRENT.FAILED, MATRIX_CURRENT.SUBMIT_D+[assign_d]+[open_d]+
[resolve_d]+[postpone_d]+[duplicate_d]+[close_d]," _
& "MATRIX_CURRENT.SUBMIT_D+[assign_d]+[open_d]+[resolve_d]+
[postpone_d]+[duplicate_d] AS [Open], MATRIX_CURRENT.CLOSE_D " _
& "AS Closed, MATRIX_CURRENT.CRITICAL,
MATRIX_CURRENT.MAJOR, MATRIX_CURRENT.AVERAGE, MATRIX_CURRENT.MINOR," _
& "MATRIX_CURRENT.UPDATE_DATE FROM MATRIX_CURRENT "
& "WHERE (((MATRIX_CURRENT.ACTUAL_START)<>'null') AND
((MATRIX_CURRENT.ACTUAL_END)<>'null'))"

I get a compile error. Expected: line number or end of statement.
Please let me know what i'm missing. thanks.
 
objDatabase.Docmd.runsql "INSERT INTO Tbl_Testing (test_id," & _
"engagement_id, stage, iteration, description," & _
"plan_start_date, plan_end_date, actual_start_date," & _
"actual_end_date, num_planned, num_actual," & _
"num_remain, num_passed, num_failed, num_raised," & _
"num_open, num_closed, num_critical, num_major," & _
"num_avg, num_minor, last_update)" & _
"SELECT MATRIX_CURRENT.ID, MATRIX_CURRENT.PROJECT_ID," & _
"MATRIX_CURRENT.ITERATION, MATRIX_CURRENT.STAGE," & _
"MATRIX_CURRENT.ITERATION_DESCRIPTION, " & _
"MATRIX_CURRENT.PLANNED_START, MATRIX_CURRENT.PLANNED_END," & _
"MATRIX_CURRENT.ACTUAL_START, MATRIX_CURRENT.ACTUAL_END," & _
"MATRIX_CURRENT.PLANNED, MATRIX_CURRENT.ACTUAL," & _
"MATRIX_CURRENT.REMAINING, MATRIX_CURRENT.PASSED," & _
"MATRIX_CURRENT.FAILED, MATRIX_CURRENT.SUBMIT_D+" & _
"[assign_d]+[open_d]+" & _
"[resolve_d]+[postpone_d]+[duplicate_d]+[close_d]," & _
"MATRIX_CURRENT.SUBMIT_D+[assign_d]+[open_d]+[resolve_d]+" & _
"[postpone_d]+[duplicate_d] AS [Open], MATRIX_CURRENT.CLOSE_D " & _
"AS Closed, MATRIX_CURRENT.CRITICAL," & _
"MATRIX_CURRENT.MAJOR, MATRIX_CURRENT.AVERAGE, " & _
"MATRIX_CURRENT.MINOR," & _
"MATRIX_CURRENT.UPDATE_DATE FROM MATRIX_CURRENT " & _
"WHERE (((MATRIX_CURRENT.ACTUAL_START)<>'null') AND" & _
"((MATRIX_CURRENT.ACTUAL_END)<>'null'))"

[email protected] said:
Hello there,

Can someone assist me with the following syntax error for the
following code:

objDatabase.Docmd.runsql "INSERT INTO Tbl_Testing (test_id,
engagement_id, stage, iteration, description," _
& "plan_start_date, plan_end_date, actual_start_date,
actual_end_date, num_planned, num_actual," _
& "num_remain, num_passed, num_failed, num_raised,
num_open, num_closed, num_critical, num_major," _
& "num_avg, num_minor, last_update)" _
& "SELECT MATRIX_CURRENT.ID, MATRIX_CURRENT.PROJECT_ID,
MATRIX_CURRENT.ITERATION, MATRIX_CURRENT.STAGE," _
& "MATRIX_CURRENT.ITERATION_DESCRIPTION,
MATRIX_CURRENT.PLANNED_START, MATRIX_CURRENT.PLANNED_END," _
& "MATRIX_CURRENT.ACTUAL_START, MATRIX_CURRENT.ACTUAL_END,
MATRIX_CURRENT.PLANNED, MATRIX_CURRENT.ACTUAL," _
& "MATRIX_CURRENT.REMAINING, MATRIX_CURRENT.PASSED,
MATRIX_CURRENT.FAILED, MATRIX_CURRENT.SUBMIT_D+[assign_d]+[open_d]+
[resolve_d]+[postpone_d]+[duplicate_d]+[close_d]," _
& "MATRIX_CURRENT.SUBMIT_D+[assign_d]+[open_d]+[resolve_d]+
[postpone_d]+[duplicate_d] AS [Open], MATRIX_CURRENT.CLOSE_D " _
& "AS Closed, MATRIX_CURRENT.CRITICAL,
MATRIX_CURRENT.MAJOR, MATRIX_CURRENT.AVERAGE, MATRIX_CURRENT.MINOR," _
& "MATRIX_CURRENT.UPDATE_DATE FROM MATRIX_CURRENT "
& "WHERE (((MATRIX_CURRENT.ACTUAL_START)<>'null') AND
((MATRIX_CURRENT.ACTUAL_END)<>'null'))"

I get a compile error. Expected: line number or end of statement.
Please let me know what i'm missing. thanks.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro syntax problem - Dean 10
Syntax error (missing operator) 19
Syntax error 8
What's the syntax error with this SendKeys code? 1
syntax error 1
Calling Parameterized Query Using SQL Syntax 3
Option Group ListBox Row Source "Expected end of statement" 0
Syntax error (comma) in query - ????????????????????????? 1

Back
Top