>>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
Thanks
Jon
Non-MVP Non-MCP Non-MCSE
Visual FoxPro, What else is there?