"Syntax error in Insert Into Statement"

Question

1.00/5 (1 vote)

See more:

hi all,

when i fill all textboxes and then click on save button data inserted successfully. but when i leave one or more textbox blank then "Syntax error in Insert Into Statement". how can i solve?.
Table (Ms-Access).

Code

SQL

c.Exec("insert into donor(id,name,address,con1,con2,dob,fdd,amt)values(" & TextBox1.Text & ",'" & ComboBox1.Text & "','" & TextBox3.Text & "','" & TextBox4.Text & "','" & TextBox5.Text & "','" & DateTimePicker1.Value.Date & "','" & TextBox6.Text & "'," & TextBox2.Text & ")")
        c.StdMsg("Record Saved successfully.")

Posted 24-Mar-11 18:08pm

Bhatt Aniruddh

Updated 24-Mar-11 18:40pm

v6

Add a Solution

Comments

Sergey Alexandrovich Kryukov 25-Mar-11 0:12am

Makes no sense unless you show your code.
--SA

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)

Sandeep Mewara · Answer 1 · 2011-03-24T19:14:00

If you would had debugged, it would had taken hardly 5 min.

Example:
Assume I do not fill Textbox1, Textbox5 & Textbox2.

My Insert statement formed is:

SQL

Insert into donor(id,name,address,con1,con2,dob,fdd,amt)values(,TextBox3_Text,TextBox4_Text,, DateTimePicker1_Value_Date,,)

Saw anything? Just run the above query directly on database and see for yourself.

Wendelius · Answer 2 · 2011-03-24T19:55:00

Solution 2

I believe you will find parameters very useful. Few examples:
- http://support.microsoft.com/kb/181782[^]
- http://support.microsoft.com/kb/142938[^]

Posted 24-Mar-11 19:55pm

Wendelius

*ZeeroC00l* · Answer 3 · 2011-03-30T20:51:00

The simplest way to get around this problem would be to put a validation block before the Insert into statement where you initialise a value to the text items if they are not provided and then continue with the insert into statement.

Secondly i would suggest you make use of Parameters option as Mika has mentioned.
Take a look at the below link

MS Access Parameters[^]

Abhinav S · Answer 4 · 2011-03-30T20:59:00

Solution 4

Try to debug your code in such circumstances. Put a debug point in your code, copy the query and run it in Sql server. More often than not, you will be able to find a solution to such errors.

Posted 30-Mar-11 20:59pm

Abhinav S

"Syntax error in Insert Into Statement"

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0