Code:
mySelectQuery = ("UPDATE RF_Assign SET Gun_In = '" _
& searchGunIn & "' ,Batt_In = '" & searchGunIn _
& "' WHERE Badge = '" & strBadge & "'")
lewelljo
Last Activity: Mar 17 '10, 04:35 PM
Joined: Feb 14 '10
Location:
-
Sorry for the delay but I got the answer a few days back.... Hope this helps others. The problem was in the query.
... -
Thanks tl. I understand what you are saying and in my hast in replying I did not state it clearly. But, as it is above, should this not work? Why is "mySelectQu ery" showing the correct string on break, but when trying to fill: daGun."Fill(dsG un)" it takes the contents of the string and beleives it to be a column?Leave a comment:
-
I'm not familiar with C# at all and very novice with .net. I can make "strBadge" Public to = "frmMain.txtBad ge.text". I understand that is just good practice and will keep it in mind when cleaning this up. So here's the code as of right now:
Code:Call chkGunIn("Gun_In", "Batt_In")...Code:Sub chkGunIn(ByVal searchGunIn As String, ByVal strBadge As String) Dim daGunLeave a comment:
-
This is the contents of mySelectQuery =
UPDATE RF_Assign SET Gun_In = '2/15/2010 9:53:58 AM' ,Batt_In = '2/15/2010 9:53:58 AM' WHERE Badge = Batt_InLeave a comment:
-
Yes the column names are correct. Here is the insert statement.
...Code:insertStatement = "INSERT INTO RF_Assign (Autoi, Badge, Gun_Number, Gun_Out, Gun_In, Batt_Number, Batt_Out, Batt_In) VALUES ('" + Row_count + "','" _ + frmMain.txtBadge.Text + "','" + frmMain.TxtGun.Text + _ "','" + GOut + "','" + GIn + "','" + frmMain.txtBatt.Text +Leave a comment:
-
Thanks Sashi. There still is a problem. It runs without an exception but will not update. When I check it at the break the " Trim(strBadge)" is "Batt_In" Should I not be looking for the contents of frmMain.txtBadg e.Text? I am so confused! I really thank you for your help.
This is what I have.....
And....Code:Call chkGunIn("Gun_In", "Batt_In")
...Code:Sub chkGunIn(ByVal
Leave a comment:
-
cannot update multiple columns with visual basic 2008
Thanks Sashi for the response. I copied and pasted your code and am still getting the same error... Invalid column name 'TNJCL'. TNJCL is the string content of "frmMain.txtBad ge.text.Leave a comment:
-
cannot update multiple columns with visual basic 2008
Hello Everyone & please excuse my ignorance. I am fairley new to .net and newer to SQL. The below code gives me an exception telling me that it is an invalid column name. It's taking the input string from "frmMain.txtBad ge.Text" and thinking it's the column name. I have searched for days without any clue. Any help would be appreciated.
Thanks
...Code:Sub chkGunIn() Dim daGunLast edited by tlhintoq; Feb 14 '10, 11:10 PM. Reason: [CODE] ...Your code goes between code tags [/CODE]
No activity results to display
Leave a comment: