| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455 |
- <!DOCTYPE HTML>
- <html>
- <head>
- <meta http-equiv="Content-Type" content="html/html; charset=utf-8" />
- <title>FMDatabase(FMDatabaseAdditions) Category Reference</title>
- <meta id="xcode-display" name="xcode-display" content="render"/>
- <meta name="viewport" content="width=550" />
- <link rel="stylesheet" type="text/css" href="../css/styles.css" media="all" />
- <link rel="stylesheet" type="text/css" media="print" href="../css/stylesPrint.css" />
- <meta name="generator" content="appledoc 2.1 (build 858)" />
- </head>
- <body>
- <header id="top_header">
- <div id="library" class="hideInXcode">
- <h1><a id="libraryTitle" href="../index.html">FMDB </a></h1>
- <a id="developerHome" href="../index.html">ccgus</a>
- </div>
-
- <div id="title" role="banner">
- <h1 class="hideInXcode">FMDatabase(FMDatabaseAdditions) Category Reference</h1>
- </div>
- <ul id="headerButtons" role="toolbar">
- <li id="toc_button">
- <button aria-label="Show Table of Contents" role="checkbox" class="open" id="table_of_contents"><span class="disclosure"></span>Table of Contents</button>
- </li>
- <li id="jumpto_button" role="navigation">
- <select id="jumpTo">
- <option value="top">Jump To…</option>
-
- <option value="overview">Overview</option>
-
-
-
-
- <option value="tasks">Tasks</option>
-
-
-
-
-
-
-
-
-
- <option value="instance_methods">Instance Methods</option>
-
- <option value="//api/name/applicationID"> - applicationID</option>
-
- <option value="//api/name/applicationIDString"> - applicationIDString</option>
-
- <option value="//api/name/boolForQuery:"> - boolForQuery:</option>
-
- <option value="//api/name/columnExists:columnName:"> - columnExists:columnName:</option>
-
- <option value="//api/name/columnExists:inTableWithName:"> - columnExists:inTableWithName:</option>
-
- <option value="//api/name/dataForQuery:"> - dataForQuery:</option>
-
- <option value="//api/name/dateForQuery:"> - dateForQuery:</option>
-
- <option value="//api/name/doubleForQuery:"> - doubleForQuery:</option>
-
- <option value="//api/name/getSchema"> - getSchema</option>
-
- <option value="//api/name/getTableSchema:"> - getTableSchema:</option>
-
- <option value="//api/name/intForQuery:"> - intForQuery:</option>
-
- <option value="//api/name/longForQuery:"> - longForQuery:</option>
-
- <option value="//api/name/setApplicationID:"> - setApplicationID:</option>
-
- <option value="//api/name/setApplicationIDString:"> - setApplicationIDString:</option>
-
- <option value="//api/name/stringForQuery:"> - stringForQuery:</option>
-
- <option value="//api/name/tableExists:"> - tableExists:</option>
-
- <option value="//api/name/validateSQL:error:"> - validateSQL:error:</option>
-
-
-
- </select>
- </li>
- </ul>
- </header>
- <nav id="tocContainer" class="isShowingTOC">
- <ul id="toc" role="tree">
-
- <li role="treeitem"><span class="nodisclosure"></span><span class="sectionName"><a href="#overview">Overview</a></span></li>
- <li role="treeitem" id="task_treeitem"><span class="nodisclosure"></span><span class="sectionName"><a href="#tasks">Tasks</a></span><ul>
-
- <li><span class="nodisclosure"></span><span class="sectionName"><a href="#task_Return results of SQL to variable">Return results of SQL to variable</a></span></li>
-
- <li><span class="nodisclosure"></span><span class="sectionName"><a href="#task_Schema related operations">Schema related operations</a></span></li>
-
- <li><span class="nodisclosure"></span><span class="sectionName"><a href="#task_Application identifier tasks">Application identifier tasks</a></span></li>
-
- </ul></li>
- <li role="treeitem" class="children"><span class="disclosure"></span><span class="sectionName"><a href="#instance_methods">Instance Methods</a></span><ul>
-
- <li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/applicationID">applicationID</a></span></li>
-
- <li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/applicationIDString">applicationIDString</a></span></li>
-
- <li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/boolForQuery:">boolForQuery:</a></span></li>
-
- <li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/columnExists:columnName:">columnExists:columnName:</a></span></li>
-
- <li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/columnExists:inTableWithName:">columnExists:inTableWithName:</a></span></li>
-
- <li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/dataForQuery:">dataForQuery:</a></span></li>
-
- <li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/dateForQuery:">dateForQuery:</a></span></li>
-
- <li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/doubleForQuery:">doubleForQuery:</a></span></li>
-
- <li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/getSchema">getSchema</a></span></li>
-
- <li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/getTableSchema:">getTableSchema:</a></span></li>
-
- <li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/intForQuery:">intForQuery:</a></span></li>
-
- <li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/longForQuery:">longForQuery:</a></span></li>
-
- <li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/setApplicationID:">setApplicationID:</a></span></li>
-
- <li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/setApplicationIDString:">setApplicationIDString:</a></span></li>
-
- <li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/stringForQuery:">stringForQuery:</a></span></li>
-
- <li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/tableExists:">tableExists:</a></span></li>
-
- <li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/validateSQL:error:">validateSQL:error:</a></span></li>
-
- </ul></li>
- </ul>
- </nav>
- <article>
- <div id="contents" class="isShowingTOC" role="main">
- <a title="FMDatabase(FMDatabaseAdditions) Category Reference" name="top"></a>
- <div class="main-navigation navigation-top">
- <ul>
- <li><a href="../index.html">Index</a></li>
- <li><a href="../hierarchy.html">Hierarchy</a></li>
- </ul>
- </div>
- <div id="header">
- <div class="section-header">
- <h1 class="title title-header">FMDatabase(FMDatabaseAdditions) Category Reference</h1>
- </div>
- </div>
- <div id="container">
-
- <div class="section section-specification"><table cellspacing="0"><tbody>
- <tr>
- <td class="specification-title">Declared in</td>
- <td class="specification-value">FMDatabaseAdditions.h<br />FMDatabaseAdditions.m</td>
- </tr>
- </tbody></table></div>
-
-
-
-
- <div class="section section-overview">
- <a title="Overview" name="overview"></a>
- <h2 class="subtitle subtitle-overview">Overview</h2>
- <p>Category of additions for <a href="../Classes/FMDatabase.html"><code>FMDatabase</code></a> class.</p>
- <h3>See also</h3>
- <ul>
- <li><a href="../Classes/FMDatabase.html"><code>FMDatabase</code></a></li>
- </ul>
- </div>
-
-
-
-
-
- <div class="section section-tasks">
- <a title="Tasks" name="tasks"></a>
- <h2 class="subtitle subtitle-tasks">Tasks</h2>
-
-
- <a title="Return results of SQL to variable" name="task_Return results of SQL to variable"></a>
- <h3 class="subsubtitle task-title">Return results of SQL to variable</h3>
- <ul class="task-list">
- <li>
- <span class="tooltip">
- <code><a href="#//api/name/intForQuery:">– intForQuery:</a></code>
- <span class="tooltip"><p>Return <code>int</code> value for query</p></span>
- </span>
-
-
- </li><li>
- <span class="tooltip">
- <code><a href="#//api/name/longForQuery:">– longForQuery:</a></code>
- <span class="tooltip"><p>Return <code>long</code> value for query</p></span>
- </span>
-
-
- </li><li>
- <span class="tooltip">
- <code><a href="#//api/name/boolForQuery:">– boolForQuery:</a></code>
- <span class="tooltip"><p>Return <code>BOOL</code> value for query</p></span>
- </span>
-
-
- </li><li>
- <span class="tooltip">
- <code><a href="#//api/name/doubleForQuery:">– doubleForQuery:</a></code>
- <span class="tooltip"><p>Return <code>double</code> value for query</p></span>
- </span>
-
-
- </li><li>
- <span class="tooltip">
- <code><a href="#//api/name/stringForQuery:">– stringForQuery:</a></code>
- <span class="tooltip"><p>Return <code>NSString</code> value for query</p></span>
- </span>
-
-
- </li><li>
- <span class="tooltip">
- <code><a href="#//api/name/dataForQuery:">– dataForQuery:</a></code>
- <span class="tooltip"><p>Return <code>NSData</code> value for query</p></span>
- </span>
-
-
- </li><li>
- <span class="tooltip">
- <code><a href="#//api/name/dateForQuery:">– dateForQuery:</a></code>
- <span class="tooltip"><p>Return <code>NSDate</code> value for query</p></span>
- </span>
-
-
- </li>
- </ul>
-
-
- <a title="Schema related operations" name="task_Schema related operations"></a>
- <h3 class="subsubtitle task-title">Schema related operations</h3>
- <ul class="task-list">
- <li>
- <span class="tooltip">
- <code><a href="#//api/name/tableExists:">– tableExists:</a></code>
- <span class="tooltip"><p>Does table exist in database?</p></span>
- </span>
-
-
- </li><li>
- <span class="tooltip">
- <code><a href="#//api/name/getSchema">– getSchema</a></code>
- <span class="tooltip"><p>The schema of the database.</p></span>
- </span>
-
-
- </li><li>
- <span class="tooltip">
- <code><a href="#//api/name/getTableSchema:">– getTableSchema:</a></code>
- <span class="tooltip"><p>The schema of the database.</p></span>
- </span>
-
-
- </li><li>
- <span class="tooltip">
- <code><a href="#//api/name/columnExists:inTableWithName:">– columnExists:inTableWithName:</a></code>
- <span class="tooltip"><p>Test to see if particular column exists for particular table in database</p></span>
- </span>
-
-
- </li><li>
- <span class="tooltip">
- <code><a href="#//api/name/columnExists:columnName:">– columnExists:columnName:</a></code>
- <span class="tooltip"><p>Test to see if particular column exists for particular table in database</p></span>
- </span>
-
-
- </li><li>
- <span class="tooltip">
- <code><a href="#//api/name/validateSQL:error:">– validateSQL:error:</a></code>
- <span class="tooltip"><p>Validate SQL statement</p></span>
- </span>
-
-
- </li>
- </ul>
-
-
- <a title="Application identifier tasks" name="task_Application identifier tasks"></a>
- <h3 class="subsubtitle task-title">Application identifier tasks</h3>
- <ul class="task-list">
- <li>
- <span class="tooltip">
- <code><a href="#//api/name/applicationID">– applicationID</a></code>
- <span class="tooltip"><p>Retrieve application ID</p></span>
- </span>
-
-
- </li><li>
- <span class="tooltip">
- <code><a href="#//api/name/setApplicationID:">– setApplicationID:</a></code>
- <span class="tooltip"><p>Set the application ID</p></span>
- </span>
-
-
- </li><li>
- <span class="tooltip">
- <code><a href="#//api/name/applicationIDString">– applicationIDString</a></code>
- <span class="tooltip"><p>Retrieve application ID string</p></span>
- </span>
-
-
- </li><li>
- <span class="tooltip">
- <code><a href="#//api/name/setApplicationIDString:">– setApplicationIDString:</a></code>
- <span class="tooltip"><p>Set the application ID string</p></span>
- </span>
-
-
- </li>
- </ul>
-
- </div>
-
-
-
-
-
-
-
-
-
- <div class="section section-methods">
- <a title="Instance Methods" name="instance_methods"></a>
- <h2 class="subtitle subtitle-methods">Instance Methods</h2>
-
- <div class="section-method">
- <a name="//api/name/applicationID" title="applicationID"></a>
- <h3 class="subsubtitle method-title">applicationID</h3>
-
-
-
- <div class="method-subsection brief-description">
- <p>Retrieve application ID</p>
- </div>
-
-
- <div class="method-subsection method-declaration"><code>- (uint32_t)applicationID</code></div>
-
-
-
-
- <div class="method-subsection return">
- <h4 class="method-subtitle parameter-title">Return Value</h4>
- <p>The <code>uint32_t</code> numeric value of the application ID.</p>
- </div>
-
-
-
-
-
-
-
-
-
- <div class="method-subsection see-also-section">
- <h4 class="method-subtitle">See Also</h4>
- <ul>
-
- <li><code><p><a href="#//api/name/setApplicationID:">- setApplicationID:</a></p></code></li>
-
- </ul>
- </div>
-
-
-
- <div class="method-subsection declared-in-section">
- <h4 class="method-subtitle">Declared In</h4>
- <code class="declared-in-ref">FMDatabaseAdditions.h</code><br />
- </div>
-
-
- </div>
-
- <div class="section-method">
- <a name="//api/name/applicationIDString" title="applicationIDString"></a>
- <h3 class="subsubtitle method-title">applicationIDString</h3>
-
-
-
- <div class="method-subsection brief-description">
- <p>Retrieve application ID string</p>
- </div>
-
-
- <div class="method-subsection method-declaration"><code>- (NSString *)applicationIDString</code></div>
-
-
-
-
- <div class="method-subsection return">
- <h4 class="method-subtitle parameter-title">Return Value</h4>
- <p>The <code>NSString</code> value of the application ID.</p>
- </div>
-
-
-
-
-
-
-
-
-
- <div class="method-subsection see-also-section">
- <h4 class="method-subtitle">See Also</h4>
- <ul>
-
- <li><code><p><a href="#//api/name/setApplicationIDString:">- setApplicationIDString:</a></p></code></li>
-
- </ul>
- </div>
-
-
-
- <div class="method-subsection declared-in-section">
- <h4 class="method-subtitle">Declared In</h4>
- <code class="declared-in-ref">FMDatabaseAdditions.h</code><br />
- </div>
-
-
- </div>
-
- <div class="section-method">
- <a name="//api/name/boolForQuery:" title="boolForQuery:"></a>
- <h3 class="subsubtitle method-title">boolForQuery:</h3>
-
-
-
- <div class="method-subsection brief-description">
- <p>Return <code>BOOL</code> value for query</p>
- </div>
-
-
- <div class="method-subsection method-declaration"><code>- (BOOL)boolForQuery:(NSString *)<em>query</em>, <em>...</em></code></div>
-
-
- <div class="method-subsection arguments-section parameters">
- <h4 class="method-subtitle parameter-title">Parameters</h4>
-
- <dl class="argument-def parameter-def">
- <dt><em>query</em></dt>
- <dd><p>The SQL query to be performed.</p></dd>
- </dl>
-
- <dl class="argument-def parameter-def">
- <dt><em>...</em></dt>
- <dd><p>A list of parameters that will be bound to the <code>?</code> placeholders in the SQL query.</p></dd>
- </dl>
-
- </div>
-
-
-
- <div class="method-subsection return">
- <h4 class="method-subtitle parameter-title">Return Value</h4>
- <p><code>BOOL</code> value.</p>
- </div>
-
-
-
-
-
-
-
-
-
-
-
- <div class="method-subsection declared-in-section">
- <h4 class="method-subtitle">Declared In</h4>
- <code class="declared-in-ref">FMDatabaseAdditions.h</code><br />
- </div>
-
-
- </div>
-
- <div class="section-method">
- <a name="//api/name/columnExists:columnName:" title="columnExists:columnName:"></a>
- <h3 class="subsubtitle method-title">columnExists:columnName:</h3>
-
-
-
- <div class="method-subsection brief-description">
- <p>Test to see if particular column exists for particular table in database</p>
- </div>
-
-
- <div class="method-subsection method-declaration"><code>- (BOOL)columnExists:(NSString *)<em>tableName</em> columnName:(NSString *)<em>columnName</em></code></div>
-
-
- <div class="method-subsection arguments-section parameters">
- <h4 class="method-subtitle parameter-title">Parameters</h4>
-
- <dl class="argument-def parameter-def">
- <dt><em>tableName</em></dt>
- <dd><p>The name of the table.</p></dd>
- </dl>
-
- <dl class="argument-def parameter-def">
- <dt><em>columnName</em></dt>
- <dd><p>The name of the column.</p></dd>
- </dl>
-
- </div>
-
-
-
- <div class="method-subsection return">
- <h4 class="method-subtitle parameter-title">Return Value</h4>
- <p><code>YES</code> if column exists in table in question; <code>NO</code> otherwise.</p>
- </div>
-
-
-
-
-
- <div class="method-subsection discussion-section">
- <h4 class="method-subtitle">Discussion</h4>
- <div class="warning"><p><strong>Warning:</strong> Deprecated - use <a href="#//api/name/columnExists:inTableWithName:"><code>columnExists:inTableWithName:</code></a> instead.</p></div>
- </div>
-
-
-
-
-
- <div class="method-subsection see-also-section">
- <h4 class="method-subtitle">See Also</h4>
- <ul>
-
- <li><code><p><a href="#//api/name/columnExists:inTableWithName:">- columnExists:inTableWithName:</a></p></code></li>
-
- </ul>
- </div>
-
-
-
- <div class="method-subsection declared-in-section">
- <h4 class="method-subtitle">Declared In</h4>
- <code class="declared-in-ref">FMDatabaseAdditions.h</code><br />
- </div>
-
-
- </div>
-
- <div class="section-method">
- <a name="//api/name/columnExists:inTableWithName:" title="columnExists:inTableWithName:"></a>
- <h3 class="subsubtitle method-title">columnExists:inTableWithName:</h3>
-
-
-
- <div class="method-subsection brief-description">
- <p>Test to see if particular column exists for particular table in database</p>
- </div>
-
-
- <div class="method-subsection method-declaration"><code>- (BOOL)columnExists:(NSString *)<em>columnName</em> inTableWithName:(NSString *)<em>tableName</em></code></div>
-
-
- <div class="method-subsection arguments-section parameters">
- <h4 class="method-subtitle parameter-title">Parameters</h4>
-
- <dl class="argument-def parameter-def">
- <dt><em>columnName</em></dt>
- <dd><p>The name of the column.</p></dd>
- </dl>
-
- <dl class="argument-def parameter-def">
- <dt><em>tableName</em></dt>
- <dd><p>The name of the table.</p></dd>
- </dl>
-
- </div>
-
-
-
- <div class="method-subsection return">
- <h4 class="method-subtitle parameter-title">Return Value</h4>
- <p><code>YES</code> if column exists in table in question; <code>NO</code> otherwise.</p>
- </div>
-
-
-
-
-
-
-
-
-
-
-
- <div class="method-subsection declared-in-section">
- <h4 class="method-subtitle">Declared In</h4>
- <code class="declared-in-ref">FMDatabaseAdditions.h</code><br />
- </div>
-
-
- </div>
-
- <div class="section-method">
- <a name="//api/name/dataForQuery:" title="dataForQuery:"></a>
- <h3 class="subsubtitle method-title">dataForQuery:</h3>
-
-
-
- <div class="method-subsection brief-description">
- <p>Return <code>NSData</code> value for query</p>
- </div>
-
-
- <div class="method-subsection method-declaration"><code>- (NSData *)dataForQuery:(NSString *)<em>query</em>, <em>...</em></code></div>
-
-
- <div class="method-subsection arguments-section parameters">
- <h4 class="method-subtitle parameter-title">Parameters</h4>
-
- <dl class="argument-def parameter-def">
- <dt><em>query</em></dt>
- <dd><p>The SQL query to be performed.</p></dd>
- </dl>
-
- <dl class="argument-def parameter-def">
- <dt><em>...</em></dt>
- <dd><p>A list of parameters that will be bound to the <code>?</code> placeholders in the SQL query.</p></dd>
- </dl>
-
- </div>
-
-
-
- <div class="method-subsection return">
- <h4 class="method-subtitle parameter-title">Return Value</h4>
- <p><code>NSData</code> value.</p>
- </div>
-
-
-
-
-
-
-
-
-
-
-
- <div class="method-subsection declared-in-section">
- <h4 class="method-subtitle">Declared In</h4>
- <code class="declared-in-ref">FMDatabaseAdditions.h</code><br />
- </div>
-
-
- </div>
-
- <div class="section-method">
- <a name="//api/name/dateForQuery:" title="dateForQuery:"></a>
- <h3 class="subsubtitle method-title">dateForQuery:</h3>
-
-
-
- <div class="method-subsection brief-description">
- <p>Return <code>NSDate</code> value for query</p>
- </div>
-
-
- <div class="method-subsection method-declaration"><code>- (NSDate *)dateForQuery:(NSString *)<em>query</em>, <em>...</em></code></div>
-
-
- <div class="method-subsection arguments-section parameters">
- <h4 class="method-subtitle parameter-title">Parameters</h4>
-
- <dl class="argument-def parameter-def">
- <dt><em>query</em></dt>
- <dd><p>The SQL query to be performed.</p></dd>
- </dl>
-
- <dl class="argument-def parameter-def">
- <dt><em>...</em></dt>
- <dd><p>A list of parameters that will be bound to the <code>?</code> placeholders in the SQL query.</p></dd>
- </dl>
-
- </div>
-
-
-
- <div class="method-subsection return">
- <h4 class="method-subtitle parameter-title">Return Value</h4>
- <p><code>NSDate</code> value.</p>
- </div>
-
-
-
-
-
-
-
-
-
-
-
- <div class="method-subsection declared-in-section">
- <h4 class="method-subtitle">Declared In</h4>
- <code class="declared-in-ref">FMDatabaseAdditions.h</code><br />
- </div>
-
-
- </div>
-
- <div class="section-method">
- <a name="//api/name/doubleForQuery:" title="doubleForQuery:"></a>
- <h3 class="subsubtitle method-title">doubleForQuery:</h3>
-
-
-
- <div class="method-subsection brief-description">
- <p>Return <code>double</code> value for query</p>
- </div>
-
-
- <div class="method-subsection method-declaration"><code>- (double)doubleForQuery:(NSString *)<em>query</em>, <em>...</em></code></div>
-
-
- <div class="method-subsection arguments-section parameters">
- <h4 class="method-subtitle parameter-title">Parameters</h4>
-
- <dl class="argument-def parameter-def">
- <dt><em>query</em></dt>
- <dd><p>The SQL query to be performed.</p></dd>
- </dl>
-
- <dl class="argument-def parameter-def">
- <dt><em>...</em></dt>
- <dd><p>A list of parameters that will be bound to the <code>?</code> placeholders in the SQL query.</p></dd>
- </dl>
-
- </div>
-
-
-
- <div class="method-subsection return">
- <h4 class="method-subtitle parameter-title">Return Value</h4>
- <p><code>double</code> value.</p>
- </div>
-
-
-
-
-
-
-
-
-
-
-
- <div class="method-subsection declared-in-section">
- <h4 class="method-subtitle">Declared In</h4>
- <code class="declared-in-ref">FMDatabaseAdditions.h</code><br />
- </div>
-
-
- </div>
-
- <div class="section-method">
- <a name="//api/name/getSchema" title="getSchema"></a>
- <h3 class="subsubtitle method-title">getSchema</h3>
-
-
-
- <div class="method-subsection brief-description">
- <p>The schema of the database.</p>
- </div>
-
-
- <div class="method-subsection method-declaration"><code>- (FMResultSet *)getSchema</code></div>
-
-
-
-
- <div class="method-subsection return">
- <h4 class="method-subtitle parameter-title">Return Value</h4>
- <p><code>FMResultSet</code> of schema; <code>nil</code> on error.</p>
- </div>
-
-
-
-
-
- <div class="method-subsection discussion-section">
- <h4 class="method-subtitle">Discussion</h4>
- <p>This will be the schema for the entire database. For each entity, each row of the result set will include the following fields:</p>
- <ul>
- <li><code>type</code> - The type of entity (e.g. table, index, view, or trigger)</li>
- <li><code>name</code> - The name of the object</li>
- <li><code>tbl_name</code> - The name of the table to which the object references</li>
- <li><code>rootpage</code> - The page number of the root b-tree page for tables and indices</li>
- <li><code>sql</code> - The SQL that created the entity</li>
- </ul>
- </div>
-
-
-
-
-
- <div class="method-subsection see-also-section">
- <h4 class="method-subtitle">See Also</h4>
- <ul>
-
- <li><code><p><a href="http://www.sqlite.org/fileformat.html">SQLite File Format</a></p></code></li>
-
- </ul>
- </div>
-
-
-
- <div class="method-subsection declared-in-section">
- <h4 class="method-subtitle">Declared In</h4>
- <code class="declared-in-ref">FMDatabaseAdditions.h</code><br />
- </div>
-
-
- </div>
-
- <div class="section-method">
- <a name="//api/name/getTableSchema:" title="getTableSchema:"></a>
- <h3 class="subsubtitle method-title">getTableSchema:</h3>
-
-
-
- <div class="method-subsection brief-description">
- <p>The schema of the database.</p>
- </div>
-
-
- <div class="method-subsection method-declaration"><code>- (FMResultSet *)getTableSchema:(NSString *)<em>tableName</em></code></div>
-
-
- <div class="method-subsection arguments-section parameters">
- <h4 class="method-subtitle parameter-title">Parameters</h4>
-
- <dl class="argument-def parameter-def">
- <dt><em>tableName</em></dt>
- <dd><p>The name of the table for whom the schema will be returned.</p></dd>
- </dl>
-
- </div>
-
-
-
- <div class="method-subsection return">
- <h4 class="method-subtitle parameter-title">Return Value</h4>
- <p><code>FMResultSet</code> of schema; <code>nil</code> on error.</p>
- </div>
-
-
-
-
-
- <div class="method-subsection discussion-section">
- <h4 class="method-subtitle">Discussion</h4>
- <p>This will be the schema for a particular table as report by SQLite <code>PRAGMA</code>, for example:</p>
- <pre><code>PRAGMA table_info('employees')
- </code></pre>
- <p>This will report:</p>
- <ul>
- <li><code>cid</code> - The column ID number</li>
- <li><code>name</code> - The name of the column</li>
- <li><code>type</code> - The data type specified for the column</li>
- <li><code>notnull</code> - whether the field is defined as NOT NULL (i.e. values required)</li>
- <li><code>dflt_value</code> - The default value for the column</li>
- <li><code>pk</code> - Whether the field is part of the primary key of the table</li>
- </ul>
- </div>
-
-
-
-
-
- <div class="method-subsection see-also-section">
- <h4 class="method-subtitle">See Also</h4>
- <ul>
-
- <li><code><p><a href="http://www.sqlite.org/pragma.html#pragma_table_info">table_info</a></p></code></li>
-
- </ul>
- </div>
-
-
-
- <div class="method-subsection declared-in-section">
- <h4 class="method-subtitle">Declared In</h4>
- <code class="declared-in-ref">FMDatabaseAdditions.h</code><br />
- </div>
-
-
- </div>
-
- <div class="section-method">
- <a name="//api/name/intForQuery:" title="intForQuery:"></a>
- <h3 class="subsubtitle method-title">intForQuery:</h3>
-
-
-
- <div class="method-subsection brief-description">
- <p>Return <code>int</code> value for query</p>
- </div>
-
-
- <div class="method-subsection method-declaration"><code>- (int)intForQuery:(NSString *)<em>query</em>, <em>...</em></code></div>
-
-
- <div class="method-subsection arguments-section parameters">
- <h4 class="method-subtitle parameter-title">Parameters</h4>
-
- <dl class="argument-def parameter-def">
- <dt><em>query</em></dt>
- <dd><p>The SQL query to be performed.</p></dd>
- </dl>
-
- <dl class="argument-def parameter-def">
- <dt><em>...</em></dt>
- <dd><p>A list of parameters that will be bound to the <code>?</code> placeholders in the SQL query.</p></dd>
- </dl>
-
- </div>
-
-
-
- <div class="method-subsection return">
- <h4 class="method-subtitle parameter-title">Return Value</h4>
- <p><code>int</code> value.</p>
- </div>
-
-
-
-
-
-
-
-
-
-
-
- <div class="method-subsection declared-in-section">
- <h4 class="method-subtitle">Declared In</h4>
- <code class="declared-in-ref">FMDatabaseAdditions.h</code><br />
- </div>
-
-
- </div>
-
- <div class="section-method">
- <a name="//api/name/longForQuery:" title="longForQuery:"></a>
- <h3 class="subsubtitle method-title">longForQuery:</h3>
-
-
-
- <div class="method-subsection brief-description">
- <p>Return <code>long</code> value for query</p>
- </div>
-
-
- <div class="method-subsection method-declaration"><code>- (long)longForQuery:(NSString *)<em>query</em>, <em>...</em></code></div>
-
-
- <div class="method-subsection arguments-section parameters">
- <h4 class="method-subtitle parameter-title">Parameters</h4>
-
- <dl class="argument-def parameter-def">
- <dt><em>query</em></dt>
- <dd><p>The SQL query to be performed.</p></dd>
- </dl>
-
- <dl class="argument-def parameter-def">
- <dt><em>...</em></dt>
- <dd><p>A list of parameters that will be bound to the <code>?</code> placeholders in the SQL query.</p></dd>
- </dl>
-
- </div>
-
-
-
- <div class="method-subsection return">
- <h4 class="method-subtitle parameter-title">Return Value</h4>
- <p><code>long</code> value.</p>
- </div>
-
-
-
-
-
-
-
-
-
-
-
- <div class="method-subsection declared-in-section">
- <h4 class="method-subtitle">Declared In</h4>
- <code class="declared-in-ref">FMDatabaseAdditions.h</code><br />
- </div>
-
-
- </div>
-
- <div class="section-method">
- <a name="//api/name/setApplicationID:" title="setApplicationID:"></a>
- <h3 class="subsubtitle method-title">setApplicationID:</h3>
-
-
-
- <div class="method-subsection brief-description">
- <p>Set the application ID</p>
- </div>
-
-
- <div class="method-subsection method-declaration"><code>- (void)setApplicationID:(uint32_t)<em>appID</em></code></div>
-
-
- <div class="method-subsection arguments-section parameters">
- <h4 class="method-subtitle parameter-title">Parameters</h4>
-
- <dl class="argument-def parameter-def">
- <dt><em>appID</em></dt>
- <dd><p>The <code>uint32_t</code> numeric value of the application ID.</p></dd>
- </dl>
-
- </div>
-
-
-
-
-
-
-
-
-
-
-
- <div class="method-subsection see-also-section">
- <h4 class="method-subtitle">See Also</h4>
- <ul>
-
- <li><code><p><a href="#//api/name/applicationID">- applicationID</a></p></code></li>
-
- </ul>
- </div>
-
-
-
- <div class="method-subsection declared-in-section">
- <h4 class="method-subtitle">Declared In</h4>
- <code class="declared-in-ref">FMDatabaseAdditions.h</code><br />
- </div>
-
-
- </div>
-
- <div class="section-method">
- <a name="//api/name/setApplicationIDString:" title="setApplicationIDString:"></a>
- <h3 class="subsubtitle method-title">setApplicationIDString:</h3>
-
-
-
- <div class="method-subsection brief-description">
- <p>Set the application ID string</p>
- </div>
-
-
- <div class="method-subsection method-declaration"><code>- (void)setApplicationIDString:(NSString *)<em>string</em></code></div>
-
-
- <div class="method-subsection arguments-section parameters">
- <h4 class="method-subtitle parameter-title">Parameters</h4>
-
- <dl class="argument-def parameter-def">
- <dt><em>string</em></dt>
- <dd><p>The <code>NSString</code> value of the application ID.</p></dd>
- </dl>
-
- </div>
-
-
-
-
-
-
-
-
-
-
-
- <div class="method-subsection see-also-section">
- <h4 class="method-subtitle">See Also</h4>
- <ul>
-
- <li><code><p><a href="#//api/name/applicationIDString">- applicationIDString</a></p></code></li>
-
- </ul>
- </div>
-
-
-
- <div class="method-subsection declared-in-section">
- <h4 class="method-subtitle">Declared In</h4>
- <code class="declared-in-ref">FMDatabaseAdditions.h</code><br />
- </div>
-
-
- </div>
-
- <div class="section-method">
- <a name="//api/name/stringForQuery:" title="stringForQuery:"></a>
- <h3 class="subsubtitle method-title">stringForQuery:</h3>
-
-
-
- <div class="method-subsection brief-description">
- <p>Return <code>NSString</code> value for query</p>
- </div>
-
-
- <div class="method-subsection method-declaration"><code>- (NSString *)stringForQuery:(NSString *)<em>query</em>, <em>...</em></code></div>
-
-
- <div class="method-subsection arguments-section parameters">
- <h4 class="method-subtitle parameter-title">Parameters</h4>
-
- <dl class="argument-def parameter-def">
- <dt><em>query</em></dt>
- <dd><p>The SQL query to be performed.</p></dd>
- </dl>
-
- <dl class="argument-def parameter-def">
- <dt><em>...</em></dt>
- <dd><p>A list of parameters that will be bound to the <code>?</code> placeholders in the SQL query.</p></dd>
- </dl>
-
- </div>
-
-
-
- <div class="method-subsection return">
- <h4 class="method-subtitle parameter-title">Return Value</h4>
- <p><code>NSString</code> value.</p>
- </div>
-
-
-
-
-
-
-
-
-
-
-
- <div class="method-subsection declared-in-section">
- <h4 class="method-subtitle">Declared In</h4>
- <code class="declared-in-ref">FMDatabaseAdditions.h</code><br />
- </div>
-
-
- </div>
-
- <div class="section-method">
- <a name="//api/name/tableExists:" title="tableExists:"></a>
- <h3 class="subsubtitle method-title">tableExists:</h3>
-
-
-
- <div class="method-subsection brief-description">
- <p>Does table exist in database?</p>
- </div>
-
-
- <div class="method-subsection method-declaration"><code>- (BOOL)tableExists:(NSString *)<em>tableName</em></code></div>
-
-
- <div class="method-subsection arguments-section parameters">
- <h4 class="method-subtitle parameter-title">Parameters</h4>
-
- <dl class="argument-def parameter-def">
- <dt><em>tableName</em></dt>
- <dd><p>The name of the table being looked for.</p></dd>
- </dl>
-
- </div>
-
-
-
- <div class="method-subsection return">
- <h4 class="method-subtitle parameter-title">Return Value</h4>
- <p><code>YES</code> if table found; <code>NO</code> if not found.</p>
- </div>
-
-
-
-
-
-
-
-
-
-
-
- <div class="method-subsection declared-in-section">
- <h4 class="method-subtitle">Declared In</h4>
- <code class="declared-in-ref">FMDatabaseAdditions.h</code><br />
- </div>
-
-
- </div>
-
- <div class="section-method">
- <a name="//api/name/validateSQL:error:" title="validateSQL:error:"></a>
- <h3 class="subsubtitle method-title">validateSQL:error:</h3>
-
-
-
- <div class="method-subsection brief-description">
- <p>Validate SQL statement</p>
- </div>
-
-
- <div class="method-subsection method-declaration"><code>- (BOOL)validateSQL:(NSString *)<em>sql</em> error:(NSError **)<em>error</em></code></div>
-
-
- <div class="method-subsection arguments-section parameters">
- <h4 class="method-subtitle parameter-title">Parameters</h4>
-
- <dl class="argument-def parameter-def">
- <dt><em>sql</em></dt>
- <dd><p>The SQL statement being validated.</p></dd>
- </dl>
-
- <dl class="argument-def parameter-def">
- <dt><em>error</em></dt>
- <dd><p>This is a pointer to a <code>NSError</code> object that will receive the autoreleased <code>NSError</code> object if there was any error. If this is <code>nil</code>, no <code>NSError</code> result will be returned.</p></dd>
- </dl>
-
- </div>
-
-
-
- <div class="method-subsection return">
- <h4 class="method-subtitle parameter-title">Return Value</h4>
- <p><code>YES</code> if validation succeeded without incident; <code>NO</code> otherwise.</p>
- </div>
-
-
-
-
-
- <div class="method-subsection discussion-section">
- <h4 class="method-subtitle">Discussion</h4>
- <p>This validates SQL statement by performing <code>sqlite3_prepare_v2</code>, but not returning the results, but instead immediately calling <code>sqlite3_finalize</code>.</p>
- </div>
-
-
-
-
-
-
-
- <div class="method-subsection declared-in-section">
- <h4 class="method-subtitle">Declared In</h4>
- <code class="declared-in-ref">FMDatabaseAdditions.h</code><br />
- </div>
-
-
- </div>
-
- </div>
-
-
- </div>
- <div class="main-navigation navigation-bottom">
- <ul>
- <li><a href="../index.html">Index</a></li>
- <li><a href="../hierarchy.html">Hierarchy</a></li>
- </ul>
- </div>
- <div id="footer">
- <hr />
- <div class="footer-copyright">
- <p><span class="copyright">© 2013 ccgus. All rights reserved. (Last updated: 2013-08-06)</span><br />
-
- <span class="generator">Generated by <a href="http://appledoc.gentlebytes.com">appledoc 2.1 (build 858)</a>.</span></p>
-
- </div>
- </div>
- </div>
- </article>
- <script type="text/javascript">
- function jumpToChange()
- {
- window.location.hash = this.options[this.selectedIndex].value;
- }
-
- function toggleTOC()
- {
- var contents = document.getElementById('contents');
- var tocContainer = document.getElementById('tocContainer');
-
- if (this.getAttribute('class') == 'open')
- {
- this.setAttribute('class', '');
- contents.setAttribute('class', '');
- tocContainer.setAttribute('class', '');
-
- window.name = "hideTOC";
- }
- else
- {
- this.setAttribute('class', 'open');
- contents.setAttribute('class', 'isShowingTOC');
- tocContainer.setAttribute('class', 'isShowingTOC');
-
- window.name = "";
- }
- return false;
- }
-
- function toggleTOCEntryChildren(e)
- {
- e.stopPropagation();
- var currentClass = this.getAttribute('class');
- if (currentClass == 'children') {
- this.setAttribute('class', 'children open');
- }
- else if (currentClass == 'children open') {
- this.setAttribute('class', 'children');
- }
- return false;
- }
-
- function tocEntryClick(e)
- {
- e.stopPropagation();
- return true;
- }
-
- function init()
- {
- var selectElement = document.getElementById('jumpTo');
- selectElement.addEventListener('change', jumpToChange, false);
-
- var tocButton = document.getElementById('table_of_contents');
- tocButton.addEventListener('click', toggleTOC, false);
-
- var taskTreeItem = document.getElementById('task_treeitem');
- if (taskTreeItem.getElementsByTagName('li').length > 0)
- {
- taskTreeItem.setAttribute('class', 'children');
- taskTreeItem.firstChild.setAttribute('class', 'disclosure');
- }
-
- var tocList = document.getElementById('toc');
-
- var tocEntries = tocList.getElementsByTagName('li');
- for (var i = 0; i < tocEntries.length; i++) {
- tocEntries[i].addEventListener('click', toggleTOCEntryChildren, false);
- }
-
- var tocLinks = tocList.getElementsByTagName('a');
- for (var i = 0; i < tocLinks.length; i++) {
- tocLinks[i].addEventListener('click', tocEntryClick, false);
- }
-
- if (window.name == "hideTOC") {
- toggleTOC.call(tocButton);
- }
- }
-
- window.onload = init;
-
- // If showing in Xcode, hide the TOC and Header
- if (navigator.userAgent.match(/xcode/i)) {
- document.getElementById("contents").className = "hideInXcode"
- document.getElementById("tocContainer").className = "hideInXcode"
- document.getElementById("top_header").className = "hideInXcode"
- }
-
- </script>
- </body>
- </html>
|