Okay, I give. I am using an Access Db. I am having troublewith data type conversions...
driving me nuts!
In the Access table, the column is a Integer
When I try to update it or assign a variable to it, it simply phews.:(((
What I am trying to do, is assign the variable the current value of the column, then update the column by 1
I keep receiving cast errors, not matter how I dim the variable.
Dim vtagnbr As Integer = 0
Dim vsqltxt As String = ""
Dim vsep As String = "'"
vsqltxt = "SELECT RecId, BegTagNbr FROM IdTagNbrs"
daTagNbrs.SelectCommand.CommandText = vsqltxt
vtagnbr = CInt(dsTagNbr.IdTagNbrs("BegTagNbr"))
I need to have the begtagnbr, add one to it and populate a text box (that I can do..)
and update the Counter by 1
What the magic key for Access data types??
Any help appericated...