>I'm messing around with "SQL Pass-Through" and I'm able to pull data pretty easily but how would I UPDATE data in a SQL Server 2000 table using SQL Pass-Through?
>
>here is my select statement, which works well.
>
>

>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)
>

>
>What I'd like to update
>

>UPDATE MasterCostCodeList SET Active = 1 where level1 = ?m.cSelectedJob
>

It should work the same way as SELECT. Do you have any problem here?