Dynamic Data Update

perumal_41 — Fri, 30 Sep 2011 06:40:56 GMT

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

topic Dynamic Data Update in QlikView