Menu
▾
▴
Re: [Firebird-odbc-devel] [PATCH] Patch for dates on Access
|
From: Thomas M. <tm...@bs...> - 2002-11-21 19:10:21
|
Could this be related to the datatype mangiling that Paul mentioned for my
number problem?
Carlos Guzmán Álvarez wrote:
> Hello:
>
>
> I send a patch for the dates on acces, but this continues to have
> problems:
>
>
> - Dates - Works well ( as i see on my tests ).
>
> - Time - Gives conversion error ( as i see on my tests ).
>
> - TimeStamp - Gives conversion error ( as i see on my tests ).
>
>
>
>
>
> Best regards
> Carlos Guzmán Álvarez
> Vigo-Spain
>
>------------------------------------------------------------------------
>
>Index: IscSqlType.cpp
>===================================================================
>RCS file: /cvsroot/firebird/OdbcJdbc/IscDbc/IscSqlType.cpp,v
>retrieving revision 1.2
>diff -u -r1.2 IscSqlType.cpp
>--- IscSqlType.cpp 11 Oct 2002 11:09:06 -0000 1.2
>+++ IscSqlType.cpp 21 Nov 2002 18:57:18 -0000
>@@ -109,15 +109,6 @@
> }
> break;
>
>- case blr_timestamp:
>- {
>- type = JDBC_TIMESTAMP;
>- typeName = "TIMESTAMP";
>- length = MAX_TIMESTAMP_LENGTH;
>- bufferLength = length;
>- }
>- break;
>-
> case blr_varying:
> case blr_varying2:
> {
>@@ -145,7 +136,7 @@
>
> case blr_sql_date:
> {
>- type = JDBC_DATE;
>+ type = JDBC_SQL_DATE;
> typeName = "DATE";
> length = MAX_DATE_LENGTH;
> bufferLength = length;
>@@ -154,10 +145,19 @@
>
> case blr_sql_time:
> {
>- type = JDBC_TIME;
>+ type = JDBC_SQL_TIME;
> typeName = "TIME";
> length = MAX_TIME_LENGTH;
> bufferLength = length-2;
>+ }
>+ break;
>+
>+ case blr_timestamp:
>+ {
>+ type = JDBC_SQL_TIMESTAMP;
>+ typeName = "TIMESTAMP";
>+ length = MAX_TIMESTAMP_LENGTH;
>+ bufferLength = length;
> }
> break;
>
>
>
>------------------------------------------------------------------------
>
>Index: IscDbc.h
>===================================================================
>RCS file: /cvsroot/firebird/OdbcJdbc/IscDbc/IscDbc.h,v
>retrieving revision 1.4
>diff -u -r1.4 IscDbc.h
>--- IscDbc.h 11 Oct 2002 11:09:05 -0000 1.4
>+++ IscDbc.h 21 Nov 2002 18:57:01 -0000
>@@ -82,6 +82,10 @@
> #define JDBC_VARCHAR 12
> #define JDBC_LONGVARCHAR -1
>
>+#define JDBC_SQL_DATE 9
>+#define JDBC_SQL_TIME 10
>+#define JDBC_SQL_TIMESTAMP 11
>+
> #define JDBC_DATE 91
> #define JDBC_TIME 92
> #define JDBC_TIMESTAMP 93
>
>
--
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork
http://www.bss-software.com
|
