авторВот такой код:
Dim con As New ADODB.Connection
con.Open "Provider=SQLOLEDB;Data Source=COMMSQL;database=invest;uid=kochetkova;pwd=reanimator;"
Dim rst As ADODB.Recordset
con.Execute
con.Execute (" insert_into_INA_Innovative_offer " _
& F_cod_cex.Column(0) & " ," _
& F_tree_number & " ," _
& F_receipt_date & " ," _
& F_name_offer & " ," _
& F_autors_first_name & " ," _
& F_autors_second_name & " ," _
& F_autors_last_name & " ," _
& F_place_of_work & " ," _
& F_post & " ," _
& F_id_category.Column(0) & " ," _
& F_investments & " ," _
& F_econ_benefit_set & " ," _
& F_econ_benefit_act & " ," _
& F_sum_compensation & " ," _
& F_date_decision_sc & " ," _
& F_date_decision_fc & " ," _
& F_date_decision_mc & " ," _
& F_date_introdaction & " ," _
& F_mark_rationalizer)
На строчке con.Execute выдается сообщение об ошибке
Line 1 : incorrect syntax near ','
ShubnikovОстанови на con.Execute, посмотри значение своего выражения и всё станет ясно. Неужели найдётся желающий проанализировать твой паровоз ?
Исходный топик удален (см Правила).