Dynamic Data Update

[perumal_41]

Hi ,

i am trying data insert from one table to new table  .

   function save_throw()

    ' Define sql statement for dynamic update

    sql = "insert into Comp  (Load Sales_Call_Date,'1',SALES_CALL_ID,'0' RESIDENT  Sales_Call_TRN )"

    ' Run dynamic update

    set test1=ActiveDocument.DynamicUpdateCommand(sql)

    if  test1=false then

      Msgbox test1.ErrorMessage

      end if

end function

at time pop up this  error

',' or ')' expected in INSERT statement;

Thanks for Advance help

Regards ,

Perumal.A