When SQL statement executes get an error.
This is the command executing the SQL statement:
Set rs = db.OpenRecordset(strSQL)
-------
This is the error message:
Run-time error '3075':
Syntax error (missing operator) in query expression 'dbo_orders.spec_no =
specs.spec_no inner join combo_specs on dbo_orders.combo_no =
combo_specs.combo_no'.
-------
Statements Building the SQL command:
strSQL = "SELECT specs.design_no as EngDrwg, specs.style_desc1 as Style from dbo_orders "
strSQL = strSQL & "inner join specs on dbo_orders.spec_no = specs.spec_no "
strSQL = strSQL & "inner join combo_specs on dbo_orders.combo_no = combo_specs.combo_no "
strSQL = strSQL & "and dbo_orders.spec_no = combo_specs.spec_on_combo "
strSQL = strSQL & "where job_number = " & JNo & " And form_no = " & FNo & " "
strSQL = strSQL & "and combo_specs.combo_part_no = dbo_orders.form_no "
strSQL = strSQL & "order by specs.design_no"
-------
Here's the value of strSQL:
SELECT specs.design_no as EngDrwg, specs.style_desc1 as Style from dbo_orders inner join specs on dbo_orders.spec_no = specs.spec_no inner join combo_specs on dbo_orders.combo_no = combo_specs.combo_no and dbo_orders.spec_no = combo_specs.spec_on_combo where job_number = 31022 And form_no = 1 and combo_specs.combo_part_no = dbo_orders.form_no order by specs.design_no
-------
Created a query and copy/pasted the value into the SQL view and got the same error message.
-------
I cannot discern where the problem is. I copy/pasted the value into SQLTalk (nice utility) and it executes OK.
Got me.![[ponder] [ponder] [ponder]](/data/assets/smilies/ponder.gif)
This is the command executing the SQL statement:
Set rs = db.OpenRecordset(strSQL)
-------
This is the error message:
Run-time error '3075':
Syntax error (missing operator) in query expression 'dbo_orders.spec_no =
specs.spec_no inner join combo_specs on dbo_orders.combo_no =
combo_specs.combo_no'.
-------
Statements Building the SQL command:
strSQL = "SELECT specs.design_no as EngDrwg, specs.style_desc1 as Style from dbo_orders "
strSQL = strSQL & "inner join specs on dbo_orders.spec_no = specs.spec_no "
strSQL = strSQL & "inner join combo_specs on dbo_orders.combo_no = combo_specs.combo_no "
strSQL = strSQL & "and dbo_orders.spec_no = combo_specs.spec_on_combo "
strSQL = strSQL & "where job_number = " & JNo & " And form_no = " & FNo & " "
strSQL = strSQL & "and combo_specs.combo_part_no = dbo_orders.form_no "
strSQL = strSQL & "order by specs.design_no"
-------
Here's the value of strSQL:
SELECT specs.design_no as EngDrwg, specs.style_desc1 as Style from dbo_orders inner join specs on dbo_orders.spec_no = specs.spec_no inner join combo_specs on dbo_orders.combo_no = combo_specs.combo_no and dbo_orders.spec_no = combo_specs.spec_on_combo where job_number = 31022 And form_no = 1 and combo_specs.combo_part_no = dbo_orders.form_no order by specs.design_no
-------
Created a query and copy/pasted the value into the SQL view and got the same error message.
-------
I cannot discern where the problem is. I copy/pasted the value into SQLTalk (nice utility) and it executes OK.
Got me.
![[ponder] [ponder] [ponder]](/data/assets/smilies/ponder.gif)