|
saidev
Posting Yak Master
101 Posts |
 Posted - 2006-07-06 : 11:30:18
|
| Hi Guys,I am using dbreader for inserting data into the table. I am reading data from SQL and then, row by row, constructing SQL statements using that data and executing them to copy data back to the server But if there is any null value in one of the fields i am getting the message " Cast from DBNull to type string is not valid". Here is my Query. Is there any simple way to handle Nulls..? Appreciate Your help.SQL = "insert into tblcontract(fkcontracttype,fkgroup,fksubgroup,orderid,fkordertype,date,orderbegindate,orderenddate,fknetwork,estimatenumber,flight,donovan,fkadvertiser,fkagency,fktrafficsystem,agencycommission,buyer,fkclient,repcommission,fkproducttype,product,buydesc,fkae,fkae2,aesplit,natsplit,referencepkid)" & _" values ('UNWIRED', '" & dbreader("fkgroup") & "','" & dbreader("fksubgroup") & "','" & dbreader("orderid") & "','" & dbreader("fkordertype") & "','" & dbreader("date") & "','" & dbreader("orderbegindate") & "','" & dbreader("orderenddate") & "','" & dbreader("fknetwork") & "','" & dbreader("estimatenumber") & "','" & dbreader("flight") & "','" & dbreader("donovan") & "','" & dbreader("fkadvertiser") & "','" & dbreader("fkagency") & "', '" & dbreader("fktrafficsystem") & "','" & dbreader("agencycommission") & "','" & dbreader("buyer") & "','" & dbreader("fkclient") & "','" & dbreader("repcommission") & "','" & dbreader("fkproducttype") & "','" & dbreader("product") & "','" & dbreader("buydesc") & "','" & dbreader("fkae") & "','" & dbreader("fkae2") & "','" & dbreader("aesplit") & "','" & dbreader("natsplit") & "','" & dbreader("pkid") & "')"Thanks, |
|
Sql Query Handling Nulls