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