You are correct, that was my problem
Thanks a bunch
Jon
>Hi Jon
>
>In your select query you are using like. In your update you used =. Just in case you missed it, the % at the end of m.cSelectedJob would make the update fail.
>You added the dbo schema to your select query, but not to the update query. If the default schema is not dbo, and the default schema has a MasterCostCodeList, your update would not happen in dbo. I'd include dbo in the update query too.
>
>Glad to see you're passing parameters via ? as it goes a long way toward preventing SQL Injection Attacks.
>
>UPDATE dbo.MasterCostCodeList SET Active = 1 where level1 = ?m.cSelectedJob
>
>
>>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
>>
Thanks
Jon
Non-MVP Non-MCP Non-MCSE
Visual FoxPro, What else is there?