>m.nConnectionHandle = SQLCONNECT('TimeClockPlusTest') >m.cSelectedJob = '16536%' > >TEXT TO lcCmd NOSHOW PRETEXT 15 > >select CostRecordId, Level1, Active from dbo.MasterCostCodeList where level1 like ?m.cSelectedJob > >ENDTEXT > >=SQLEXEC(m.nConnectionHandle,lcCmd,'CostCodeInfo') > >=SQLDISCONNECT(m.nConnectionHandle) >>
>UPDATE MasterCostCodeList SET Active = 1 where level1 = ?m.cSelectedJob >It should work the same way as SELECT. Do you have any problem here?