my update command is not working. can anyone see what the problem is? I am not getting an error...
Dim cnTag1 As New OleDb.OleDbConnection
cnTag1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Password=;User ID=Admin;data source=c:\BlownAway.db.mdb"
Dim...
...= "18410" Then
TrExpCode = "VMISC"
Else
TrExpCode = DBNull.value (here is the problem)
End If
***cut to the insert statement*****
sqlchk = "Insert Into PRTran (TRExpCode) values('" & TrExpCode & "')"
please any help would be much appreciated...
I have a crystal report in my vb.net program that has a subreport. the subreport doesn't need the parameter only the main report. it askes me twice for the same parameter when it is run. Is it because of the subreport and if so what can i do to stop that.
thanks
Michelle
...= True
xlSheet.Cells(1, 1) = "Truck No"
xlSheet.Cells(1, 2) = "SO Number"
Dim sqlC As String = "Select * from DelTracking order by TruckNo, SONumber"
Dim cmC As New SqlClient.SqlCommand(sqlC, SqlConnection3)
SqlConnection3.Open()
Dim rdrC As...
wait, I am still not sure that makes sense. I may not be explaining myself correctly. I would want to append rows I just want to igore the identity column but that is not working.
I am creating a DTS that takes data from one table(tblA) and inserts it into another(tblB) but tblB has an incrementing PK and I am getting an error "cannot insert a null value" or something of that sort.
Any ideas? Thanks
Michelle
Thank you for your response Frederico, and all of you who tried to help me. We did restart the server after installed the oracle client software but still have no luck in scheduling the dts. for right now, until I can figure out why it will not work, I am executing the dts every morning...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.