[AccessD] Simple stored proc problem (I hope)

Mark Hayes markH at bitgen.co.uk
Tue Apr 8 15:46:47 CDT 2003


Hello again...

I am using XP data project and have a problem with a stored proc.

I am attempting to update a person record by passing a psnID and a new
name (just playing)

The problem is that although I may pass the psnID as "11" the record
with the ID "1" is changed. If I am trying to update the psnID "55" then
"5" gets updated.

The sproc is v.simple and I really can't see whats going wrong

	UPDATE tbl_psn 
		SET person_name=@person_name_2 
		WHERE (psnID=@psnID_1)

The psnID field is nvarchar 10

This XP stuffs getting confusing :o(

Any help much appreciated

Mark

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.470 / Virus Database: 268 - Release Date: 08/04/2003
 



More information about the AccessD mailing list