Results 1 to 12 of 12

Thread: [RESOLVED] SQL command error

Threaded View

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Nov 2016
    Location
    South Africa
    Posts
    142

    Resolved [RESOLVED] SQL command error

    I have the following VB.NET code :

    VB.Net Code:
    1. Dim kode As String = ""
    2.         Dim beskrywing As String = ""
    3.  
    4.  
    5.         If Me.SlaagCheckBox.Checked = True Then
    6.          
    7.             kode = kode & "GrSl"
    8.             beskrywing = beskrywing & "Slaag"
    9.  
    10.             opdragskepkode.Connection = konneksie
    11.             opdragskepkode.CommandText = "UPDATE skedulering2 " &
    12.                                     "SET GroeperingsKode        = CONCAT( ''," & kode & ") , " &
    13.                                     "GroepperingsBeskrywing     = CONCAT( ''," & beskrywing & ") ;"
    14.      
    15.  
    16.  
    17.             opdragskepkode.ExecuteNonQuery()
    18.        
    19.         End If

    When I run my application I get the following error : Invalid column name 'Slaag'.

    For the life of me I cannot see my mistake. Any help would be much appreciated.
    Last edited by FunkyDexter; Oct 9th, 2018 at 08:49 AM.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width