vb.net error when executing command

Question

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

Remove the use of () in your statement.

Bugs
– Bugs

2017-02-11 17:47:10 +00:00
Commented Feb 11, 2017 at 17:47 — Bugs
– Bugs, Commented Feb 11, 2017 at 17:47

Trevor_G · Accepted Answer · 2017-02-11 19:06:15Z

2

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.

edited Feb 11, 2017 at 19:06

answered Feb 11, 2017 at 17:49

Trevor_G

1,3311 gold badge8 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Gideon Over a year ago

Thank you Trevor. I did not even notice that.

Visual Vincent Over a year ago

@Gideon : You have only voted twice and barely accepted any of the answers on your 25 questions that has gotten at least one answer. You ought to upvote if you find a post helpful, and definitely accept an answer that solved your problem. It is a way of showing your gratitude to those who take their time trying to help you.

Ňɏssa Pøngjǣrdenlarp Over a year ago

@Gideon Not a single answer accepted in the last year and 2 votes ever is rather sparse. If you are not in a position to help others by answering questions, you can still help by upvoting any post you find informative and accepting answers. UpVotes and Accepts helps others find good answers.

Collectives™ on Stack Overflow

vb.net error when executing command

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related