Click here to Skip to main content
15,357,992 members
Home / Discussions / Database
   

Database

 
GeneralRe: ERD fee management system keep the record of whole year Pin
Richard MacCutchan24-Jan-15 8:06
mveRichard MacCutchan24-Jan-15 8:06 
GeneralRe: ERD fee management system keep the record of whole year Pin
Haidar ali25-Jan-15 0:04
MemberHaidar ali25-Jan-15 0:04 
GeneralRe: ERD fee management system keep the record of whole year Pin
Richard MacCutchan25-Jan-15 1:03
mveRichard MacCutchan25-Jan-15 1:03 
QuestionNeed a Select query that filter illegal characters Pin
nainakarri21-Jan-15 19:14
Membernainakarri21-Jan-15 19:14 
AnswerRe: Need a Select query that filter illegal characters Pin
Eddy Vluggen22-Jan-15 0:28
professionalEddy Vluggen22-Jan-15 0:28 
AnswerRe: Need a Select query that filter illegal characters Pin
Umer Akram29-Jan-15 18:58
MemberUmer Akram29-Jan-15 18:58 
QuestionLet sql server code works for all SQLServer versions Pin
MrKBA19-Jan-15 23:10
MemberMrKBA19-Jan-15 23:10 
AnswerRe: Let sql server code works for all SQLServer versions Pin
Eddy Vluggen22-Jan-15 0:26
professionalEddy Vluggen22-Jan-15 0:26 
Questionchanging the field of database based on changes in repeater Pin
Armi.R16-Jan-15 21:21
MemberArmi.R16-Jan-15 21:21 
AnswerRe: changing the field of database based on changes in repeater Pin
Mycroft Holmes19-Jan-15 23:57
professionalMycroft Holmes19-Jan-15 23:57 
QuestionDB2 Store procedure error in VB.NET Pin
sudevsu16-Jan-15 2:59
Membersudevsu16-Jan-15 2:59 
QuestionRe: DB2 Store procedure error in VB.NET Pin
GuyThiebaut16-Jan-15 3:10
professionalGuyThiebaut16-Jan-15 3:10 
AnswerRe: DB2 Store procedure error in VB.NET Pin
sudevsu16-Jan-15 3:22
Membersudevsu16-Jan-15 3:22 
GeneralRe: DB2 Store procedure error in VB.NET Pin
GuyThiebaut16-Jan-15 3:46
professionalGuyThiebaut16-Jan-15 3:46 
GeneralRe: DB2 Store procedure error in VB.NET Pin
sudevsu16-Jan-15 3:55
Membersudevsu16-Jan-15 3:55 
AnswerRe: DB2 Store procedure error in VB.NET Pin
sudevsu16-Jan-15 3:21
Membersudevsu16-Jan-15 3:21 
GeneralRe: DB2 Store procedure error in VB.NET Pin
GuyThiebaut16-Jan-15 3:59
professionalGuyThiebaut16-Jan-15 3:59 
GeneralRe: DB2 Store procedure error in VB.NET Pin
sudevsu16-Jan-15 4:30
Membersudevsu16-Jan-15 4:30 
This is how I am calling SP

Dim Cn As iDB2Connection = CreateConnection()
        Try
            Dim cm As New iDB2Command("CALL DEVSUSH.SP_CUSTINFO(@PrmCICID,@PrmCIFN,@PrmCILN,@PrmCIADDR,@PrmCICITY,@PrmCISTATE,@PrmCIZIP,@PrmCIPHONE,@PrmCIEMAIL,@PrmCICLDATE)", Cn)
            strCIPHONE = strCIPHONE.Replace("-", "")
            cm.Parameters.Add("@PRMCICID", iDB2DbType.iDB2Numeric).Value = Convert.ToInt32(strCICID)
            cm.Parameters.Add("@PrmCIFN", iDB2DbType.iDB2VarChar).Value = strCIFN
            cm.Parameters.Add("@PrmCILN", iDB2DbType.iDB2VarChar).Value = strCILN
            cm.Parameters.Add("@PrmCIADDR", iDB2DbType.iDB2VarChar).Value = strCIADDR
            cm.Parameters.Add("@PrmCICITY", iDB2DbType.iDB2VarChar).Value = strCICITY
            cm.Parameters.Add("@PrmCISTATE", iDB2DbType.iDB2VarChar).Value = strCISTATE
            cm.Parameters.Add("@PrmCIZIP", iDB2DbType.iDB2Numeric).Value = Convert.ToInt32(strCIZIP)
            cm.Parameters.Add("@PrmCIPHONE", iDB2DbType.iDB2Numeric).Value = Convert.ToInt64(strCIPHONE)
            cm.Parameters.Add("@PrmCIEMAIL", iDB2DbType.iDB2VarChar).Value = strCIEMAIL
            cm.Parameters.Add("@PrmCICLDATE", iDB2DbType.iDB2Date).Value = strCICLDATE
            cm.ExecuteNonQuery()
        Catch ex As Exception
            LogError.LogErrorIntoTextFile(ex, "InsertCust")
        End Try

Your help is much appreciated.
Thanks
Happy Coding!

GeneralRe: DB2 Store procedure error in VB.NET Pin
GuyThiebaut16-Jan-15 4:41
professionalGuyThiebaut16-Jan-15 4:41 
GeneralRe: DB2 Store procedure error in VB.NET Pin
sudevsu16-Jan-15 4:43
Membersudevsu16-Jan-15 4:43 
GeneralRe: DB2 Store procedure error in VB.NET Pin
GuyThiebaut16-Jan-15 4:48
professionalGuyThiebaut16-Jan-15 4:48 
GeneralRe: DB2 Store procedure error in VB.NET Pin
sudevsu16-Jan-15 4:50
Membersudevsu16-Jan-15 4:50 
GeneralRe: DB2 Store procedure error in VB.NET Pin
GuyThiebaut16-Jan-15 5:05
professionalGuyThiebaut16-Jan-15 5:05 
GeneralRe: DB2 Store procedure error in VB.NET Pin
sudevsu16-Jan-15 5:09
Membersudevsu16-Jan-15 5:09 
GeneralRe: DB2 Store procedure error in VB.NET Pin
GuyThiebaut16-Jan-15 5:10
professionalGuyThiebaut16-Jan-15 5:10 

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.