We have a table that tracks values for Combo Boxes. One field captures the actual name of the Control (cboSVC_AGREE_TYP). The INSERT INTO statement is as follows:
INSERT INTO OBJECT_REFS ( OBJ_TYP, OBJ_NM, OBJ_DESC, OBJ_VALUE, CREATE_BY, CREATE_DT) _
Values('Combo Box','cboSVC_AGREE_TYP',' Types of service Agreement','On Call 24-7', 'John Doe',GETDATE())
I get the following error:
sg 102, Level 15, State 1, Line 2
Incorrect syntax near '_'.
Data entry forms reference this table for their values and the Combo Box names match the field name in the applicable tables with the exception of the prefix "cbo"
Thanks for your help