Can't seem to UPDATE dBase table

From: Glenn Robinson (Glenn_at_Flying-Fields.co.uk)
Date: 06/18/04

Next message: Colin 't Hart: "Re: Can't seem to UPDATE dBase table"
Previous message: Chris Smith: "Re: POD speed"
Next in thread: Colin 't Hart: "Re: Can't seem to UPDATE dBase table"
Reply: Colin 't Hart: "Re: Can't seem to UPDATE dBase table"
Reply: mromarkhan_at_rogers.com: "Re: Can't seem to UPDATE dBase table"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Date: Fri, 18 Jun 2004 17:16:19 +0100

Hello,

I'm using jdbc-odbc bridge to try and update a .dbf table.

My code is as follows:

stmt.executeUpdate(
"INSERT INTO sas.dbf VALUES ('1234', '1234567', '1', '1234',
'12:34:56', '2004-06-18', '1','1234',)");

When I run it I get a syntax error in INSERT INTO statement, the following
in my ODBC trace file:

<snip>
java 45c-538 ENTER SQLSetStmtOption
  HSTMT 08E421D8
  UWORD 7 <SQL_CONCURRENCY>
  SQLPOINTER 0x00000001

java 45c-538 EXIT SQLSetStmtOption with return code 0
(SQL_SUCCESS)
  HSTMT 08E421D8
  UWORD 7 <SQL_CONCURRENCY>
  SQLPOINTER 0x00000001 (BADMEM)

java 45c-538 ENTER SQLFreeStmt
HSTMT 08E421D8
UWORD 0 <SQL_CLOSE>

java 45c-538 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 08E421D8
UWORD 0 <SQL_CLOSE>

java 45c-538 ENTER SQLExecDirect
  HSTMT 08E421D8
  UCHAR * 0x008EC9C8 [ -3] "INSERT INTO sas.dbf VALUES
('1234', '1234567', '1', '1234', '12:34:56', '2004-06-18', '1','1234',)\ 0"
  SDWORD -3

java 45c-538 EXIT SQLExecDirect with return code -1 (SQL_ERROR)
  HSTMT 08E421D8
  UCHAR * 0x008EC9C8 [ -3] "INSERT INTO sas.dbf VALUES
('1234', '1234567', '1', '1234', '12:34:56', '2004-06-18', '1','1234',)\ 0"
  SDWORD -3

DIAG [37000] [Microsoft][ODBC dBase Driver] Syntax error in INSERT INTO
statement. (-3502)

java 45c-538 ENTER SQLErrorW
  HENV 00000000
  HDBC 00000000
  HSTMT 08E421D8
  WCHAR * 0x0007F900 (NYI)
   SDWORD * 0x0007F944
  WCHAR * 0x0007F500
  SWORD 300
  SWORD * 0x0007F940

java 45c-538 EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
  HENV 00000000
  HDBC 00000000
  HSTMT 08E421D8
  WCHAR * 0x0007F900 (NYI)
   SDWORD * 0x0007F944 (-3502)
  WCHAR * 0x0007F500 [ 69] "[Microsoft][ODBC dBase Driver]
Syn"
  SWORD 300
  SWORD * 0x0007F940 (69)

java 45c-538 ENTER SQLErrorW
  HENV 00000000
  HDBC 00000000
  HSTMT 08E421D8
  WCHAR * 0x0007F900 (NYI)
   SDWORD * 0x0007F944
  WCHAR * 0x0007F500
  SWORD 300
  SWORD * 0x0007F940

java 45c-538 EXIT SQLErrorW with return code 100
(SQL_NO_DATA_FOUND)
  HENV 00000000
  HDBC 00000000
  HSTMT 08E421D8
  WCHAR * 0x0007F900 (NYI)
   SDWORD * 0x0007F944
  WCHAR * 0x0007F500
  SWORD 300
  SWORD * 0x0007F940

<snip>

All columns are character apart from the 6th one which is a date type and I
suspect this is what's causing me a problem.

Can anyone shed any light on this?

Thanks

-- 
Glenn

Next message: Colin 't Hart: "Re: Can't seem to UPDATE dBase table"
Previous message: Chris Smith: "Re: POD speed"
Next in thread: Colin 't Hart: "Re: Can't seem to UPDATE dBase table"
Reply: Colin 't Hart: "Re: Can't seem to UPDATE dBase table"
Reply: mromarkhan_at_rogers.com: "Re: Can't seem to UPDATE dBase table"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Relevant Pages

Cant seem to UPDATE dBase table
... I'm using jdbc-odbc bridge to try and update a .dbf table. ... When I run it I get a syntax error in INSERT INTO statement, ... suspect this is what's causing me a problem. ...
(microsoft.public.data.odbc)
Cant seem to UPDATE dBase table
... I'm using jdbc-odbc bridge to try and update a .dbf table. ... When I run it I get a syntax error in INSERT INTO statement, ... suspect this is what's causing me a problem. ...
(comp.lang.java.programmer)