Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\userguide\salesforce.27.19.html
<?xml version="1.0" encoding="utf-8"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xml:lang="en" lang="en" xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html;charset=utf-8" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <!-- MOTW-DISABLED saved from url=(0014)about:internet --> <title>Parameter Metadata Support</title> <link rel="StyleSheet" href="css/salesforce.css" type="text/css" media="all" /> <link rel="StyleSheet" href="css/webworks.css" type="text/css" media="all" /> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/context.js"></script> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/towwhdir.js"></script> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/wwhpagef.js"></script> <script type="text/javascript" language="JavaScript1.2"> <!-- var WebWorksRootPath = ""; // --> </script> <script type="text/javascript" language="JavaScript1.2"> <!-- // Set reference to top level help frame // var WWHFrame = WWHGetWWHFrame("", true); // --> </script> <script type="text/javascript" language="JavaScript1.2" src="scripts/expand.js"></script> </head> <body class="" style="background-color: #FFFFEE;" onload="WWHUpdate();" onunload="WWHUnload();" onkeydown="WWHHandleKeyDown((document.all||document.getElementById||document.layers)?event:null);" onkeypress="WWHHandleKeyPress((document.all||document.getElementById||document.layers)?event:null);" onkeyup="WWHHandleKeyUp((document.all||document.getElementById||document.layers)?event:null);"> <br /> <div class="WebWorks_Breadcrumbs" style="text-align: left;"> <a class="WebWorks_Breadcrumb_Link" href="salesforce.27.01.html#1548286">21 The Salesforce Driver</a> : Parameter Metadata Support</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="1548286">Parameter Metadata Support</a></div> <div class="Body"><a name="1548287">The Salesforce driver supports returning parameter metadata as described in this section.</a></div> <div class="head_2"><a name="1548288">Insert and Update Statements</a></div> <div class="Body"><a name="1548289">The Salesforce driver supports returning parameter metadata for the following forms of </a>Insert and Update statements:</div> <div class="list_bulleted_outer" style="margin-left: 0pt;vertical-align: baseline;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;color: #000000; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner" style="color: #000000; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none;"><span class="Syntax"><a name="1548290">INSERT INTO foo VALUES(?, ?, ?)</a></span></div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;vertical-align: baseline;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;color: #000000; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner" style="color: #000000; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none;"><span class="Syntax"><a name="1548291">INSERT INTO foo (col1, col2, col3) VALUES(?, ?, ?)</a></span></div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;vertical-align: baseline;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;color: #000000; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner" style="color: #000000; font-style: normal; font-variant: normal; font-weight: normal; text-transform: none;"><span class="Syntax"><a name="1548292">UPDATE foo SET col1=?, col2=?, col3=? WHERE col1 </a></span><span class="EquationVariables">operator </span><span class="Syntax">? [{AND | OR}</span><span class="Syntax"><br /></span><span class="Syntax">col2</span><span class="Syntax"> </span><span class="EquationVariables">operator</span><span class="Syntax"> ?]</span></div> </td> </tr> </table> </div> <div class="Body"><a name="1548293">where </a><span class="EquationVariables">operator</span> is any of the following SQL operators: <span class="Syntax">=</span>, <span class="Syntax"><</span>, <span class="Syntax">></span>, <span class="Syntax"><=</span>, <span class="Syntax">>=</span>, and <span class="Syntax"><></span>.</div> <div class="head_2"><a name="1548294">Select Statements</a></div> <div class="Body"><a name="1548295">The Salesforce driver supports returning parameter metadata for Select statements that </a>contain parameters in ANSI SQL 92 entry-level predicates, for example, such as COMPARISON, BETWEEN, IN, LIKE, and EXISTS predicate constructs. Refer to the ANSI SQL reference for detailed syntax.</div> <div class="Body"><a name="1548296">Parameter metadata can be returned for a Select statement if one of the following </a>conditions is true:</div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="1548297">The statement contains a predicate value expression that can be targeted against the </a>source tables in the associated FROM clause. For example: </div> </td> </tr> </table> </div> <div class="syntax_embed_first"><a name="1548298">SELECT * FROM foo WHERE bar > ?</a></div> <div class="Body_Indent"><a name="1548299">In this case, the value expression "bar" can be targeted against the table "foo" to </a>determine the appropriate metadata for the parameter.</div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="1548300">The statement contains a predicate value expression part that is a nested query. The </a>nested query's metadata must describe a single column. For example: </div> </td> </tr> </table> </div> <div class="syntax_embed_first"><a name="1548301">SELECT * FROM foo WHERE (SELECT x FROM y WHERE z = 1) < ?</a></div> <div class="Body"><a name="1548302">The following Select statements show further examples for which parameter metadata can </a>be returned:</div> <div class="syntax_first"><a name="1548303">SELECT col1, col2 FROM foo WHERE col1 = ? and col2 > ?</a></div> <div class="syntax_first"><a name="1548304">SELECT ... WHERE colname = (SELECT col2 FROM t2 WHERE col3 = ?)</a></div> <div class="syntax_first"><a name="1548305">SELECT ... WHERE colname LIKE ?</a></div> <div class="syntax_first"><a name="1548306">SELECT ... WHERE colname BETWEEN ? and ?</a></div> <div class="syntax_first"><a name="1548307">SELECT ... WHERE colname IN (?, ?, ?)</a></div> <div class="syntax_first"><a name="1548308">SELECT ... WHERE EXISTS(SELECT ... FROM T2 WHERE col1 < ?)</a></div> <div class="Body"><a name="1548309">ANSI SQL 92 entry-level predicates in a WHERE clause containing GROUP BY, HAVING, </a>or ORDER BY statements are supported. For example:</div> <div class="syntax_first"><a name="1548310">SELECT * FROM t1 WHERE col = ? ORDER BY 1</a></div> <div class="Body"><a name="1548311">Joins are supported. For example: </a></div> <div class="syntax_first"><a name="1548312">SELECT * FROM t1,t2 WHERE t1.col1 = ?</a></div> <div class="Body"><a name="1548313">Fully qualified names and aliases are supported. For example: </a></div> <div class="syntax_first"><a name="1548314">SELECT a, b, c, d FROM T1 AS A, T2 AS B WHERE A.a = ? and B.b = ?"</a></div> <script type="text/javascript" language="JavaScript1.2"> <!-- // Clear related topics // WWHClearRelatedTopics(); document.writeln(WWHRelatedTopicsInlineHTML()); // --> </script> </blockquote> <script type="text/javascript" language="JavaScript1.2"> <!-- document.write(WWHRelatedTopicsDivTag() + WWHPopupDivTag() + WWHALinksDivTag()); // --> </script> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de