General information
Category:
COM/DCOM and OLE Automation
Title:
Crazy SQL in COM Server
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only