Need some help in this coding !!!

yana sam

Hello,

I’m just started using vb.net.The program is about replication.I need some help in the coding below.

SQL = "INSERT INTO b_CODATxn(sIC,sSemester,sSeqNo,iTxnLineID,iLineID,dTxnDate,sTxnType,sAccNo, iDrCrInd,mAmt,sDesc,sFeeCode,iRecur,dProcessDate," + _

" iID,sModFlag,sPostUser, iPeriod,iYear,mAmtPart ,sDepositSlip,sDoccode,sDocnum,sPayMode,sLinkcode,sComments,iLinkRunNo,iJournal,dDocDate) VALUES " + _

"('" + myarray(i, 0) + "','" + myarray(i, 1) + "','" + myarray(i, 2) + "','" + myarray(i, 3) + "','" + myarray(i, 4) + _

"','" + myarray(i, 5) + "','" + myarray(i, 6) + "','" + myarray(i, 7) + "','" + myarray(i, 8) + "','" + myarray(i, 9) + _

"','" + myarray(i, 10) + "','" + myarray(i, 11) + "','" + myarray(i, 12) + "','" + myarray(i, 13) + "','" + myarray(i, 14) + _

"','" + myarray(i, 15) + "','" + myarray(i, 16) + "','" + myarray(i, 17) + "','" + myarray(i, 18) + "','" + myarray(i, 19) + _

"','" + myarray(i, 20) + "','" + myarray(i, 21) + "','" + myarray(i, 22) + "','" + myarray(i, 23) + "','" + myarray(i, 24) + _

"','" + myarray(i, 25) + "','" + myarray(i, 26) + "','" + myarray(i, 27) + "','" + myarray(i, 28) + "')"

After the execution this error will appear!!!

System.data.OdbcException:ERROR[22018][ODBC Sybase Wire Protocol driver][SQL Server]Implicit conversion from datatype 'VARCHAR' to 'INT' is not allowed.Use the CONVERT function to run this query.

ERROR[22018][ODBC Sybase Wire Protocol driver][SQL Server]Implicit conversion from datatype 'VARCHAR' to 'SMALLINT' is not allowed.Use the CONVERT function to run this query.

ERROR[22018][ODBC Sybase Wire Protocol driver][SQL Server]Implicit conversion from datatype 'VARCHAR' to 'NUMERIC' is not allowed.Use the CONVERT function to run this query.

ERROR[22018][ODBC Sybase Wire Protocol driver][SQL Server]Implicit conversion from datatype 'VARCHAR' to 'MONEY' is not allowed.Use the CONVERT function to run this query.

ERROR[22018][ODBC Sybase Wire Protocol driver][SQL Server]Arithmetic overflow during implicit conversion of VARCHAR value '13/03/2008' to a DATETIME field.

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

yana sam18y ago
The first error which been posted does not appear anymore because i've correct them already but then this new erroe occurs.:-

PROCESS FAIL !!!System.Data.Odbc.OdbcException : ERROR [22003][DataDirect][ODBC Sybase Wire Protocol driver][SQL Server]Arithmetic overflow during implicit conversion of VARCHAR value ‘13/03/2008’ to a DATETIME field .

Hope you can help..

Thanks..
0
yana sam18y ago
850412085516, 072, SRT/08/03/4, NULL, 1 , 12/03/2008, RCT, 100.L113301.02010.AUSM.212004, 161 2,219.00, NULL ,BAYARAN DARIPADA 212004 ,NULL ,13/03/2008, 6500000000592878 ,NULL, NULL, 3, 2008, 2,219.00 ,NULL ,NULL, NULL ,NULL, 20080313002 ,NULL ,988, 0,12/03/2008
0
Vijaya Kadiyala18y ago
Hi,

myarray --> can u also post this rray delcaration. and also post the values that your passing.

Thanks -- Vj
0
yana sam18y ago
here is the table structure...

create table b_CODATxn (
sIC                                varchar(20)                          null ,
sSemester                       varchar(3)                            null ,
sSeqNo                          varchar(20)                          null ,
iTxnLineID                      int                                       null ,
iLineID                           int                                        null ,
dTxnDate                       datetime                                null ,
sTxnType                       varchar(20)                          null ,
sAccNo                         varchar(72)                          null ,
iDrCrInd                        int                                        null ,
mAmt                             money                                  null ,
sDesc                            varchar(50)                          null ,
sFeeCode                     varchar(50)                           null ,
iRecur                           int                                        null ,
dProcessDate               datetime                               null ,
iID                               numeric(18,0)                      identity ,
sModFlag                     varchar(5)                            null ,
sPostUser                     varchar(20)                          null ,
iPeriod                         smallint                                 null ,
iYear                            smallint                                null ,
mAmtPart                     money                                 null ,
sDepositSlip                 varchar(20)                          null ,
sDoccode                    varchar(12)                          null ,
sDocnum                     varchar(12)                          null ,
sPayMode                   varchar(20)                          null ,
sLinkcode                    varchar(12)                          null ,
sComments                  varchar(255)                       null ,
iLinkRunNo                 numeric(18,0)                      null ,
iJournal                        smallint                        DEFAULT 0   null ,
dDocDate                   smalldatetime                        null
)
0
Vijaya Kadiyala18y ago
Hi,

can u post the Table strucure with the data type and the values that are passing in the insert statements. It looks like the values data types that you are passing doens't match with the table columns data types.

Thanks -- Vj

http://dotnetvj.blogspot.com
0