[Simondo]

Heya,

I need to insert this value into a table but make sure that it accepts null values, can anyone help?

CheckString(RemoveCarriageReturns(dreader.GetString(2)))

[Advertisements]

'fill table with order items

[/code]
		dbconnection2.Open()
		dbcommand2.CommandText = "select orderitemid,qty,description,despatched from tblorderitem where orderid = " & gloOrderID
		dreader = dbcommand2.ExecuteReader
		While dreader.Read
			dbconnection.Open()
			dbcommand.CommandText = "insert into " & tmptable & " (orderitemid,qty,description,despatched,outstanding,thisdelivery) values(" & dreader.GetInt32(0) & "," & dreader.GetInt32(1) & ",'" & CheckString(RemoveCarriageReturns(dreader.GetString(2))) & "'," & dreader.GetInt32(3) & "," & dreader.GetInt32(1) - dreader.GetInt32(3) & ",0)"
			dbcommand.ExecuteNonQuery()
			dbconnection.Close()
		End While
[code]

[Simondo]

'fill table with order items

[/code]
		dbconnection2.Open()
		dbcommand2.CommandText = "select orderitemid,qty,description,despatched from tblorderitem where orderid = " & gloOrderID
		dreader = dbcommand2.ExecuteReader
		While dreader.Read
			dbconnection.Open()
			dbcommand.CommandText = "insert into " & tmptable & " (orderitemid,qty,description,despatched,outstanding,thisdelivery) values(" & dreader.GetInt32(0) & "," & dreader.GetInt32(1) & ",'" & CheckString(RemoveCarriageReturns(dreader.GetString(2))) & "'," & dreader.GetInt32(3) & "," & dreader.GetInt32(1) - dreader.GetInt32(3) & ",0)"
			dbcommand.ExecuteNonQuery()
			dbconnection.Close()
		End While
[code]

[Simondo]

Do'h you cant see it all. Hopefully top post is all you need. Thanks!

[Simondo]

Fixed!

Thanks anyway

[Metallica]

Hi Simondo,

Did you use a Nullable type or find another solution?
Maybe it can help someone else having a similar problem.

[Metaphysical]

I presume your removecarriagereturns is a function or a sub somewhere, and that you modified that to ignore nulls.

[Metaphysical]

My bad. Isn't it just something along the lines of:

IIf(IsDBNull(CheckString(dreader("description"))), "", RemoveCarriageReturns(CheckString(dreader.GetString(2)))