Author: shawkins
Date: 2009-07-21 22:53:09 -0400 (Tue, 21 Jul 2009)
New Revision: 1167
Modified:
trunk/documentation/reference/src/main/docbook/en-US/content/procedures.xml
Log:
fixing minor typo
Modified: trunk/documentation/reference/src/main/docbook/en-US/content/procedures.xml
===================================================================
--- trunk/documentation/reference/src/main/docbook/en-US/content/procedures.xml 2009-07-22
02:48:37 UTC (rev 1166)
+++ trunk/documentation/reference/src/main/docbook/en-US/content/procedures.xml 2009-07-22
02:53:09 UTC (rev 1167)
@@ -68,7 +68,7 @@
DECLARE string sql_string = 'SELECT ID, First || ‘‘ ‘‘ || Last AS Name, Birthdate
FROM Customer.Accounts WHERE ' || criteria;
/* The execution of the SQL string will create the #temp table with the columns (ID,
Name, Birthdate).
Note that we also have the USING clause to bind a value to LastName, which is
referenced in the criteria. */
-EXECUTE STRING sql_string; AS ID integer, Name string, Birthdate date INTO #temp USING
LastName='some name';
+EXECUTE STRING sql_string AS ID integer, Name string, Birthdate date INTO #temp USING
LastName='some name';
/* The temp table can now be used with the values from the Dynamic SQL */
loop on (SELCT ID from #temp) as myCursor
...</programlisting>