Hi, I have an Access database that I am creating a java front end to.
I am trying to insert a record into a table and get a problem whenever
I try to insert into my "Number" column.
Here is my table schema:
Column 1 Name: Number Type: VARCHAR
Column 2 Name: Street Type: VARCHAR
Column 3 Name: Phone Type: VARCHAR
Column 4 Name: Comments Type: LONGCHAR
Column 5 Name: Pets Type: VARCHAR
Column 6 Name: id Type: VARCHAR
Column 7 Name: Phone2 Type: VARCHAR
Column 8 Name: Email Directory Type: BIT
Here is my insert statement that creates the error:
queryString = "INSERT INTO Homes (id,Street,Number) VALUES ('5000a',
'Test Bend','5000');" ;
m_statement.executeUpdate(queryString);
This statement works, however:
INSERT INTO Homes (id,Street,Phone) VALUES ('5000b', 'Test
Bend','555-555-1234');
Here is the error:
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
statement.
[Ljava.lang.StackTraceElement;@1a786c3 1 4947
2BaCook wrote: Hi, I have an Access database that I am creating a java front end to. I am trying to insert a record into a table and get a problem whenever I try to insert into my "Number" column.
Here is my table schema: Column 1 Name: Number Type: VARCHAR Column 2 Name: Street Type: VARCHAR Column 3 Name: Phone Type: VARCHAR Column 4 Name: Comments Type: LONGCHAR Column 5 Name: Pets Type: VARCHAR Column 6 Name: id Type: VARCHAR Column 7 Name: Phone2 Type: VARCHAR Column 8 Name: Email Directory Type: BIT
Here is my insert statement that creates the error: queryString = "INSERT INTO Homes (id,Street,Number) VALUES ('5000a', 'Test Bend','5000');" ; m_statement.executeUpdate(queryString);
This statement works, however: INSERT INTO Homes (id,Street,Phone) VALUES ('5000b', 'Test Bend','555-555-1234');
Here is the error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. [Ljava.lang.StackTraceElement;@1a786c3
Just guessing.
Phone numbers usually aren't stored as numbers in a table...usually they
are strings. So I can understand why the phone number works if that is
the case. I'm not sure why you want to stuff a string into a number
field unless the field Number, in the table, is a string. What happens
if you remove the single quotes around the number 5000? This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Philip Boonzaaier |
last post by:
I want to be able to generate SQL statements that will go through a list of
data, effectively row by row, enquire on the database if this exists in the
selected table- If it exists, then the colums...
|
by: robert |
last post by:
been ruminating on the question (mostly in a 390/v7 context) of
whether, and if so when, a row update becomes an insert/delete.
i assume that there is a threshold on the number of columns of
the...
|
by: MrNobody |
last post by:
What's the easiest way to make an insert using Microsoft.Jet.OLEDB.4.0
OleDbConnection connection to a MS Access data base file?
I'm finding examples out on the net that have like 1,000 line of...
|
by: rn5a |
last post by:
During registration, users are supposed to enter the following
details: First Name, Last Name, EMail, UserName, Password, Confirm
Password, Address, City, State, Country, Zip & Phone Number. I am...
|
by: ak1dnar |
last post by:
There is a Error getting while i am entering records using this jsp file.
<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %>
<%@ include...
|
by: Subrat Das |
last post by:
Hi,
I have a java application which calls a stored procedure to insert data into a table.Multiple threads of java call the same procedure at the same time. Sometimes it happens that few threads send...
|
by: yeap |
last post by:
Hi All,
I can't insert java variable into ms access database.
I'm using odbc connection to ms access.
Below are my coding.
try
{
...
|
by: vijaykumardahiya |
last post by:
Hello Sir,
I have a simple Issue but It is not resolve by me i.e input parameter
are not store in Ms-Access.
I store the input parameter through Standard Action <jsp:useBean>.
jsp:useBean call a...
|
by: oranoos3000 |
last post by:
hi
i have an error with enter record to table in database(mysql)
structure of my table is as follow
- phpMyAdmin SQL Dump
-- version 2.11.6
-- http://www.phpmyadmin.net
--
-- Host:...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |