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