Wed Oct 30 08:51:43 EST 2002 amplodbc.c, ampltabl.dll, TABLES.RME: extend the "standard" ODBC table handler to recognize new optional string maxlen=nnn (just before the optional 'verbose') among the Strings to specify the maximum length of strings (symbolic parameters) read from the table. The default is 480, which will probably suffice for most purposes. Strings longer than maxlen will be truncated to maxlen characters when the table is read. Tue Aug 5 22:51:54 EDT 2003 amplodbc.c, ampltabl.dll: have "write table" preserve old columns of an INOUT table even when the table is initially empty, and for columns of type text, retain the text type even when the column ends up having exlusively numeric values. Tue Dec 6 09:59:00 EST 2005 amplodbc.c: minor tweaks for portability to 64-bit MS Windows. Tue Jan 1 17:57:59 MST 2008 amplodbc.c: tweak for MS SQL Server 2005: for numeric values, successively try SQL_DOUBLE, SQL_FLOAT, SQL_REAL, and SQL_NUMERIC rather than SQL_DOUBLE, SQL_NUMERIC, and SQL_REAL. Wed Jan 2 23:25:35 MST 2008 amplodbc.c: adjust the date shown when "version" is specified. (Missed updating this lately when making changes.) Thu Sep 23 13:31:28 MDT 2010 amplodbc.c: attempt to pass a plausible window handle to SQLDriverConnect(). If need be, a handle can be specified by setting $sw_HWND to a hexadecimal value (without a leading 0x) in the environment passed to AMPL. With some incomplete or incorrect DRIVER=... settings, this will cause a dialogue box to appear in which corrections can be attempted. Setting $sw_HWND to 0 disables this new behavior. Ignore case for "DRIVER=", "SQL=", and "DSN=" (e.g., treat "Driver=" and "driver=" the same as "DRIVER="). Tue Nov 2 17:26:08 MDT 2010 amplodbc.c: fix a bug that led to a seldom-seen error message of the form "ColAlloc: cols[5].sinv already allocated." 20111024 Add optional strings 'nsmix=...' and 'write=append' or 'write=drop' to the possibilities for strings in table declarations for tables handled by the ODBC table handler (usually called ampltabl.dll), and allow 'verbose=n', with 0 <= n <= 3, as alternatives to 'verbose'. For details, in an AMPL session with the updated ampltabl.dll loaded, issue the command print _handler_desc['odbc'];