What would cause this error in my C# statement?

Question

It doesn't like "Category."  If I remove all the code to handle the category column, it works fine.  I'm working in Visual Studio 2005, and I'm stumped...???

MY CODE:

OleDbConnection myConn;
myConn = new OleDbConnection("Provider=Advantage OLE DB Provider;Data Source=&#92;&#92;&#92;&#92;server123&#92;&#92; m &#92;&#92;dst &#92;&#92;plx_data&#92;&#92; planfaxsystem.add; User Id=XXXXXXXXXX; Password=XXXXXXXXXX;");
 
myConn.Open();

string morningStar = "MorningStar";

string sql2 = String.Format("INSERT INTO PERFORMANCE_TABLE(SecurityName, Ticker, Cusip, Category) VALUES ('{0}', '{1}', '{2}', '{3}')", fundName, ticker, cusip, category); 

OleDbCommand cmd = new OleDbCommand(sql2, myConn);
cmd.ExecuteNonQuery();     // ** CRASHES HERE **
if (myConn != null && myConn.State == ConnectionState.Open)
{
     myConn.Close();
}



ERROR MESSAGE:
Error 7200:  AQE Error:  State = 01004;   NativeError = 2102;  [Extended Systems][Advantage SQL Engine]Data truncated   INSERT INTO SYSTEM_PERFORMANCE (SecurityName, Ticker, Cusip, Category) VALUES ('Newton Balanced',  'STASX', '001285400', 'Moderate Allocation')

David K · Accepted Answer

check  the types on the columns you are inserting into.  It seems the insert is failing because it was cause some of your data to be truncated. (say its a varchar(50) and you are inserting 55 characters)

Me M · Answer

Is Cusip supposed to be an integer or a varchar? With the single-quotation marks around 001285400 in the SQL statement, I believe the sql server will interpret that as characters, instead of a number.

Anonymous · Answer

nicely, have you ever tried defining a constructor for the classification, whether it does no longer something. i'm no longer in front of a g++ compiler on the 2d to attempt it out. I did whether attempt it on a GCC compiler (utilising codeblocks), and it labored completely high quality without compilation blunders or informational messages. I did whether could remark out the line that did 'std::cin.forget approximately approximately...', because of the fact I wasn't particular what code became there. in case you % me to attempt the code returned utilising each and all of the code you have for it, in basic terms positioned some areas interior the template call which you have been making 'std::numeric_limits<std:...'.

Aadil Prabhakar · Answer

Have you tried renaming the column Category to cat or cate or something because the error as per you r question is on the CATEGORY column.

Trending News

What would cause this error in my C# statement?

4 Answers