Mark Hayes
markH at bitgen.co.uk
Tue Apr 8 16:03:02 CDT 2003
Just had another go and it’s the same for characters... If I enter "AAA" then recod "A" gets updated... If I do the same update from code using a simple update sql string and a command object then its ok. ???? Mark -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Hayes Sent: 08 April 2003 21:47 To: accessd at databaseadvisors.com Subject: [AccessD] Simple stored proc problem (I hope) 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 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com --- Incoming 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 --- 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