|
1 | 1 | <!-- |
2 | | -$Header: /cvsroot/pgsql/doc/src/sgml/ecpg.sgml,v 1.49 2003/08/31 17:32:18 petere Exp $ |
| 2 | +$Header: /cvsroot/pgsql/doc/src/sgml/ecpg.sgml,v 1.50 2003/09/09 10:54:44 meskes Exp $ |
3 | 3 | --> |
4 | 4 |
|
5 | 5 | <chapter id="ecpg"> |
@@ -296,6 +296,7 @@ EXEC SQL SELECT foo INTO :FooBar FROM table1 WHERE ascii = 'doodad'; |
296 | 296 | EXEC SQL DECLARE foo_bar CURSOR FOR |
297 | 297 | SELECT number, ascii FROM foo |
298 | 298 | ORDER BY ascii; |
| 299 | +EXEC SQL OPEN foo_bar; |
299 | 300 | EXEC SQL FETCH foo_bar INTO :FooBar, DooDad; |
300 | 301 | ... |
301 | 302 | EXEC SQL CLOSE foo_bar; |
@@ -450,8 +451,8 @@ char foo[16], bar[16]; |
450 | 451 | </para> |
451 | 452 |
|
452 | 453 | <para> |
453 | | - The specialtypes <type>VARCHAR</type>and <type>VARCHAR2</type> |
454 | | -are converted into a named <type>struct</> for every variable. A |
| 454 | + The specialtype <type>VARCHAR</type> |
| 455 | +is converted into a named <type>struct</> for every variable. A |
455 | 456 | declaration like |
456 | 457 | <programlisting> |
457 | 458 | VARCHAR var[180]; |
@@ -1787,8 +1788,8 @@ ECPG = ecpg |
1787 | 1788 | EXEC SQL OPEN <replaceable>cursor</replaceable>; |
1788 | 1789 | </programlisting> |
1789 | 1790 | is not copied to the output. Instead, the cursor's |
1790 | | - <command>DECLARE</> command is usedbecause it opensthecursor as |
1791 | | -well. |
| 1791 | + <command>DECLARE</> command is usedat the position ofthe<command>OPEN</> command |
| 1792 | +because it indeed opens the cursor. |
1792 | 1793 | </para> |
1793 | 1794 |
|
1794 | 1795 | <para> |
|
