Re: SQL CREATE TABLE ERROR
- From: "Bjorn Abelli" <bjorn_abelli@xxxxxxxxxxxxxxxxxxxxx>
- Date: 26 Apr 2006 04:50:36 +0200
"Ben" wrote...
Im trying to create a table in an access database using java.
When I used "CREATE TABLE tblTable (time number)" it works fine.
It shouldn't, as TIME is a reserved word.
Look again at your script, as you probably spelled it just a little bit
differently...
What am I doing wrong?
Also, what is the datatype in SQL for number:
Using "Number" as datatype from SQL gives a "Double" in Access.
Long Integer and Memo.
To create such fields in Access from Java, you can use the types:
"Integer" and "Memo" respectively...
// Bjorn A
Inviato da X-Privat.Org - Registrazione gratuita http://www.x-privat.org/join.php
.
- References:
- SQL CREATE TABLE ERROR
- From: Ben
- SQL CREATE TABLE ERROR
- Prev by Date: SQL CREATE TABLE ERROR
- Next by Date: Re: MSAccess get Query SQL source possible
- Previous by thread: SQL CREATE TABLE ERROR
- Next by thread: Database and java.sql.SQLException Questions
- Index(es):
