Click here to Skip to main content
15,901,122 members
Home / Discussions / Database
   

Database

 
Questionthe insert command doesnt work Pin
sara-setare10-Apr-13 18:27
sara-setare10-Apr-13 18:27 
AnswerRe: the insert command doesnt work Pin
PIEBALDconsult10-Apr-13 19:00
mvePIEBALDconsult10-Apr-13 19:00 
GeneralRe: the insert command doesnt work Pin
sara-setare10-Apr-13 19:14
sara-setare10-Apr-13 19:14 
AnswerRe: the insert command doesnt work Pin
Pallavi Waikar10-Apr-13 19:55
Pallavi Waikar10-Apr-13 19:55 
GeneralRe: the insert command doesnt work Pin
sara-setare10-Apr-13 20:19
sara-setare10-Apr-13 20:19 
GeneralRe: the insert command doesnt work Pin
Richard Deeming11-Apr-13 1:53
mveRichard Deeming11-Apr-13 1:53 
AnswerRe: the insert command doesnt work Pin
Richard Deeming11-Apr-13 1:51
mveRichard Deeming11-Apr-13 1:51 
QuestionOleDb Overflow error Pin
TheJudeDude10-Apr-13 9:13
TheJudeDude10-Apr-13 9:13 
I am receiving an Overflow error from an INSERT statement. I understand this is because a value that is assigned to a variable is larger than the data type, correct? The database was built in Access.
I pinned the values on screen while debugging and took a screen shot, which is linked herewhich is linked here.
I have double checked the data types and they all seem to match.What am I missing?
Thank you in advance.

Here is the code:
<pre lang="c#"> oleDbComQC.CommandText = "INSERT INTO RANKS ([ACCOUNTS], [EOB], [FPD], [F90P], [PDCHECK], [INCOME], [PD], [PD90P]) " +
"VALUES(@ACCTS, @EOB, @FPD, @F90P, @PDC, @INC, @PD, @PD90)";
oleDbComQC.Parameters.AddWithValue("@ACCTS", OleDbType.Integer);
oleDbComQC.Parameters.AddWithValue("@EOB", OleDbType.Decimal); 
oleDbComQC.Parameters.AddWithValue("@FPD", OleDbType.Integer);
oleDbComQC.Parameters.AddWithValue("@F90P", OleDbType.Integer);
oleDbComQC.Parameters.AddWithValue("@PDC", OleDbType.Integer);
oleDbComQC.Parameters.AddWithValue("@INC", OleDbType.Decimal);
oleDbComQC.Parameters.AddWithValue("@PD", OleDbType.Integer);
oleDbComQC.Parameters.AddWithValue("@PD90", OleDbType.Integer);
            
oleDbComQC.Parameters["@ACCTS"].Value = iAccts;
oleDbComQC.Parameters["@EOB"].Value = decEOB;
oleDbComQC.Parameters["@FPD"].Value = iFPD;
oleDbComQC.Parameters["@F90P"].Value = i90PD;
oleDbComQC.Parameters["@PDC"].Value = iNumChks;
oleDbComQC.Parameters["@INC"].Value = decIncome;
oleDbComQC.Parameters["@PD"].Value = iPPD;
oleDbComQC.Parameters["@PD90"].Value = iP90PD;

Jude

AnswerRe: OleDb Overflow error Pin
TheJudeDude10-Apr-13 9:28
TheJudeDude10-Apr-13 9:28 
Questionhow to create the databse?? Pin
tazeen ansari10-Apr-13 0:22
tazeen ansari10-Apr-13 0:22 
AnswerRe: how to create the databse?? Pin
Eddy Vluggen10-Apr-13 0:35
professionalEddy Vluggen10-Apr-13 0:35 
AnswerRe: how to create the databse?? Pin
Shanalal Kasim12-Apr-13 0:03
Shanalal Kasim12-Apr-13 0:03 
AnswerRe: how to create the databse?? Pin
indra kurnia13-May-13 6:57
indra kurnia13-May-13 6:57 
QuestionTable Design help with 2 computed columns Pin
Simon_Whale10-Apr-13 0:14
Simon_Whale10-Apr-13 0:14 
AnswerRe: Table Design help with 2 computed columns Pin
Eddy Vluggen10-Apr-13 0:23
professionalEddy Vluggen10-Apr-13 0:23 
GeneralRe: Table Design help with 2 computed columns Pin
Simon_Whale10-Apr-13 1:28
Simon_Whale10-Apr-13 1:28 
AnswerRe: Table Design help with 2 computed columns Pin
Mycroft Holmes10-Apr-13 1:50
professionalMycroft Holmes10-Apr-13 1:50 
GeneralRe: Table Design help with 2 computed columns Pin
Simon_Whale10-Apr-13 1:55
Simon_Whale10-Apr-13 1:55 
GeneralRe: Table Design help with 2 computed columns Pin
Mycroft Holmes10-Apr-13 2:23
professionalMycroft Holmes10-Apr-13 2:23 
GeneralRe: Table Design help with 2 computed columns Pin
Simon_Whale10-Apr-13 2:24
Simon_Whale10-Apr-13 2:24 
QuestionHow To Use Pivot in SQL SERVER Pin
srikrishnach9-Apr-13 23:55
srikrishnach9-Apr-13 23:55 
AnswerRe: How To Use Pivot in SQL SERVER Pin
Eddy Vluggen10-Apr-13 0:35
professionalEddy Vluggen10-Apr-13 0:35 
AnswerRe: How To Use Pivot in SQL SERVER Pin
Mycroft Holmes10-Apr-13 1:45
professionalMycroft Holmes10-Apr-13 1:45 
AnswerRe: How To Use Pivot in SQL SERVER Pin
Shanalal Kasim12-Apr-13 0:06
Shanalal Kasim12-Apr-13 0:06 
Questionproblem in join and update Pin
mhd.sbt9-Apr-13 7:34
mhd.sbt9-Apr-13 7:34 

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.