Check the values for the WHERE statment. Make sure the are correct. Another possiblity is that the index on the table is corrupt.
>Greetings,
>
>I have proc in a MTDLL that is supposed to update a single record.
>I am using the SQL Update syntax with a WHERE clause, However, it Updates EVERY record in the table... I can find no information about how or why this happening.
>
>I am calling the proc from an ASP page thus:
>myKey='This'
>myName='That'
>Set oLib=server.createobject('myLib.myProcs')
>oRun=oLib.myUpdater(myKey,myName)
>
>Inside the DLL:
>*..................................................
>Procedure myUpdater
> Parameters theKey,theName
>
>Open Database myDatabase
>Use myTable
>
>UPDATE myTable SET NAME=theName WHERE tKey=theKey
>
>Close Database
>RETURN
>*..................................................
>
>I've tried using a SEEK and just REPLACING the Field contents but that doesn't work either. So I've got a ghost somewhere.
>
>Where should I look?
>
>Thanks
>
>David
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer