Hi,
Without the code this is a stumper. A few things to look at:
1. In your stored procedure make sure your varchar declaration specifies
the correct number of characters (i.e. @FirstName varchar(20).
2. When you call your stored procedure make sure you are using the correct
type in your Parameters.Add() call:
objCommand.Parameters.Add("@FirstName", SqlDbType.VarChar).Value =
strFirstName
For the above line if you specified SqlDbType.Char that would probably cause
the problem. If those don't help then post the code. Good luck! Ken.
--
Ken Dopierala Jr.
For great ASP.Net web hosting try:
http://www.webhost4life.com/default.asp?refid=Spinlight
"Johannes Matlaisane" <ma*********@saquantum.co.za> wrote in message
news:uT*************@TK2MSFTNGP11.phx.gbl...
Another simply problem...
When I am updating the database from the Windows app only the first
letters (initials) are updated.
I checked my stored procedure and data type on the table and can't find
error.
E.g. Johannes - J is updated in the table.
Thanks for the previous assistance
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!