CODEWITHSUNDEEP
sqlvb.net
Gideon
Gideon

Reputation: 313

vb.net error when executing command

I have the following sql code in vb.net :

    opdragkopieernaleweringresultaat.CommandText = "insert into    LeweringVsSkattingResultaat(aliasnaam2,kultivar2,skattingkultivar2,gelewerkultivar2,persentklaarkultivar2) " & _
     "  SELECT " & _
     "l.aliasnaam() " & _
     ",l.kultivar,l.SkattingVirKult,l.GelewerVirKult,l.PersentKlaarKult " & _
     " FROM() " & _
     "LeweringVsSkatting l " & _
     " GROUP BY " & _
     " l.aliasnaam() " & _
     ",l.kultivar,l.SkattingVirKult,l.GelewerVirKult,l.PersentKlaarKult"
    opdragkopieernaleweringresultaat.ExecuteNonQuery()

The code works in sql management, but returns the following error in vb.net : Incorrect syntax near ')'. The error occurs at the line opdragkopieernaleweringresultaat.ExecuteNonQuery(). What am I missing?

Regards

Upvotes: 1

Views: 47

Answers (1)

Trevor_G
Trevor_G

Reputation: 1331

When you copied the SQL to vb the IDE added the () marks at the end of some of the rows due to its "intelligence". Remove them and it should work as expected.

enter image description here

Upvotes: 2

Related Questions