Click here to Skip to main content
16,005,339 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionError in ADO.Net application Pin
LostMonkey30-Jun-09 23:05
LostMonkey30-Jun-09 23:05 
Chaps and Chapettes,

I am getting the following error in my wee data application: -

Cannot set column 'vcGraphicCode_GRA'. The value violates the MaxLength limit of this column.

The code does a pretty standard create a new row via a oRow = table.newrow() statement, then populates oRow.<list of="" columns=""> with a set of values (no nulls here btw). Then does a table.AddRow(oRow)...this is when I get the error.

The particular column in the error is a string of 5 characters (a SQL 2005 varchar(5) column). The value I place in there is for example "00152". The table I am inserting the row into is always empty (since the table is on a form for setting up new SKU items). The table is also pre-defined in an XSD file within my project.

Yes, the error informative is pretty straight forward. However, the maximum size of the field is 5 characters and the value I am attempting to place into it is exactly 5 characters in length.

I'm beginning to think that sticking with VFP, where this operation would be a straight INSERT on a remote view, would be easier! Laugh | :laugh:

Monkey
AnswerRe: Error in ADO.Net application Pin
Luc Pattyn1-Jul-09 0:20
sitebuilderLuc Pattyn1-Jul-09 0:20 
GeneralRe: Error in ADO.Net application Pin
LostMonkey1-Jul-09 4:25
LostMonkey1-Jul-09 4:25 
GeneralRe: Error in ADO.Net application Pin
Luc Pattyn1-Jul-09 4:28
sitebuilderLuc Pattyn1-Jul-09 4:28 
GeneralRe: Error in ADO.Net application Pin
LostMonkey1-Jul-09 4:51
LostMonkey1-Jul-09 4:51 
GeneralRe: Error in ADO.Net application Pin
Luc Pattyn1-Jul-09 4:56
sitebuilderLuc Pattyn1-Jul-09 4:56 
GeneralRe: Error in ADO.Net application Pin
LostMonkey1-Jul-09 5:00
LostMonkey1-Jul-09 5:00 
QuestionConvert Type in Vb.net Pin
hamed200930-Jun-09 22:22
hamed200930-Jun-09 22:22 
AnswerRe: Convert Type in Vb.net Pin
TheMrProgrammer1-Jul-09 1:28
TheMrProgrammer1-Jul-09 1:28 
QuestionDraw a Polygon using Pen Pin
ClueLess Ar*e30-Jun-09 20:59
ClueLess Ar*e30-Jun-09 20:59 
AnswerRe: Draw a Polygon using Pen Pin
Christian Graus30-Jun-09 21:39
protectorChristian Graus30-Jun-09 21:39 
QuestionSet a keyboard hook Pin
TheMrProgrammer30-Jun-09 20:20
TheMrProgrammer30-Jun-09 20:20 
AnswerRe: Set a keyboard hook Pin
TheMrProgrammer1-Jul-09 5:36
TheMrProgrammer1-Jul-09 5:36 
QuestionHow to do a HTTP GET request Pin
fuhaizah30-Jun-09 18:37
fuhaizah30-Jun-09 18:37 
AnswerRe: How to do a HTTP GET request Pin
Christian Graus30-Jun-09 21:41
protectorChristian Graus30-Jun-09 21:41 
QuestionProblem reading CSV file into dataset. Pin
maf66630-Jun-09 11:10
maf66630-Jun-09 11:10 
AnswerRe: Problem reading CSV file into dataset. Pin
Johan Hakkesteegt1-Jul-09 2:30
Johan Hakkesteegt1-Jul-09 2:30 
GeneralRe: Problem reading CSV file into dataset. Pin
maf6661-Jul-09 3:20
maf6661-Jul-09 3:20 
QuestionVB.net 2005 (getModuleFileNameEx) Pin
johnl012930-Jun-09 9:41
johnl012930-Jun-09 9:41 
QuestionDeserialize PHP Encoded Data Pin
GGP130-Jun-09 9:32
GGP130-Jun-09 9:32 
AnswerRe: Deserialize PHP Encoded Data Pin
Dave Kreskowiak30-Jun-09 10:40
mveDave Kreskowiak30-Jun-09 10:40 
Questionresizing contols in a form Pin
sa_runner30-Jun-09 8:38
sa_runner30-Jun-09 8:38 
AnswerRe: resizing contols in a form Pin
Eslam Afifi30-Jun-09 9:48
Eslam Afifi30-Jun-09 9:48 
AnswerRe: resizing contols in a form Pin
Jon_Boy1-Jul-09 1:27
Jon_Boy1-Jul-09 1:27 
AnswerRe: resizing contols in a form Pin
sa_runner1-Jul-09 3:40
sa_runner1-Jul-09 3:40 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.