VB.NET

SQL UPDATE Error

Please support our VB.NET advertiser: Programming Forums - DaniWeb Sister Site

•

Join Date: Jun 2007

Posts: 28

Reputation: ViRiPuFF is an unknown quantity at this point

Solved Threads: 0

ViRiPuFF

Offline

Light Poster

SQL UPDATE Error

Jul 15th, 2007

Hi

I have the following code which generates an error 'Data Type mismatch in criteria expression'

The purpose of the code is to write a value to a database at a specific row.

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
 
        Dim IntSid As String
        Dim Sid As String
        Dim I As Integer
 
        IntSid = Me.TTIn.Text
        Sid = Me.SessionIDTextBox.Text
        I = CInt(Val(Sid))
 
 
        Dim loSQL = "UPDATE tblSession SET TTout = '" & _
        IntSid & "' WHERE SessionId = '" & _
        I & " ' "
        Dim IntSid As String
        Dim Sid As String
        Dim I As Integer
        
        IntSid = Me.TTIn.Text
        Sid = Me.SessionIDTextBox.Text
        I = CInt(Val(Sid))


        Dim loSQL = "UPDATE tblSession SET TTout = '" & _
        IntSid & "' WHERE SessionId = '" & _
        I & " ' "

•

Join Date: Mar 2007

Posts: 1,851

Reputation: sk8ndestroy14 is an unknown quantity at this point

Solved Threads: 1

sk8ndestroy14 sk8ndestroy14 is offline

Offline

Posting Virtuoso

Re: SQL UPDATE Error

Jul 16th, 2007

It looks like you never declared the datatype of loSQL.

Disclaimer: Nothing I say can be considered credible information (I wonder what that means about this disclaimer then).

•

Join Date: Jun 2007

Posts: 28

Reputation: ViRiPuFF is an unknown quantity at this point

Solved Threads: 0

ViRiPuFF

Offline

Light Poster

Re: SQL UPDATE Error

Jul 16th, 2007

•

Originally Posted by sk8ndestroy14

It looks like you never declared the datatype of loSQL.

Hi

I got it to work the problem was the single quote around the variable I which is an Integer and not a String

My original SQL statement was

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
Dim loSQL = "UPDATE tblSession SET TTout = '" & _
        IntSid & "' WHERE SessionId = '" & _
        I & " ' "
Dim loSQL = "UPDATE tblSession SET TTout = '" & _
        IntSid & "' WHERE SessionId = '" & _
        I & " ' "

This should have been

 Help with Code Tags 
 VB.NET Syntax (Toggle Plain Text) 
Dim loSQL = "UPDATE tblSession SET TTout = '" & _
        Me.TTIn.Text & "'WHERE SessionId = " & _
        I & " "
Dim loSQL = "UPDATE tblSession SET TTout = '" & _
        Me.TTIn.Text & "'WHERE SessionId = " & _
        I & " "