LabWindows/CVI

cancel
Showing results for 
Search instead for 
Did you mean: 

[SQL TOOLKIT] [CVI6] invalid date format

Hi,

I had to update an application written in CVI5/SQL 200
connected to an Oracle 8i Database via an ODBC driver, into CVI6/SQL 206
connected to Oracle 9i.

And the DBBINDCHARCOL SQL function does not return correct values when i
try to extract date fields.

For example:

DBBINDCOLCHAR(hmst,1,45,date,&status,"") returns "1"
instead of "1/1/2001 00:00:00" that is returned in the previous version
of the application.


if i precise the output format as "dd/mm/yyyy hh:mm:ss", the function
returns correct values, but then i would have to check a large
application to update this.


Any other idea ?


P.-S.: I wonder if that is an UNICODE problem.


--
0 Kudos
Message 1 of 2
(2,864 Views)
Hi,

I think the problem comes from the ODBC driver. I've got the same trouble with differents drivers for the same database !.
0 Kudos
Message 2 of 2
(2,864 Views)