how can clear syntax error this

Question

1.00/5 (1 vote)

See more:

VB

' next create a command
Dim CMD3 As New OleDb.OleDbCommand
SQL = "insert into reciptdetails"
      "(Reciptid,Barcode,Itemcount,Itembuyprice,Itemsellprice)"
      "values"
      "(:0    ,:1    ,:2    ,:3    ,:4       )"

Posted 31-Jul-15 20:38pm

Member 10603106

Add a Solution

Comments

Michael_Davies 1-Aug-15 3:05am

You need to concatenate the strings across lines.

SQL = "insert into reciptdetails" _
& "(Reciptid,Barcode,Itemcount,Itembuyprice,Itemsellprice)" _
& "values" _
& "(:0 ,:1 ,:2 ,:3 ,:4 )"

You may then get and SQL failure as you have not put spaces between the string lines words so the result as it is will be

"insert into reciptdetails(Reciptid,Barcode,Itemcount,Itembuyprice,Itemsellprice)values(:0 ,:1 ,:2 ,:3 ,:4 )"

Which may or may not parse:

SQL = "insert into reciptdetails" _
& " (Reciptid,Barcode,Itemcount,Itembuyprice,Itemsellprice)" _
& " values" _
& " (:0 ,:1 ,:2 ,:3 ,:4 )"

I assume you are then going to paramterise the command if not then :0 etc. must be strings and ought to be single quoted i.e. ':0',':1' etc.

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2015-07-31T21:04:00

Solution 1

It looks like you're building a string from multiple parts . For this you have to use concatenation:

VB

SQL = "insert into reciptdetails" +
      " (Reciptid,Barcode,Itemcount,Itembuyprice,Itemsellprice)" +
      " values" +
      " (:0    ,:1    ,:2    ,:3    ,:4       )"

Posted 31-Jul-15 21:04pm

Wendelius

Updated 1-Aug-15 0:28am

v2

sasanka sekhar panda · Answer 2 · 2015-07-31T21:08:00

Solution 2

VB

Dim CMD3 As New OleDb.OleDbCommand
Dim Sql As String
Sql = "insert into reciptdetails" +
    "(Reciptid,Barcode,Itemcount,Itembuyprice,Itemsellprice)" +
    "values" +
    "(:0    ,:1    ,:2    ,:3    ,:4       )"

Posted 31-Jul-15 21:08pm

sasanka sekhar panda

Updated 31-Jul-15 21:09pm

v2

Patrice T · Answer 3 · 2015-07-31T23:10:00

Solution 4

Solutions 1 and 2 are missing a detail:
- you need to add a space at the end of each pieces of the SQL command

VB

SQL = "insert into reciptdetails " +
      "(Reciptid,Barcode,Itemcount,Itembuyprice,Itemsellprice) " +
      "values " +
      "(:0    ,:1    ,:2    ,:3    ,:4       )"

Posted 31-Jul-15 23:10pm

Patrice T

Member 10603106 · Answer 4 · 2015-07-31T22:38:00

Solution 3

variable is an enclosing block

Posted 31-Jul-15 22:38pm

Member 10603106