By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,699 Members | 1,372 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,699 IT Pros & Developers. It's quick & easy.

App>> sql

P: n/a
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!
Nov 21 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

"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!

Nov 21 '05 #2

P: n/a
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!

Nov 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.