From 87bd1e8987ba216cb66f680094939cae333f2077 Mon Sep 17 00:00:00 2001 From: Ingela Anderton Andin Date: Thu, 1 Apr 2010 09:29:21 +0000 Subject: OTP-8511 Timestamps in ODBC MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Now supports SQL_TYPE_TIMESTAMP on the format {{YY, MM, DD}, {HH, MM, SS}}. Thanks to Juhani Ränkimies. --- lib/odbc/doc/src/databases.xml | 8 ++--- lib/odbc/doc/src/getting_started.xml | 16 +++++----- lib/odbc/doc/src/notes.xml | 58 +++++++++++++++++++++--------------- lib/odbc/doc/src/odbc.xml | 2 +- 4 files changed, 47 insertions(+), 37 deletions(-) (limited to 'lib/odbc/doc/src') diff --git a/lib/odbc/doc/src/databases.xml b/lib/odbc/doc/src/databases.xml index 2c1b932084..9776736909 100644 --- a/lib/odbc/doc/src/databases.xml +++ b/lib/odbc/doc/src/databases.xml @@ -99,7 +99,7 @@

Note that when the value of the data to input is a string, it has to be quoted with '. Example:

-\011odbc:sql_query(Ref, "INSERT INTO EMPLOYEE VALUES(1, 'Jane', 'Doe', 'F')"). +odbc:sql_query(Ref, "INSERT INTO EMPLOYEE VALUES(1, 'Jane', 'Doe', 'F')").

You may also input data using param_query/[3,4] and then @@ -198,7 +198,7 @@ when p >= 16 SQL_TYPE_TIMESTAMP - String + {{YY, MM, DD}, {HH, MM, SS}} SQL_LONGVARCHAR @@ -262,8 +262,8 @@ when p >= 16 customers of that department.

CREATE PROCEDURE DepartmentInfo (@DepartmentID INT) AS -\011SELECT * FROM Employee WHERE department = @DepartmentID -\011SELECT * FROM Customers WHERE department = @DepartmentID + SELECT * FROM Employee WHERE department = @DepartmentID + SELECT * FROM Customers WHERE department = @DepartmentID diff --git a/lib/odbc/doc/src/getting_started.xml b/lib/odbc/doc/src/getting_started.xml index 864c3a7b65..d543ef64d6 100644 --- a/lib/odbc/doc/src/getting_started.xml +++ b/lib/odbc/doc/src/getting_started.xml @@ -4,7 +4,7 @@
- 20022009 + 20022010 Ericsson AB. All Rights Reserved. @@ -13,12 +13,12 @@ compliance with the License. You should have received a copy of the Erlang Public License along with this software. If not, it can be retrieved online at http://www.erlang.org/. - + Software distributed under the License is distributed on an "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the License for the specific language governing rights and limitations under the License. - + Getting started @@ -108,15 +108,15 @@ to insert many rows in one go.

6 > odbc:param_query(Ref,"INSERT INTO EMPLOYEE (NR, FIRSTNAME, " -\011 "LASTNAME, GENDER) VALUES(?, ?, ?, ?)", -\011 [{sql_integer,[2,3,4,5,6,7,8]}, -\011 {{sql_varchar, 20}, + "LASTNAME, GENDER) VALUES(?, ?, ?, ?)", + [{sql_integer,[2,3,4,5,6,7,8]}, + {{sql_varchar, 20}, ["John", "Monica", "Ross", "Rachel", "Piper", "Prue", "Louise"]}, -\011 {{sql_varchar, 20}, + {{sql_varchar, 20}, ["Doe","Geller","Geller", "Green", "Halliwell", "Halliwell", "Lane"]}, -\011 {{sql_char, 1}, ["M","F","M","F","F","F","F"]}]). + {{sql_char, 1}, ["M","F","M","F","F","F","F"]}]). {updated, 7}

Fetch all data in the table employee

diff --git a/lib/odbc/doc/src/notes.xml b/lib/odbc/doc/src/notes.xml index 29fed0e286..09d78c3248 100644 --- a/lib/odbc/doc/src/notes.xml +++ b/lib/odbc/doc/src/notes.xml @@ -20,7 +20,7 @@ under the License. - + ODBC Release Notes otp_appnotes nil @@ -30,41 +30,51 @@

This document describes the changes made to the odbc application.

- +
ODBC 2.10.8 - -
Improvements and New Features - - + +
Improvements and New Features + +

- ODBC now handles the types SQL_WCHAR and SQL_WVARCHAR. - ODBC also has a new connection option to return all - strings as binaries and also expect strings to be - binaries in the param_query function. This provides some - but not a full unicode support.

+ ODBC now handles the types SQL_WCHAR and SQL_WVARCHAR. + Thanks to Juhani Ränkimies. ODBC also has a new + connection option to return all strings as binaries and + also expect strings to be binaries in the param_query + function. These changes provides some unicode support.

- Own Id: OTP-7452

+ Own Id: OTP-7452

 - -
- -
- -
ODBC 2.10.7 - -
Fixed Bugs and Malfunctions -

- The odbc application can now be compiled on FreeBSD. - (Thanks to Kenji Rikitake.)

+ Now supports SQL_TYPE_TIMESTAMP on the format {{YY, MM, + DD}, {HH, MM, SS}}. Thanks to Juhani Ränkimies.

+

+ *** POTENTIAL INCOMPATIBILITY ***

- Own Id: OTP-8444

+ Own Id: OTP-8511
+
+ +
ODBC 2.10.7 + +
Fixed Bugs and Malfunctions + + +

+ The odbc application can now be compiled on FreeBSD. + (Thanks to Kenji Rikitake.)

+

+ Own Id: OTP-8444

+ + +
+ +
Improvements and New Features diff --git a/lib/odbc/doc/src/odbc.xml b/lib/odbc/doc/src/odbc.xml index 3efbac8dd4..70d8cfbe22 100644 --- a/lib/odbc/doc/src/odbc.xml +++ b/lib/odbc/doc/src/odbc.xml @@ -311,7 +311,7 @@ capital letters, alas it is not currently supported by the param_query function. Too know which Erlang data type corresponds to an ODBC data type see the Erlang to ODBC - data typemapping in the User's Guide.

+ data type mapping in the User's Guide.

-- cgit v1.2.3