UCanAccess / Discussion / General Discussion: Column name incorrect after create table.

Sproketboy - 2021-09-10

CREATE TABLE Customers ( [Customer ID] varchar(10) PRIMARY KEY NOT NULL, [Company Name] VARCHAR(30) NULL, [Contact Name] VARCHAR(30) NULL, [Contact Title] VARCHAR(10) NULL, [Address] VARCHAR(40) NULL, [City] VARCHAR(30) NULL, [Region] VARCHAR(10) NULL, [Postal Code] VARCHAR(10) NULL, [Country] VARCHAR(2) DEFAULT 'US', [Phone] VARCHAR(30) NULL, [Fax] VARCHAR(30) NULL, [Status] CHAR(1) NULL, [Date Registered] Timestamp DEFAULT NOW(), [Date Of Last Order] DATE, [Test Local Date] date, [Test Local DateTime] Timestamp )

When you execute this command the column "Test Local DateTime" becomes "TEST LOCAL TIMESTAMP" in the database. Happens also with "Test Local Date Time"

I posted this here as well.

https://sourceforge.net/p/jackcess/bugs/155/
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Marco Amadei - 2021-09-10
  
  Which version are you using?
  
  Il Ven 10 Set 2021, 11:49 Sproketboy sproketboy@users.sourceforge.net ha
  scritto:
  
  CREATE TABLE Customers (
  [Customer ID] varchar(10) PRIMARY KEY NOT NULL,
  [Company Name] VARCHAR(30) NULL,
  [Contact Name] VARCHAR(30) NULL,
  [Contact Title] VARCHAR(10) NULL,
  [Address] VARCHAR(40) NULL,
  [City] VARCHAR(30) NULL,
  [Region] VARCHAR(10) NULL,
  [Postal Code] VARCHAR(10) NULL,
  [Country] VARCHAR(2) DEFAULT 'US',
  [Phone] VARCHAR(30) NULL,
  [Fax] VARCHAR(30) NULL,
  [Status] CHAR(1) NULL,
  [Date Registered] Timestamp DEFAULT NOW(),
  [Date Of Last Order] DATE,
  [Test Local Date] date,
  [Test Local DateTime] Timestamp )
  
  When you execute this command the column "Test Local DateTime" becomes
  "TEST LOCAL TIMESTAMP" in the database. Happens also with "Test Local Date
  Time"
  
  I posted this here as well.
  
  https://sourceforge.net/p/jackcess/bugs/155/
  
  Column name incorrect after create table.
  https://sourceforge.net/p/ucanaccess/discussion/general/thread/52ae8bb570/?limit=25#72b7
  
  Sent from sourceforge.net because amadei.mar@gmail.com is subscribed to
  https://sourceforge.net/p/ucanaccess/discussion/general/
  
  To unsubscribe from further messages, a project admin can change settings
  at https://sourceforge.net/p/ucanaccess/admin/discussion/forums. Or, if
  this is a mailing list, you can unsubscribe from the mailing list.
  
  alternate
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
  - Sproketboy - 2021-09-10
    
    Hi I'm using 5.0.1 with hsqldb 2.5.1
    
    If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
    - Marco Amadei - 2021-09-10
      
      Ok. It will be fixed in the 6.0.0
      
      Il Ven 10 Set 2021, 14:08 Sproketboy sproketboy@users.sourceforge.net ha
      scritto:
      
      Hi I'm using 5.0.1 with hsqldb 2.5.1
      
      Column name incorrect after create table.
      https://sourceforge.net/p/ucanaccess/discussion/general/thread/52ae8bb570/?limit=25#72b7/2875/cb65
      
      Sent from sourceforge.net because amadei.mar@gmail.com is subscribed to
      https://sourceforge.net/p/ucanaccess/discussion/general/
      
      To unsubscribe from further messages, a project admin can change settings
      at https://sourceforge.net/p/ucanaccess/admin/discussion/forums. Or, if
      this is a mailing list, you can unsubscribe from the mailing list.
      
      alternate
      
      If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
      - Sproketboy - 2021-09-10
        
        Cool thanks!
        
        If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Column name incorrect after create table.

A pure Java JDBC driver for Microsoft Access database files

Forums

Help

Column name incorrect after create table.

https://sourceforge.net/p/jackcess/bugs/155/

Hi I'm using 5.0.1 with hsqldb 2.5.1

Column name incorrect after create table.

A pure Java JDBC driver for Microsoft Access database files

Forums

Help

Column name incorrect after create table. document.SUBSCRIPTION_OPTIONS = { "thing": "topic", "subscribed": false, "url": "subscribe", "icon": { "css": "fa fa-envelope-o" } };

https://sourceforge.net/p/jackcess/bugs/155/

Hi I'm using 5.0.1 with hsqldb 2.5.1

Column name incorrect after create table.