Getting Null instead of value

[Stegmite]

Dim vNewFunds As Integer
Dim myNewFunds As String = "UPDATE tblChar SET Cash = " & vNewFunds & " WHERE Username = '" & vName & "'"
Dim myNewFundsCommand As New OleDb.OleDbCommand(myNewFunds, OleDbConnection1)

This is my SQL statement to update a value on an Access backend. Whenever I run the ExecuteNonQuery, the cell becomes a null value. Please tell me a better way to approach this.

 

[dalchri]

It looks like you've never assigned a value to the vNewFunds variable.

I would try this:

Dim vNewFunds As Integer[b] = 100[/b]
Dim myNewFunds As String = "UPDATE tblChar SET Cash = " & vNewFunds & " WHERE Username = '" & vName & "'"
Dim myNewFundsCommand As New OleDb.OleDbCommand(myNewFunds, OleDbConnection1)

If that doesn't work, try this:

Dim myNewFunds As String = "UPDATE tblChar SET [b]Cash = 100[/b] WHERE Username = '" & vName & "'"
Dim myNewFundsCommand As New OleDb.OleDbCommand(myNewFunds, OleDbConnection1)

then try this:

Dim myNewFunds As String = "UPDATE tblChar SET Cash = [b]" & 100 & "[/b] WHERE Username = '" & vName & "'"
Dim myNewFundsCommand As New OleDb.OleDbCommand(myNewFunds, OleDbConnection1)

Somewhere in there you ought to be able to narrow down the problem.

You may also want to consider using parameters:

Dim vNewFunds As Integer
Dim myNewFunds As String = _
   "UPDATE tblChar " & _
   "SET Cash = [?Cash] " & _
   "WHERE Username = [?Username]"
Dim myNewFundsCommand As New OleDb.OleDbCommand(myNewFunds, OleDbConnection1)

myNewFundsCommand.Parameters.Add("?Cash", vNewFunds)
myNewFundsCommand.Parameters.Add("?Username", vName)

This will keep Irishmen like O'Brian from screwing up your query.

 

[ThatRickGuy]

Are you setting vNewFunds to a value? What data type is the column in the data base?

-Rick

----------------------

http://www.ringdev.com

 

[Stegmite]

I am setting values, I just didn't put that part in.

vNewFunds = vFunds - vCost

The column is a Number field

 

[ThatRickGuy]

put a break point in and make sure that vNewFunds has a value.

-Rick

----------------------

http://www.ringdev.com