App>> sql

[Johannes Matlaisane]

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

 

[One Handed Man \( OHM - Terry Burns \)]

Post relevant code please

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .
If U Need My Email ,Ask Me

Time flies when you don't know what you're doing

 

[Ken Dopierala Jr.]

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.