473,322 Members | 1,501 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

App>> sql

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
2 1101
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: Gary McGill | last post by:
I'm building a set of DLLs in .NET that I plan to call from a VB6 application. I've almost got that to work, but now I find that whenever I re-build any of my .NET DLLs, the reference to that...
1
by: Eric Rupp via .NET 247 | last post by:
I am looking to have a VB.NET app capture loging information and pass it to a website log in if the users want to access our intranet site (using that same login info). I am looking for a way to...
8
by: Tom | last post by:
Hi I have an aspx page which has javascript to configure xmldata. I added breakpoint to the button method. When I click submit button, it did not go to those breakpoint and show the following...
11
by: Wolfgang Kaml | last post by:
I am not sure if this is more of an expert question, but I am sure that they are out there. I'd like to setup a general application or bin directory on my Win2003.Net Server that will hold some...
3
by: T. Regan | last post by:
I have a test app where I have Forms Authentication set up. When I build and run the app as http://localhost/testapp/login.aspx, it runs correctly. I get the login prompt and the proper...
1
by: Johannes Matlaisane | last post by:
I hate to submit codes, here it is below. This code only updates the first letter not full. Check my previouse message. Please dont change it too much>> by the way, I am new to this field. I...
2
by: Vikram | last post by:
I am using log4net in a vb.net console application. But its not working. I have added congif setting in app.config file also No error is generated but app. does not write to log file. ...
5
by: Keith | last post by:
Hello all, I have a C# Windows Forms app. It is in namespace App.GUI. It builds to Nav.exe. I have entered an application level setting using the designer. Its type is string, name is "FOO"...
0
by: =?Utf-8?B?Sm9obg==?= | last post by:
Hi all, We have one product. It is client/server based application. We have developed client application in VC++ 6.0. Our client is desktop based application like dialog based application....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.