📄 complete.html
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"><html><head><title>Determine If An SQL Statement Is Complete</title><style type="text/css">body { margin: auto; font-family: "Verdana" "sans-serif"; padding: 8px 1%;}a { color: #45735f }a:visited { color: #734559 }.logo { position:absolute; margin:3px; }.tagline { float:right; text-align:right; font-style:italic; width:240px; margin:12px; margin-top:58px;}.toolbar { font-variant: small-caps; text-align: center; line-height: 1.6em; margin: 0; padding:1px 8px;}.toolbar a { color: white; text-decoration: none; padding: 6px 12px; }.toolbar a:visited { color: white; }.toolbar a:hover { color: #80a796; background: white; }.content { margin: 5%; }.content dt { font-weight:bold; }.content dd { margin-bottom: 25px; margin-left:20%; }.content ul { padding:0px; padding-left: 15px; margin:0px; }/* rounded corners */.se { background: url(../images/se.png) 100% 100% no-repeat #80a796}.sw { background: url(../images/sw.png) 0% 100% no-repeat }.ne { background: url(../images/ne.png) 100% 0% no-repeat }.nw { background: url(../images/nw.png) 0% 0% no-repeat }</style><meta http-equiv="content-type" content="text/html; charset=UTF-8"> </head><body><div><!-- container div to satisfy validator --><a href="../index.html"><img class="logo" src="../images/SQLite.gif" alt="SQLite Logo" border="0"></a><div><!-- IE hack to prevent disappearing logo--></div><div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div><table width=100% style="clear:both"><tr><td> <div class="se"><div class="sw"><div class="ne"><div class="nw"> <div class="toolbar"> <a href="../about.html">About</a> <a href="../sitemap.html">Sitemap</a> <a href="../docs.html">Documentation</a> <a href="../download.html">Download</a> <a href="../copyright.html">License</a> <a href="../news.html">News</a> <a href="http://www.sqlite.org/cvstrac/index">Developers</a> <a href="../support.html">Support</a> </div></div></div></div></div></td></tr></table> <a href="intro.html"><h2>SQLite C Interface</h2></a><h2>Determine If An SQL Statement Is Complete</h2><blockquote><pre>int sqlite3_complete(const char *sql);int sqlite3_complete16(const void *sql);</pre></blockquote><p>These routines are useful for command-line input to determine if thecurrently entered text seems to form complete a SQL statement orif additional input is needed before sending the text intoSQLite for parsing. These routines return true if the input stringappears to be a complete SQL statement. A statement is judged to becomplete if it ends with a semicolon token and is not a fragment of aCREATE TRIGGER statement. Semicolons that are embedded withinstring literals or quoted identifier names or comments are notindependent tokens (they are part of the token in which they areembedded) and thus do not count as a statement terminator.</p><p>These routines do not parse the SQL statements thuswill not detect syntactically incorrect SQL.</p><p><h3>Invariants:</h3><table border="0" cellpadding="5" cellspacing="0"><tr><td valign="top">H10511</td> <td valign="top">A successful evaluation of <a href="../c3ref/complete.html">sqlite3_complete()</a> or<a href="../c3ref/complete.html">sqlite3_complete16()</a> functions shallreturn a numeric 1 if and only if the last non-whitespacetoken in their input is a semicolon that is not in betweenthe BEGIN and END of a CREATE TRIGGER statement.</td></tr><tr><td valign="top">H10512</td> <td valign="top">If a memory allocation error occurs during an invocationof <a href="../c3ref/complete.html">sqlite3_complete()</a> or <a href="../c3ref/complete.html">sqlite3_complete16()</a> then theroutine shall return <a href="../c3ref/c_abort.html">SQLITE_NOMEM</a>.</td></tr></table></p><p><h3>Assumptions:</h3><table border="0" cellpadding="5" cellspacing="0"><tr><td valign="top">A10512</td> <td valign="top">The input to <a href="../c3ref/complete.html">sqlite3_complete()</a> must be a zero-terminatedUTF-8 string.</td></tr><tr><td valign="top">A10513</td> <td valign="top">The input to <a href="../c3ref/complete.html">sqlite3_complete16()</a> must be a zero-terminatedUTF-16 string in native byte order.</td></tr></table></p><p>See also lists of <a href="objlist.html">Objects</a>, <a href="constlist.html">Constants</a>, and <a href="funclist.html">Functions</a>.</p><hr><small><i>This page last modified 2008/08/11 17:57:43 UTC</i></small></div></body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -