ODBC broken in 1.9.16.17

[ltheoret]

Hi,

The ODBC include file in ODBC352.inc. says something about the month variable conflict. or already declared. in version 1.9.16.17.

Reloaded 1.9.15.0 works great.

yes some of us still use it.

Luc

[ErosOlmi]

Hi Luc,

thanks for reporting.
Yes I got it and I will fix for next version. At work I still use it in some script.

If in the meantime you want to fix it ... change \thinBasic\Inc\ODBC352.INC amending the first 75 line into:

 ' ########################################################################################
' ODBC352.INC - Constants, types and declares of the ODC API.
' ########################################################################################


'#IF NOT %DEF(%ODBC352_INC)
    %ODBC352_INC = 1


   '#IF NOT %DEF(%WINAPI)
   '    #INCLUDE "WIN32API.INC"
   '#ENDIF


'//-----------------------------------------------------------------------------
'// File:      sqltypes.h
'//
'// Copyright:    Copyright (c) Microsoft Corporation
'//
'// Contents:     This file defines the types used in ODBC
'//
'//-----------------------------------------------------------------------------


%ODBCVER = &H0352


TYPE DATE_STRUCT
   _year  AS INTEGER
   _month AS WORD
   _day   AS WORD
END TYPE


TYPE TIME_STRUCT
   _hour   AS WORD
   _minute AS WORD
   _second AS WORD
END TYPE


Type TIMESTAMP_STRUCT
   _year     As Integer 
   _month    As Word 
   _day      As Word 
   _hour     As Word 
   _minute   As Word 
   _second   As Word 
   _fraction As DWord 
End Type 


'/*
' * enumerations for DATETIME_INTERVAL_SUBCODE values for interval data types
' * these values are from SQL-92
' */


%SQL_IS_YEAR             = 1
%SQL_IS_MONTH            = 2
%SQL_IS_DAY              = 3
%SQL_IS_HOUR             = 4
%SQL_IS_MINUTE           = 5
%SQL_IS_SECOND           = 6
%SQL_IS_YEAR_TO_MONTH    = 7
%SQL_IS_DAY_TO_HOUR      = 8
%SQL_IS_DAY_TO_MINUTE    = 9
%SQL_IS_DAY_TO_SECOND    = 10
%SQL_IS_HOUR_TO_MINUTE   = 11
%SQL_IS_HOUR_TO_SECOND   = 12
%SQL_IS_MINUTE_TO_SECOND = 13


TYPE SQL_YEAR_MONTH
   _year  AS DWORD
   _month AS DWORD
END TYPE


TYPE SQL_DAY_SECOND
   _day      AS DWORD
   _hour     AS DWORD
   _minute   AS DWORD
   _second   AS DWORD
   _fraction AS DWORD
END TYPE

The change add an underscore char in front of "year", "month", "day", "hour", "minute", "second" inside few TYPEs otherwise they are recognized as reserved words.
I will fix in next version I'm working on allowing reserved words inside TYPEs to be used as TYPE element names.

Thanks
Eros