Click here to Skip to main content
13,195,594 members (71,719 online)
Rate this:
 
Please Sign up or sign in to vote.
See more:
hi friend i am getting an error in insert into command that is java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
my string is
insert into Unique_ASR_Errors(SLNO,ERR_DATE,Time,ASR,ICSC,TYPE_EVC_UNI,ERR_CODE,ERR_MSSG,COMPLETED,COMPLETED_DATE,CANCELLED,CANCELLED_DATE,FOC,FOC_DATE,EIPOC_INVOLVED,CNO,PON,ACNA,MOBILITY,PENDING,PENDING_START_DATE) values('18964.0','06/09/2011','10:34:57','1.015410003E9','SW30','PORT','INTEX181','(22/VLXP/400130/SB)UNI Circuit ID Uniqueness Validation in New UNI Order failed same UNI Circuit ID exist in Inventory','X','05/08/2012 00:00:00','N','-','N','-','N','1-8B3SR0','A5C0010A-2','WCG','N','N','-')

please help me i am not able to find out error wha is error in syntax
Posted 25-Sep-12 5:54am
Updated 25-Sep-12 7:03am
v2

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Try:
INSERT INTO
     Unique_ASR_Errors
         (SLNO, 
          ERR_DATE, 
          Time, 
          ASR,
          ICSC,
          TYPE_EVC_UNI,
          ERR_CODE,
          ERR_MSSG,
          COMPLETED,
          COMPLETED_DATE,
          CANCELLED,
          CANCELLED_DATE,
          FOC,
          FOC_DATE,
          EIPOC_INVOLVED,
          CNO,
          PON,
          ACNA,
          MOBILITY,
          PENDING,
          PENDING_START_DATE) 
      VALUES 
          ('18964.0',
          '{06/09/2011}',
          '{10:34:57}',
          '1.015410003E9',
          'SW30',
          'PORT',
          'INTEX181',
          '{(22/VLXP/400130/SB)UNI Circuit ID Uniqueness Validation in New UNI Order failed same UNI Circuit ID exist in Inventory}',
          'X',
          '{05/08/2012 00:00:00}',
          'N',
          '-',
          'N',
          '-',
          'N',
          '1-8B3SR0',
          'A5C0010A-2',
          'WCG',
          'N',
          'N',
          '-')

Refer: http://docs.oracle.com/cd/B10500_01/text.920/a96518/cqspcl.htm[^]
  Permalink  
Comments
maheshpardeshi 26-Sep-12 3:59am
   
hi sandeep there is problem with colon in time data like '{14:15:60}'
maheshpardeshi 26-Sep-12 3:59am
   
synax erreor is there
Sandeep Mewara 26-Sep-12 4:07am
   
I shared a link with you on how to escape special characters. Did you go through it? It explains all.

Try:
'10\:34\:57' for time, escaping specific character.

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

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy |
Web04 | 2.8.171019.1 | Last Updated 25 Sep 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100