Changeset vendor,10

Timestamp:

11/05/2008 08:42:21 PM (18 years ago)

Author:

raverkamp

revision id:

svn-v3-trunk1:1c22b0a8-4d0b-0410-a296-af6a2e6f35e3:plain-odbc%2Ftrunk:16

Message:

small changes

File:

• vendor/doc/notes.html (modified) (7 diffs)

vendor/doc/notes.html

@@ -7 +7 @@
     <h3>Notes</h3>
     <p> This documents contains some observations and pitfalls encountered 
-        when using different drivers and databases. 
-    </p>
+      when using different drivers and databases. Of course this list is not complete.
+      Also some of these problems might have vanished in the mean time. </p>
     <h4> driver-connect </h4>
     Using driver-connect one does not have to create an ODBC datasource for every 
@@ -21 +21 @@
       <li> using an Oracle Driver "DRIVER=Oracle in oracl92;UID=SCOTT;PWD=tiger;server=ltrav1"
     </ul>
-    One way to get a connection string is to create a file dsn and have a look at its contants, note that userid and password are encrypted in this file,
+    One way to get a connection string is to create a file dsn and have a look at its contants, 
+    note that userid and password are encrypted in this file,
     
     
@@ -203 +204 @@
 Query OK, 0 rows affected (0.00 sec)
 
-MySQL> desc bla2;
+MySQL&gt; desc bla2;
 +-------+----------+------+-----+---------+-------+
 | Field | Type     | Null | Key | Default | Extra |
@@ -307 +308 @@
 Another option is to select the parameters directly in the stored procedure. 
 Thus instead of having out or in/out parameters, the procedure returns
-return values as a result set. Note that <tt>exec-query<tt> accepts parameters 
+return values as a result set. Note that <tt>exec-query</tt> accepts parameters 
 and can return more than one result set. One example, assume 
 <tt>*con*</tt> is a MySQL connection.
@@ -343 +344 @@
       Error while executing the query, error code 7, State: 42704.
 </pre>
-According to the documentation one has to run lo.sql from the contrib section.
+According to the documentation one has to run lo.sql from the contrib section. 
+Blobs Columns have to be declared as of type <tt>lo</tt>.
 <h5> SQL Parser</h5>
 The parser is buggy.
@@ -373 +375 @@
 
 
-<h5> PG SQL</h5>
+<h5> PostgreSQL, 8.3</h5>
 Creating a function like
 <pre>
@@ -385 +387 @@
 same as the name of the parameter. This is a well known feature.
 <h5> Out Parameters </h5>
-Out parameter will be returned will normaly as out parameters. But the 
-function needs to have return type record and the return values are
-returned result set with just row.
-
+Out parameter will be returned as out parameters. But a function with 
+out parameters must have as a return type record and the return values are
+returned as a result set with just one row.
 </body>
 </html>