Debian Codegraph @

www/c3ref/complete.html

raw
1 <!DOCTYPE html>
2 <html><head>
3 <meta name="viewport" content="width=device-width, initial-scale=1.0">
4 <meta http-equiv="content-type" content="text/html; charset=UTF-8">
5 <link href="../sqlite.css" rel="stylesheet">
6 <title>Determine If An SQL Statement Is Complete</title>
7 <!-- path=../ -->
8 </head>
9 <body>
10 <div class=nosearch>
11 <a href="../index.html">
12 <img class="logo" src="../images/sqlite370_banner.svg" alt="SQLite" border="0">
13 </a>
14 <div><!-- IE hack to prevent disappearing logo --></div>
15 <div class="tagline desktoponly">
16 Small. Fast. Reliable.<br>Choose any three.
17 </div>
18 <div class="menu mainmenu">
19 <ul>
20 <li><a href="../index.html">Home</a>
21 <li class='mobileonly'><a href="javascript:void(0)" onclick='toggle_div("submenu")'>Menu</a>
22 <li class='wideonly'><a href='../about.html'>About</a>
23 <li class='desktoponly'><a href="../docs.html">Documentation</a>
24 <li class='desktoponly'><a href="../download.html">Download</a>
25 <li class='wideonly'><a href='../copyright.html'>License</a>
26 <li class='desktoponly'><a href="../support.html">Support</a>
27 <li class='desktoponly'><a href="../prosupport.html">Purchase</a>
28 <li class='search' id='search_menubutton'>
29 <a href="javascript:void(0)" onclick='toggle_search()'>Search</a>
30 </ul>
31 </div>
32 <div class="menu submenu" id="submenu">
33 <ul>
34 <li><a href='../about.html'>About</a>
35 <li><a href='../docs.html'>Documentation</a>
36 <li><a href='../download.html'>Download</a>
37 <li><a href='../support.html'>Support</a>
38 <li><a href='../prosupport.html'>Purchase</a>
39 </ul>
40 </div>
41 <div class="searchmenu" id="searchmenu">
42 <form method="GET" action="../search">
43 <select name="s" id="searchtype">
44 <option value="d">Search Documentation</option>
45 <option value="c">Search Changelog</option>
46 </select>
47 <input type="text" name="q" id="searchbox" value="">
48 <input type="submit" value="Go">
49 </form>
50 </div>
51 </div>
52 <script>
53 function toggle_div(nm) {
54 var w = document.getElementById(nm);
55 if( w.style.display=="block" ){
56 w.style.display = "none";
57 }else{
58 w.style.display = "block";
59 }
60 }
61 function toggle_search() {
62 var w = document.getElementById("searchmenu");
63 if( w.style.display=="block" ){
64 w.style.display = "none";
65 } else {
66 w.style.display = "block";
67 setTimeout(function(){
68 document.getElementById("searchbox").focus()
69 }, 30);
70 }
71 }
72 function div_off(nm){document.getElementById(nm).style.display="none";}
73 window.onbeforeunload = function(e){div_off("submenu");}
74 /* Disable the Search feature if we are not operating from CGI, since */
75 /* Search is accomplished using CGI and will not work without it. */
76 if( !location.origin || !location.origin.match || !location.origin.match(/http/) ){
77 document.getElementById("search_menubutton").style.display = "none";
78 }
79 /* Used by the Hide/Show button beside syntax diagrams, to toggle the */
80 function hideorshow(btn,obj){
81 var x = document.getElementById(obj);
82 var b = document.getElementById(btn);
83 if( x.style.display!='none' ){
84 x.style.display = 'none';
85 b.innerHTML='show';
86 }else{
87 x.style.display = '';
88 b.innerHTML='hide';
89 }
90 return false;
91 }
92 var antiRobot = 0;
93 function antiRobotGo(){
94 if( antiRobot!=3 ) return;
95 antiRobot = 7;
96 var j = document.getElementById("mtimelink");
97 if(j && j.hasAttribute("data-href")) j.href=j.getAttribute("data-href");
98 }
99 function antiRobotDefense(){
100 document.body.onmousedown=function(){
101 antiRobot |= 2;
102 antiRobotGo();
103 document.body.onmousedown=null;
104 }
105 document.body.onmousemove=function(){
106 antiRobot |= 2;
107 antiRobotGo();
108 document.body.onmousemove=null;
109 }
110 setTimeout(function(){
111 antiRobot |= 1;
112 antiRobotGo();
113 }, 100)
114 antiRobotGo();
115 }
116 antiRobotDefense();
117 </script>
118 <!-- keywords: sqlite3_complete sqlite3_complete16 -->
119 <div class=nosearch>
120 <a href="../c3ref/intro.html"><h2>SQLite C Interface</h2></a>
121 <h2>Determine If An SQL Statement Is Complete</h2>
122 </div>
123 <blockquote><pre>
124 int sqlite3_complete(const char *sql);
125 int sqlite3_complete16(const void *sql);
126 </pre></blockquote>
127 <p>
128 These routines are useful during command-line input to determine if the
129 currently entered text seems to form a complete SQL statement or
130 if additional input is needed before sending the text into
131 SQLite for parsing. These routines return 1 if the input string
132 appears to be a complete SQL statement. A statement is judged to be
133 complete if it ends with a semicolon token and is not a prefix of a
134 well-formed CREATE TRIGGER statement. Semicolons that are embedded within
135 string literals or quoted identifier names or comments are not
136 independent tokens (they are part of the token in which they are
137 embedded) and thus do not count as a statement terminator. Whitespace
138 and comments that follow the final semicolon are ignored.</p>
139
140 <p>These routines return 0 if the statement is incomplete. If a
141 memory allocation fails, then SQLITE_NOMEM is returned.</p>
142
143 <p>These routines do not parse the SQL statements and thus
144 will not detect syntactically incorrect SQL.</p>
145
146 <p>If SQLite has not been initialized using <a href="../c3ref/initialize.html">sqlite3_initialize()</a> prior
147 to invoking sqlite3_complete16() then sqlite3_initialize() is invoked
148 automatically by sqlite3_complete16(). If that initialization fails,
149 then the return value from sqlite3_complete16() will be non-zero
150 regardless of whether or not the input SQL is complete.</p>
151
152 <p>The input to <a href="../c3ref/complete.html">sqlite3_complete()</a> must be a zero-terminated
153 UTF-8 string.</p>
154
155 <p>The input to <a href="../c3ref/complete.html">sqlite3_complete16()</a> must be a zero-terminated
156 UTF-16 string in native byte order.
157 </p><p>See also lists of
158 <a href="../c3ref/objlist.html">Objects</a>,
159 <a href="../c3ref/constlist.html">Constants</a>, and
160 <a href="../c3ref/funclist.html">Functions</a>.</p>
161