Ad:

VB.NET Discussion Thread
Unsolved
Views: 1746

Jul 15th, 2007

SQL UPDATE Error

Expand Post »

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.

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 & " ' "

Similar Threads

automatic update error?? in Windows NT / 2000 / XP
windows update error in Windows NT / 2000 / XP
$rs=mysql_query($sql) or die("error in common.inc.php at line 257"); in PHP
ADO.Net SQL UPDATE using OleDBAdapter in C#
SQL server error: 18452 - connection to SQL error in Windows NT / 2000 / XP

ViRiPuFF

Reputation Points: 16

Solved Threads: 0

Light Poster

Offline

32 posts
since Jun 2007

Permalink

Jul 16th, 2007

Re: SQL UPDATE Error

It looks like you never declared the datatype of loSQL.

sk8ndestroy14

Reputation Points: 437

Solved Threads: 1

Posting Virtuoso

Offline

1,851 posts
since Mar 2007

Permalink

Jul 16th, 2007

Re: SQL UPDATE Error

Click to Expand / Collapse Quote 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

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

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 & " "

ViRi

ViRiPuFF

Reputation Points: 16

Solved Threads: 0

Light Poster

Offline

32 posts
since Jun 2007

Permalink

Jul 19th, 2007

Re: SQL UPDATE Error

thanx for self learning, that really helps a lot.

debasisdas

Featured Poster

Reputation Points: 665

Solved Threads: 427

Posting Genius

Offline

6,406 posts
since Feb 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in VB.NET Forum Timeline: load data from access database into form

Next Thread in VB.NET Forum Timeline: Doubt

DaniWeb Message

Cancel Changes

User Name
Password