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

I read something in the VFP help about using CursorSetProp() to make it update-able. I'll see what I can discover