Home Explore Help
Sign In
mirror
/
fmdb
2
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: f954bad943
Branches Tags
fmdb
/
html
/
Classes
/
FMDatabase.html

FMDatabase.html 137 KB
History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679268026812682268326842685268626872688268926902691269226932694269526962697269826992700270127022703270427052706270727082709271027112712271327142715271627172718271927202721272227232724272527262727272827292730273127322733273427352736273727382739274027412742274327442745274627472748274927502751275227532754275527562757275827592760276127622763276427652766276727682769277027712772277327742775277627772778277927802781278227832784278527862787278827892790279127922793279427952796279727982799280028012802280328042805280628072808280928102811281228132814281528162817281828192820282128222823282428252826282728282829283028312832283328342835283628372838283928402841284228432844284528462847284828492850285128522853285428552856285728582859286028612862286328642865286628672868286928702871287228732874287528762877287828792880288128822883288428852886288728882889289028912892289328942895289628972898289929002901290229032904290529062907290829092910291129122913291429152916291729182919292029212922292329242925292629272928292929302931293229332934293529362937293829392940294129422943294429452946294729482949295029512952295329542955295629572958295929602961296229632964296529662967296829692970297129722973297429752976297729782979298029812982298329842985298629872988298929902991299229932994299529962997299829993000300130023003300430053006300730083009301030113012301330143015301630173018301930203021302230233024302530263027302830293030303130323033303430353036303730383039304030413042304330443045304630473048304930503051305230533054305530563057305830593060306130623063306430653066306730683069307030713072307330743075307630773078307930803081308230833084308530863087308830893090309130923093309430953096309730983099310031013102310331043105310631073108310931103111311231133114311531163117311831193120312131223123312431253126312731283129313031313132313331343135313631373138313931403141314231433144314531463147314831493150315131523153315431553156315731583159316031613162316331643165316631673168316931703171317231733174317531763177317831793180318131823183318431853186318731883189319031913192319331943195319631973198319932003201320232033204320532063207320832093210321132123213321432153216321732183219322032213222322332243225322632273228322932303231323232333234323532363237323832393240324132423243324432453246324732483249325032513252325332543255325632573258325932603261326232633264326532663267326832693270327132723273327432753276327732783279328032813282328332843285328632873288328932903291329232933294329532963297329832993300330133023303330433053306330733083309331033113312331333143315331633173318331933203321332233233324332533263327332833293330333133323333333433353336333733383339334033413342334333443345334633473348334933503351335233533354335533563357335833593360336133623363336433653366336733683369337033713372337333743375337633773378337933803381338233833384338533863387338833893390339133923393339433953396339733983399340034013402340334043405340634073408340934103411341234133414341534163417341834193420342134223423342434253426342734283429343034313432343334343435343634373438343934403441344234433444344534463447344834493450345134523453345434553456345734583459346034613462346334643465346634673468346934703471347234733474347534763477347834793480348134823483348434853486348734883489349034913492349334943495349634973498349935003501350235033504350535063507350835093510351135123513351435153516351735183519352035213522352335243525352635273528352935303531353235333534353535363537353835393540354135423543354435453546354735483549355035513552355335543555355635573558355935603561356235633564356535663567356835693570357135723573357435753576357735783579358035813582358335843585358635873588358935903591359235933594359535963597359835993600360136023603360436053606360736083609361036113612361336143615361636173618361936203621362236233624362536263627362836293630363136323633363436353636363736383639364036413642364336443645364636473648364936503651365236533654365536563657365836593660366136623663366436653666366736683669367036713672367336743675367636773678367936803681368236833684368536863687368836893690369136923693369436953696369736983699370037013702370337043705370637073708370937103711371237133714371537163717371837193720372137223723372437253726372737283729373037313732373337343735373637373738373937403741374237433744374537463747374837493750375137523753375437553756375737583759376037613762376337643765376637673768376937703771377237733774377537763777377837793780378137823783378437853786378737883789379037913792379337943795379637973798379938003801380238033804380538063807380838093810381138123813381438153816381738183819382038213822382338243825382638273828382938303831383238333834383538363837383838393840384138423843384438453846384738483849385038513852385338543855385638573858385938603861386238633864386538663867386838693870387138723873387438753876387738783879388038813882388338843885388638873888388938903891389238933894389538963897389838993900390139023903390439053906390739083909391039113912391339143915391639173918391939203921392239233924392539263927392839293930393139323933393439353936393739383939394039413942394339443945394639473948394939503951395239533954395539563957395839593960396139623963396439653966396739683969397039713972397339743975397639773978397939803981398239833984398539863987398839893990399139923993399439953996399739983999400040014002400340044005400640074008400940104011401240134014401540164017401840194020402140224023402440254026402740284029403040314032403340344035403640374038403940404041404240434044404540464047404840494050405140524053405440554056405740584059406040614062406340644065406640674068406940704071407240734074407540764077407840794080408140824083408440854086408740884089409040914092409340944095409640974098409941004101410241034104410541064107410841094110411141124113411441154116411741184119412041214122412341244125412641274128412941304131413241334134413541364137413841394140414141424143414441454146414741484149415041514152415341544155415641574158415941604161416241634164416541664167416841694170417141724173417441754176417741784179418041814182418341844185418641874188418941904191419241934194419541964197419841994200420142024203420442054206420742084209421042114212421342144215421642174218421942204221422242234224422542264227422842294230423142324233423442354236423742384239424042414242424342444245424642474248424942504251425242534254425542564257425842594260426142624263426442654266426742684269427042714272427342744275427642774278427942804281428242834284428542864287428842894290429142924293429442954296429742984299430043014302430343044305430643074308430943104311431243134314431543164317431843194320432143224323432443254326432743284329433043314332433343344335433643374338433943404341434243434344434543464347434843494350435143524353435443554356435743584359436043614362436343644365436643674368436943704371437243734374437543764377437843794380438143824383438443854386438743884389439043914392439343944395439643974398439944004401440244034404440544064407440844094410441144124413441444154416441744184419442044214422442344244425442644274428442944304431443244334434443544364437443844394440444144424443444444454446444744484449445044514452445344544455445644574458445944604461 
  1. <!DOCTYPE html>
    2. 

  2. <html>
    3. 

  3. <head>
    4. 

  4. 	<meta charset="utf-8">
    5. 

  5. 

  6. 	<title>FMDatabase Class Reference</title>
    7. 

  7. 

  8. 	<link rel="stylesheet" href="../css/style.css">
    9. 

  9. 	<meta name="viewport" content="initial-scale=1, maximum-scale=1.4">
    10. 

  10. 	<meta name="generator" content="appledoc 2.2.1 (build 1333)">
    11. 

  11. </head>
    12. 

  12. <body class="appledoc">
    13. 

  13. 	<header>
    14. 

  14. 		<div class="container" class="hide-in-xcode">
    15. 

  15. 			
    16. 

  16. 			<h1 id="library-title">
    17. 

  17. 				<a href="../index.html">FMDB </a>
    18. 

  18. 			</h1>
    19. 

  19. 

  20. 			<p id="developer-home">
    21. 

  21. 				<a href="../index.html">ccgus</a>
    22. 

  22. 			</p>
    23. 

  23. 			
    24. 

  24. 		</div>
    25. 

  25. 	</header>
    26. 

  26. 

  27. 	<aside>
    28. 

  28. 		<div class="container">
    29. 

  29. 			<nav>
    30. 

  30. 				<ul id="header-buttons" role="toolbar">
    31. 

  31. 					<li><a href="../index.html">Index</a></li>
    32. 

  32. <li><a href="../hierarchy.html">Hierarchy</a></li>
    33. 

  33. 

  34. 					<li id="on-this-page" role="navigation">
    35. 

  35. 						<label>
    36. 

  36. 							On This Page
    37. 

  37. 

  38. 							<div class="chevron">
    39. 

  39. 								<div class="chevy chevron-left"></div>
    40. 

  40. 								<div class="chevy chevron-right"></div>
    41. 

  41. 							</div>
    42. 

  42. 

  43. 							<select id="jump-to">
    44. 

  44. 	<option value="top">Jump To&#133;</option>
    45. 

  45. 	
    46. 

  46. 	<option value="overview">Overview</option>
    47. 

  47. 	
    48. 

  48. 

  49. 	
    50. 

  50. 	
    51. 

  51. 	<option value="tasks">Tasks</option>
    52. 

  52. 	
    53. 

  53. 	
    54. 

  54. 

  55. 	
    56. 

  56. 	
    57. 

  57. 	<optgroup label="Properties">
    58. 

  58. 		
    59. 

  59. 		<option value="//api/name/cachedStatements">cachedStatements</option>
    60. 

  60. 		
    61. 

  61. 		<option value="//api/name/checkedOut">checkedOut</option>
    62. 

  62. 		
    63. 

  63. 		<option value="//api/name/crashOnErrors">crashOnErrors</option>
    64. 

  64. 		
    65. 

  65. 		<option value="//api/name/logsErrors">logsErrors</option>
    66. 

  66. 		
    67. 

  67. 		<option value="//api/name/traceExecution">traceExecution</option>
    68. 

  68. 		
    69. 

  69. 	</optgroup>
    70. 

  70. 	
    71. 

  71. 

  72. 	
    73. 

  73. 	<optgroup label="Class Methods">
    74. 

  74. 		
    75. 

  75. 		<option value="//api/name/databaseWithPath:">+ databaseWithPath:</option>
    76. 

  76. 		
    77. 

  77. 		<option value="//api/name/isSQLiteThreadSafe">+ isSQLiteThreadSafe</option>
    78. 

  78. 		
    79. 

  79. 		<option value="//api/name/sqliteLibVersion">+ sqliteLibVersion</option>
    80. 

  80. 		
    81. 

  81. 		<option value="//api/name/storeableDateFormat:">+ storeableDateFormat:</option>
    82. 

  82. 		
    83. 

  83. 	</optgroup>
    84. 

  84. 	
    85. 

  85. 

  86. 	
    87. 

  87. 	<optgroup label="Instance Methods">
    88. 

  88. 		
    89. 

  89. 		<option value="//api/name/beginDeferredTransaction">- beginDeferredTransaction</option>
    90. 

  90. 		
    91. 

  91. 		<option value="//api/name/beginTransaction">- beginTransaction</option>
    92. 

  92. 		
    93. 

  93. 		<option value="//api/name/changes">- changes</option>
    94. 

  94. 		
    95. 

  95. 		<option value="//api/name/clearCachedStatements">- clearCachedStatements</option>
    96. 

  96. 		
    97. 

  97. 		<option value="//api/name/close">- close</option>
    98. 

  98. 		
    99. 

  99. 		<option value="//api/name/closeOpenResultSets">- closeOpenResultSets</option>
    100. 

  100. 		
    101. 

  101. 		<option value="//api/name/commit">- commit</option>
    102. 

  102. 		
    103. 

  103. 		<option value="//api/name/databasePath">- databasePath</option>
    104. 

  104. 		
    105. 

  105. 		<option value="//api/name/dateFromString:">- dateFromString:</option>
    106. 

  106. 		
    107. 

  107. 		<option value="//api/name/executeQuery:">- executeQuery:</option>
    108. 

  108. 		
    109. 

  109. 		<option value="//api/name/executeQuery:withArgumentsInArray:">- executeQuery:withArgumentsInArray:</option>
    110. 

  110. 		
    111. 

  111. 		<option value="//api/name/executeQuery:withParameterDictionary:">- executeQuery:withParameterDictionary:</option>
    112. 

  112. 		
    113. 

  113. 		<option value="//api/name/executeQueryWithFormat:">- executeQueryWithFormat:</option>
    114. 

  114. 		
    115. 

  115. 		<option value="//api/name/executeStatements:">- executeStatements:</option>
    116. 

  116. 		
    117. 

  117. 		<option value="//api/name/executeStatements:withResultBlock:">- executeStatements:withResultBlock:</option>
    118. 

  118. 		
    119. 

  119. 		<option value="//api/name/executeUpdate:">- executeUpdate:</option>
    120. 

  120. 		
    121. 

  121. 		<option value="//api/name/executeUpdate:withArgumentsInArray:">- executeUpdate:withArgumentsInArray:</option>
    122. 

  122. 		
    123. 

  123. 		<option value="//api/name/executeUpdate:withErrorAndBindings:">- executeUpdate:withErrorAndBindings:</option>
    124. 

  124. 		
    125. 

  125. 		<option value="//api/name/executeUpdate:withParameterDictionary:">- executeUpdate:withParameterDictionary:</option>
    126. 

  126. 		
    127. 

  127. 		<option value="//api/name/executeUpdate:withVAList:">- executeUpdate:withVAList:</option>
    128. 

  128. 		
    129. 

  129. 		<option value="//api/name/executeUpdateWithFormat:">- executeUpdateWithFormat:</option>
    130. 

  130. 		
    131. 

  131. 		<option value="//api/name/goodConnection">- goodConnection</option>
    132. 

  132. 		
    133. 

  133. 		<option value="//api/name/hadError">- hadError</option>
    134. 

  134. 		
    135. 

  135. 		<option value="//api/name/hasDateFormatter">- hasDateFormatter</option>
    136. 

  136. 		
    137. 

  137. 		<option value="//api/name/hasOpenResultSets">- hasOpenResultSets</option>
    138. 

  138. 		
    139. 

  139. 		<option value="//api/name/inSavePoint:">- inSavePoint:</option>
    140. 

  140. 		
    141. 

  141. 		<option value="//api/name/inTransaction">- inTransaction</option>
    142. 

  142. 		
    143. 

  143. 		<option value="//api/name/initWithPath:">- initWithPath:</option>
    144. 

  144. 		
    145. 

  145. 		<option value="//api/name/lastError">- lastError</option>
    146. 

  146. 		
    147. 

  147. 		<option value="//api/name/lastErrorCode">- lastErrorCode</option>
    148. 

  148. 		
    149. 

  149. 		<option value="//api/name/lastErrorMessage">- lastErrorMessage</option>
    150. 

  150. 		
    151. 

  151. 		<option value="//api/name/lastInsertRowId">- lastInsertRowId</option>
    152. 

  152. 		
    153. 

  153. 		<option value="//api/name/makeFunctionNamed:maximumArguments:withBlock:">- makeFunctionNamed:maximumArguments:withBlock:</option>
    154. 

  154. 		
    155. 

  155. 		<option value="//api/name/open">- open</option>
    156. 

  156. 		
    157. 

  157. 		<option value="//api/name/openWithFlags:">- openWithFlags:</option>
    158. 

  158. 		
    159. 

  159. 		<option value="//api/name/rekey:">- rekey:</option>
    160. 

  160. 		
    161. 

  161. 		<option value="//api/name/rekeyWithData:">- rekeyWithData:</option>
    162. 

  162. 		
    163. 

  163. 		<option value="//api/name/releaseSavePointWithName:error:">- releaseSavePointWithName:error:</option>
    164. 

  164. 		
    165. 

  165. 		<option value="//api/name/rollback">- rollback</option>
    166. 

  166. 		
    167. 

  167. 		<option value="//api/name/rollbackToSavePointWithName:error:">- rollbackToSavePointWithName:error:</option>
    168. 

  168. 		
    169. 

  169. 		<option value="//api/name/setDateFormat:">- setDateFormat:</option>
    170. 

  170. 		
    171. 

  171. 		<option value="//api/name/setKey:">- setKey:</option>
    172. 

  172. 		
    173. 

  173. 		<option value="//api/name/setKeyWithData:">- setKeyWithData:</option>
    174. 

  174. 		
    175. 

  175. 		<option value="//api/name/setShouldCacheStatements:">- setShouldCacheStatements:</option>
    176. 

  176. 		
    177. 

  177. 		<option value="//api/name/shouldCacheStatements">- shouldCacheStatements</option>
    178. 

  178. 		
    179. 

  179. 		<option value="//api/name/sqliteHandle">- sqliteHandle</option>
    180. 

  180. 		
    181. 

  181. 		<option value="//api/name/startSavePointWithName:error:">- startSavePointWithName:error:</option>
    182. 

  182. 		
    183. 

  183. 		<option value="//api/name/stringFromDate:">- stringFromDate:</option>
    184. 

  184. 		
    185. 

  185. 		<option value="//api/name/update:withErrorAndBindings:">- update:withErrorAndBindings:</option>
    186. 

  186. 		
    187. 

  187. 	</optgroup>
    188. 

  188. 	
    189. 

  189. 	
    190. 

  190. </select>
    191. 

  191. 						</label>
    192. 

  192. 					</li>
    193. 

  193. 				</ul>
    194. 

  194. 			</nav>
    195. 

  195. 		</div>
    196. 

  196. 	</aside>
    197. 

  197. 

  198. 	<article>
    199. 

  199. 		<div id="overview_contents" class="container">
    200. 

  200. 			<div id="content">
    201. 

  201. 				<main role="main">
    202. 

  202. 					<h1 class="title">FMDatabase Class Reference</h1>
    203. 

  203. 

  204. 					
    205. 

  205. 					<div class="section section-specification"><table cellspacing="0"><tbody>
    206. 

  206. 						<tr>
    207. 

  207. 	<th>Inherits from</th>
    208. 

  208. 	<td>NSObject</td>
    209. 

  209. </tr><tr>
    210. 

  210. 	<th>Declared in</th>
    211. 

  211. 	<td>FMDatabase.h</td>
    212. 

  212. </tr>
    213. 

  213. 						</tbody></table></div>
    214. 

  214. 					
    215. 

  215. 

  216.                     
    217. 

  217. 					
    218. 

  218. 					<div class="section section-overview">
    219. 

  219. 						<a title="Overview" name="overview"></a>
    220. 

  220. 						<h2 class="subtitle subtitle-overview">Overview</h2>
    221. 

  221. 						<p>A SQLite (<a href="http://sqlite.org/">http://sqlite.org/</a>) Objective-C wrapper.</p>
    222. 

  222. 

  223. <h3>Usage</h3>
    224. 

  224. 

  225. <p>The three main classes in FMDB are:</p>
    226. 

  226. 

  227. <ul>
    228. 

  228. <li><code>FMDatabase</code> - Represents a single SQLite database.  Used for executing SQL statements.</li>
    229. 

  229. <li><a href="../Classes/FMResultSet.html"><code>FMResultSet</code></a> - Represents the results of executing a query on an <code>FMDatabase</code>.</li>
    230. 

  230. <li><a href="../Classes/FMDatabaseQueue.html"><code>FMDatabaseQueue</code></a> - If you want to perform queries and updates on multiple threads, you&rsquo;ll want to use this class.</li>
    231. 

  231. </ul>
    232. 

  232. 

  233. 

  234. <h3>See also</h3>
    235. 

  235. 

  236. <ul>
    237. 

  237. <li><a href="../Classes/FMDatabasePool.html"><code>FMDatabasePool</code></a> - A pool of <code>FMDatabase</code> objects.</li>
    238. 

  238. <li><a href="../Classes/FMStatement.html"><code>FMStatement</code></a> - A wrapper for <code>sqlite_stmt</code>.</li>
    239. 

  239. </ul>
    240. 

  240. 

  241. 

  242. <h3>External links</h3>
    243. 

  243. 

  244. <ul>
    245. 

  245. <li><a href="https://github.com/ccgus/fmdb">FMDB on GitHub</a> including introductory documentation</li>
    246. 

  246. <li><a href="http://sqlite.org/">SQLite web site</a></li>
    247. 

  247. <li><a href="http://groups.google.com/group/fmdb">FMDB mailing list</a></li>
    248. 

  248. <li><a href="http://www.sqlite.org/faq.html">SQLite FAQ</a></li>
    249. 

  249. </ul>
    250. 

  250. <div class="warning"><p><strong>Warning:</strong> Do not instantiate a single <code>FMDatabase</code> object and use it across multiple threads. Instead, use <a href="../Classes/FMDatabaseQueue.html"><code>FMDatabaseQueue</code></a>.</p></div>
    251. 

  251. 					</div>
    252. 

  252. 					
    253. 

  253. 					
    254. 

  254. 

  255. 					
    256. 

  256. 					
    257. 

  257. 					<div class="section section-tasks">
    258. 

  258. 						<a title="Tasks" name="tasks"></a>
    259. 

  259. 						
    260. 

  260. 

  261. 						<a title="Properties" name="task_Properties"></a>
    262. 

  262. 						<h2 class="task-title">Properties</h2>
    263. 

  263. 

  264. 						<div class="task-list">
    265. 

  265. 							<div class="section-method">
    266. 

  266. 	<a name="//api/name/traceExecution" title="traceExecution"></a>
    267. 

  267. 	<h3 class="method-title"><code><a href="#//api/name/traceExecution">&nbsp;&nbsp;traceExecution</a></code>
    268. 

  268. </h3>
    269. 

  269. 

  270. 	<div class="method-info">
    271. 

  271. 		<div class="pointy-thing"></div>
    272. 

  272. 

  273. 		<div class="method-info-container">
    274. 

  274. 			
    275. 

  275. 			
    276. 

  276. 			<div class="method-subsection brief-description">
    277. 

  277. 				<p>Whether should trace execution</p>
    278. 

  278. 			</div>
    279. 

  279. 			
    280. 

  280. 		    
    281. 

  281. 

  282. 			<div class="method-subsection method-declaration"><code>@property (atomic, assign) BOOL traceExecution</code></div>
    283. 

  283. 

  284. 		    
    285. 

  285. 			
    286. 

  286. 

  287. 			
    288. 

  288. 

  289. 			
    290. 

  290. 

  291. 			
    292. 

  292. 			<div class="method-subsection discussion-section">
    293. 

  293. 				<h4 class="method-subtitle">Discussion</h4>
    294. 

  294. 				<p>Whether should trace execution</p>
    295. 

  295. 			</div>
    296. 

  296. 			
    297. 

  297. 

  298. 			
    299. 

  299. 

  300. 			
    301. 

  301. 

  302. 			
    303. 

  303. 			<div class="method-subsection declared-in-section">
    304. 

  304. 				<h4 class="method-subtitle">Declared In</h4>
    305. 

  305. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    306. 

  306. 			</div>
    307. 

  307. 			
    308. 

  308. 			
    309. 

  309. 		</div>
    310. 

  310. 	</div>
    311. 

  311. </div><div class="section-method">
    312. 

  312. 	<a name="//api/name/checkedOut" title="checkedOut"></a>
    313. 

  313. 	<h3 class="method-title"><code><a href="#//api/name/checkedOut">&nbsp;&nbsp;checkedOut</a></code>
    314. 

  314. </h3>
    315. 

  315. 

  316. 	<div class="method-info">
    317. 

  317. 		<div class="pointy-thing"></div>
    318. 

  318. 

  319. 		<div class="method-info-container">
    320. 

  320. 			
    321. 

  321. 			
    322. 

  322. 			<div class="method-subsection brief-description">
    323. 

  323. 				<p>Whether checked out or not</p>
    324. 

  324. 			</div>
    325. 

  325. 			
    326. 

  326. 		    
    327. 

  327. 

  328. 			<div class="method-subsection method-declaration"><code>@property (atomic, assign) BOOL checkedOut</code></div>
    329. 

  329. 

  330. 		    
    331. 

  331. 			
    332. 

  332. 

  333. 			
    334. 

  334. 

  335. 			
    336. 

  336. 

  337. 			
    338. 

  338. 			<div class="method-subsection discussion-section">
    339. 

  339. 				<h4 class="method-subtitle">Discussion</h4>
    340. 

  340. 				<p>Whether checked out or not</p>
    341. 

  341. 			</div>
    342. 

  342. 			
    343. 

  343. 

  344. 			
    345. 

  345. 

  346. 			
    347. 

  347. 

  348. 			
    349. 

  349. 			<div class="method-subsection declared-in-section">
    350. 

  350. 				<h4 class="method-subtitle">Declared In</h4>
    351. 

  351. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    352. 

  352. 			</div>
    353. 

  353. 			
    354. 

  354. 			
    355. 

  355. 		</div>
    356. 

  356. 	</div>
    357. 

  357. </div><div class="section-method">
    358. 

  358. 	<a name="//api/name/crashOnErrors" title="crashOnErrors"></a>
    359. 

  359. 	<h3 class="method-title"><code><a href="#//api/name/crashOnErrors">&nbsp;&nbsp;crashOnErrors</a></code>
    360. 

  360. </h3>
    361. 

  361. 

  362. 	<div class="method-info">
    363. 

  363. 		<div class="pointy-thing"></div>
    364. 

  364. 

  365. 		<div class="method-info-container">
    366. 

  366. 			
    367. 

  367. 			
    368. 

  368. 			<div class="method-subsection brief-description">
    369. 

  369. 				<p>Crash on errors</p>
    370. 

  370. 			</div>
    371. 

  371. 			
    372. 

  372. 		    
    373. 

  373. 

  374. 			<div class="method-subsection method-declaration"><code>@property (atomic, assign) BOOL crashOnErrors</code></div>
    375. 

  375. 

  376. 		    
    377. 

  377. 			
    378. 

  378. 

  379. 			
    380. 

  380. 

  381. 			
    382. 

  382. 

  383. 			
    384. 

  384. 			<div class="method-subsection discussion-section">
    385. 

  385. 				<h4 class="method-subtitle">Discussion</h4>
    386. 

  386. 				<p>Crash on errors</p>
    387. 

  387. 			</div>
    388. 

  388. 			
    389. 

  389. 

  390. 			
    391. 

  391. 

  392. 			
    393. 

  393. 

  394. 			
    395. 

  395. 			<div class="method-subsection declared-in-section">
    396. 

  396. 				<h4 class="method-subtitle">Declared In</h4>
    397. 

  397. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    398. 

  398. 			</div>
    399. 

  399. 			
    400. 

  400. 			
    401. 

  401. 		</div>
    402. 

  402. 	</div>
    403. 

  403. </div><div class="section-method">
    404. 

  404. 	<a name="//api/name/logsErrors" title="logsErrors"></a>
    405. 

  405. 	<h3 class="method-title"><code><a href="#//api/name/logsErrors">&nbsp;&nbsp;logsErrors</a></code>
    406. 

  406. </h3>
    407. 

  407. 

  408. 	<div class="method-info">
    409. 

  409. 		<div class="pointy-thing"></div>
    410. 

  410. 

  411. 		<div class="method-info-container">
    412. 

  412. 			
    413. 

  413. 			
    414. 

  414. 			<div class="method-subsection brief-description">
    415. 

  415. 				<p>Logs errors</p>
    416. 

  416. 			</div>
    417. 

  417. 			
    418. 

  418. 		    
    419. 

  419. 

  420. 			<div class="method-subsection method-declaration"><code>@property (atomic, assign) BOOL logsErrors</code></div>
    421. 

  421. 

  422. 		    
    423. 

  423. 			
    424. 

  424. 

  425. 			
    426. 

  426. 

  427. 			
    428. 

  428. 

  429. 			
    430. 

  430. 			<div class="method-subsection discussion-section">
    431. 

  431. 				<h4 class="method-subtitle">Discussion</h4>
    432. 

  432. 				<p>Logs errors</p>
    433. 

  433. 			</div>
    434. 

  434. 			
    435. 

  435. 

  436. 			
    437. 

  437. 

  438. 			
    439. 

  439. 

  440. 			
    441. 

  441. 			<div class="method-subsection declared-in-section">
    442. 

  442. 				<h4 class="method-subtitle">Declared In</h4>
    443. 

  443. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    444. 

  444. 			</div>
    445. 

  445. 			
    446. 

  446. 			
    447. 

  447. 		</div>
    448. 

  448. 	</div>
    449. 

  449. </div><div class="section-method">
    450. 

  450. 	<a name="//api/name/cachedStatements" title="cachedStatements"></a>
    451. 

  451. 	<h3 class="method-title"><code><a href="#//api/name/cachedStatements">&nbsp;&nbsp;cachedStatements</a></code>
    452. 

  452. </h3>
    453. 

  453. 

  454. 	<div class="method-info">
    455. 

  455. 		<div class="pointy-thing"></div>
    456. 

  456. 

  457. 		<div class="method-info-container">
    458. 

  458. 			
    459. 

  459. 			
    460. 

  460. 			<div class="method-subsection brief-description">
    461. 

  461. 				<p>Dictionary of cached statements</p>
    462. 

  462. 			</div>
    463. 

  463. 			
    464. 

  464. 		    
    465. 

  465. 

  466. 			<div class="method-subsection method-declaration"><code>@property (atomic, retain) NSMutableDictionary *cachedStatements</code></div>
    467. 

  467. 

  468. 		    
    469. 

  469. 			
    470. 

  470. 

  471. 			
    472. 

  472. 

  473. 			
    474. 

  474. 

  475. 			
    476. 

  476. 			<div class="method-subsection discussion-section">
    477. 

  477. 				<h4 class="method-subtitle">Discussion</h4>
    478. 

  478. 				<p>Dictionary of cached statements</p>
    479. 

  479. 			</div>
    480. 

  480. 			
    481. 

  481. 

  482. 			
    483. 

  483. 

  484. 			
    485. 

  485. 

  486. 			
    487. 

  487. 			<div class="method-subsection declared-in-section">
    488. 

  488. 				<h4 class="method-subtitle">Declared In</h4>
    489. 

  489. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    490. 

  490. 			</div>
    491. 

  491. 			
    492. 

  492. 			
    493. 

  493. 		</div>
    494. 

  494. 	</div>
    495. 

  495. </div>
    496. 

  496. 						</div>
    497. 

  497. 						
    498. 

  498. 

  499. 						<a title="Initialization" name="task_Initialization"></a>
    500. 

  500. 						<h2 class="task-title">Initialization</h2>
    501. 

  501. 

  502. 						<div class="task-list">
    503. 

  503. 							<div class="section-method">
    504. 

  504. 	<a name="//api/name/databaseWithPath:" title="databaseWithPath:"></a>
    505. 

  505. 	<h3 class="method-title"><code><a href="#//api/name/databaseWithPath:">+&nbsp;databaseWithPath:</a></code>
    506. 

  506. </h3>
    507. 

  507. 

  508. 	<div class="method-info">
    509. 

  509. 		<div class="pointy-thing"></div>
    510. 

  510. 

  511. 		<div class="method-info-container">
    512. 

  512. 			
    513. 

  513. 			
    514. 

  514. 			<div class="method-subsection brief-description">
    515. 

  515. 				<p>Create a <code>FMDatabase</code> object.</p>
    516. 

  516. 			</div>
    517. 

  517. 			
    518. 

  518. 		    
    519. 

  519. 

  520. 			<div class="method-subsection method-declaration"><code>+ (instancetype)databaseWithPath:(NSString *)<em>inPath</em></code></div>
    521. 

  521. 

  522. 		    
    523. 

  523. 			
    524. 

  524. 			<div class="method-subsection arguments-section parameters">
    525. 

  525. 				<h4 class="method-subtitle parameter-title">Parameters</h4>
    526. 

  526. 				<table class="argument-def parameter-def">
    527. 

  527. 				
    528. 

  528. 					<tr>
    529. 

  529. 						<th scope="row" class="argument-name"><code>inPath</code></th>
    530. 

  530. 						<td><p>Path of database file</p></td>
    531. 

  531. 					</tr>
    532. 

  532. 				
    533. 

  533. 				</table>
    534. 

  534. 			</div>
    535. 

  535. 			
    536. 

  536. 

  537. 			
    538. 

  538. 			<div class="method-subsection return">
    539. 

  539. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    540. 

  540. 				<p><code>FMDatabase</code> object if successful; <code>nil</code> if failure.</p>
    541. 

  541. 			</div>
    542. 

  542. 			
    543. 

  543. 

  544. 			
    545. 

  545. 

  546. 			
    547. 

  547. 			<div class="method-subsection discussion-section">
    548. 

  548. 				<h4 class="method-subtitle">Discussion</h4>
    549. 

  549. 				<p>Create a <code>FMDatabase</code> object.</p>
    550. 

  550. 

  551. <p>An <code>FMDatabase</code> is created with a path to a SQLite database file.  This path can be one of these three:</p>
    552. 

  552. 

  553. <ol>
    554. 

  554. <li>A file system path.  The file does not have to exist on disk.  If it does not exist, it is created for you.</li>
    555. 

  555. <li>An empty string (<code>@""</code>).  An empty database is created at a temporary location.  This database is deleted with the <code>FMDatabase</code> connection is closed.</li>
    556. 

  556. <li><code>nil</code>.  An in-memory database is created.  This database will be destroyed with the <code>FMDatabase</code> connection is closed.</li>
    557. 

  557. </ol>
    558. 

  558. 

  559. 

  560. <p>For example, to create/open a database in your Mac OS X <code>tmp</code> folder:</p>
    561. 

  561. 

  562. <pre><code>FMDatabase *db = [FMDatabase databaseWithPath:@"/tmp/tmp.db"];
    563. 

  563. </code></pre>
    564. 

  564. 

  565. <p>Or, in iOS, you might open a database in the app&rsquo;s <code>Documents</code> directory:</p>
    566. 

  566. 

  567. <pre><code>NSString *docsPath = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES)[0];
    568. 

  568. NSString *dbPath   = [docsPath stringByAppendingPathComponent:@"test.db"];
    569. 

  569. FMDatabase *db     = [FMDatabase databaseWithPath:dbPath];
    570. 

  570. </code></pre>
    571. 

  571. 

  572. <p>(For more information on temporary and in-memory databases, read the sqlite documentation on the subject: <a href="http://www.sqlite.org/inmemorydb.html">http://www.sqlite.org/inmemorydb.html</a>)</p>
    573. 

  573. 			</div>
    574. 

  574. 			
    575. 

  575. 

  576. 			
    577. 

  577. 

  578. 			
    579. 

  579. 

  580. 			
    581. 

  581. 			<div class="method-subsection declared-in-section">
    582. 

  582. 				<h4 class="method-subtitle">Declared In</h4>
    583. 

  583. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    584. 

  584. 			</div>
    585. 

  585. 			
    586. 

  586. 			
    587. 

  587. 		</div>
    588. 

  588. 	</div>
    589. 

  589. </div><div class="section-method">
    590. 

  590. 	<a name="//api/name/initWithPath:" title="initWithPath:"></a>
    591. 

  591. 	<h3 class="method-title"><code><a href="#//api/name/initWithPath:">&ndash;&nbsp;initWithPath:</a></code>
    592. 

  592. </h3>
    593. 

  593. 

  594. 	<div class="method-info">
    595. 

  595. 		<div class="pointy-thing"></div>
    596. 

  596. 

  597. 		<div class="method-info-container">
    598. 

  598. 			
    599. 

  599. 			
    600. 

  600. 			<div class="method-subsection brief-description">
    601. 

  601. 				<p>Initialize a <code>FMDatabase</code> object.</p>
    602. 

  602. 			</div>
    603. 

  603. 			
    604. 

  604. 		    
    605. 

  605. 

  606. 			<div class="method-subsection method-declaration"><code>- (instancetype)initWithPath:(NSString *)<em>inPath</em></code></div>
    607. 

  607. 

  608. 		    
    609. 

  609. 			
    610. 

  610. 			<div class="method-subsection arguments-section parameters">
    611. 

  611. 				<h4 class="method-subtitle parameter-title">Parameters</h4>
    612. 

  612. 				<table class="argument-def parameter-def">
    613. 

  613. 				
    614. 

  614. 					<tr>
    615. 

  615. 						<th scope="row" class="argument-name"><code>inPath</code></th>
    616. 

  616. 						<td><p>Path of database file</p></td>
    617. 

  617. 					</tr>
    618. 

  618. 				
    619. 

  619. 				</table>
    620. 

  620. 			</div>
    621. 

  621. 			
    622. 

  622. 

  623. 			
    624. 

  624. 			<div class="method-subsection return">
    625. 

  625. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    626. 

  626. 				<p><code>FMDatabase</code> object if successful; <code>nil</code> if failure.</p>
    627. 

  627. 			</div>
    628. 

  628. 			
    629. 

  629. 

  630. 			
    631. 

  631. 

  632. 			
    633. 

  633. 			<div class="method-subsection discussion-section">
    634. 

  634. 				<h4 class="method-subtitle">Discussion</h4>
    635. 

  635. 				<p>Initialize a <code>FMDatabase</code> object.</p>
    636. 

  636. 

  637. <p>An <code>FMDatabase</code> is created with a path to a SQLite database file.  This path can be one of these three:</p>
    638. 

  638. 

  639. <ol>
    640. 

  640. <li>A file system path.  The file does not have to exist on disk.  If it does not exist, it is created for you.</li>
    641. 

  641. <li>An empty string (<code>@""</code>).  An empty database is created at a temporary location.  This database is deleted with the <code>FMDatabase</code> connection is closed.</li>
    642. 

  642. <li><code>nil</code>.  An in-memory database is created.  This database will be destroyed with the <code>FMDatabase</code> connection is closed.</li>
    643. 

  643. </ol>
    644. 

  644. 

  645. 

  646. <p>For example, to create/open a database in your Mac OS X <code>tmp</code> folder:</p>
    647. 

  647. 

  648. <pre><code>FMDatabase *db = [FMDatabase databaseWithPath:@"/tmp/tmp.db"];
    649. 

  649. </code></pre>
    650. 

  650. 

  651. <p>Or, in iOS, you might open a database in the app&rsquo;s <code>Documents</code> directory:</p>
    652. 

  652. 

  653. <pre><code>NSString *docsPath = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES)[0];
    654. 

  654. NSString *dbPath   = [docsPath stringByAppendingPathComponent:@"test.db"];
    655. 

  655. FMDatabase *db     = [FMDatabase databaseWithPath:dbPath];
    656. 

  656. </code></pre>
    657. 

  657. 

  658. <p>(For more information on temporary and in-memory databases, read the sqlite documentation on the subject: <a href="http://www.sqlite.org/inmemorydb.html">http://www.sqlite.org/inmemorydb.html</a>)</p>
    659. 

  659. 			</div>
    660. 

  660. 			
    661. 

  661. 

  662. 			
    663. 

  663. 

  664. 			
    665. 

  665. 

  666. 			
    667. 

  667. 			<div class="method-subsection declared-in-section">
    668. 

  668. 				<h4 class="method-subtitle">Declared In</h4>
    669. 

  669. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    670. 

  670. 			</div>
    671. 

  671. 			
    672. 

  672. 			
    673. 

  673. 		</div>
    674. 

  674. 	</div>
    675. 

  675. </div>
    676. 

  676. 						</div>
    677. 

  677. 						
    678. 

  678. 

  679. 						<a title="Opening and closing database" name="task_Opening and closing database"></a>
    680. 

  680. 						<h2 class="task-title">Opening and closing database</h2>
    681. 

  681. 

  682. 						<div class="task-list">
    683. 

  683. 							<div class="section-method">
    684. 

  684. 	<a name="//api/name/open" title="open"></a>
    685. 

  685. 	<h3 class="method-title"><code><a href="#//api/name/open">&ndash;&nbsp;open</a></code>
    686. 

  686. </h3>
    687. 

  687. 

  688. 	<div class="method-info">
    689. 

  689. 		<div class="pointy-thing"></div>
    690. 

  690. 

  691. 		<div class="method-info-container">
    692. 

  692. 			
    693. 

  693. 			
    694. 

  694. 			<div class="method-subsection brief-description">
    695. 

  695. 				<p>Opening a new database connection</p>
    696. 

  696. 			</div>
    697. 

  697. 			
    698. 

  698. 		    
    699. 

  699. 

  700. 			<div class="method-subsection method-declaration"><code>- (BOOL)open</code></div>
    701. 

  701. 

  702. 		    
    703. 

  703. 			
    704. 

  704. 

  705. 			
    706. 

  706. 			<div class="method-subsection return">
    707. 

  707. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    708. 

  708. 				<p><code>YES</code> if successful, <code>NO</code> on error.</p>
    709. 

  709. 			</div>
    710. 

  710. 			
    711. 

  711. 

  712. 			
    713. 

  713. 

  714. 			
    715. 

  715. 			<div class="method-subsection discussion-section">
    716. 

  716. 				<h4 class="method-subtitle">Discussion</h4>
    717. 

  717. 				<p>Opening a new database connection</p>
    718. 

  718. 

  719. <p>The database is opened for reading and writing, and is created if it does not already exist.</p>
    720. 

  720. 			</div>
    721. 

  721. 			
    722. 

  722. 

  723. 			
    724. 

  724. 

  725. 			
    726. 

  726. 			<div class="method-subsection see-also-section">
    727. 

  727. 				<h4 class="method-subtitle">See Also</h4>
    728. 

  728. 				<ul>
    729. 

  729. 					
    730. 

  730. 					<li><code><p><a href="http://sqlite.org/c3ref/open.html">sqlite3_open()</a></p></code></li>
    731. 

  731. 					
    732. 

  732. 					<li><code><p><a href="#//api/name/openWithFlags:">- openWithFlags:</a></p></code></li>
    733. 

  733. 					
    734. 

  734. 					<li><code><p><a href="#//api/name/close">- close</a></p></code></li>
    735. 

  735. 					
    736. 

  736. 				</ul>
    737. 

  737. 			</div>
    738. 

  738. 			
    739. 

  739. 

  740. 			
    741. 

  741. 			<div class="method-subsection declared-in-section">
    742. 

  742. 				<h4 class="method-subtitle">Declared In</h4>
    743. 

  743. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    744. 

  744. 			</div>
    745. 

  745. 			
    746. 

  746. 			
    747. 

  747. 		</div>
    748. 

  748. 	</div>
    749. 

  749. </div><div class="section-method">
    750. 

  750. 	<a name="//api/name/openWithFlags:" title="openWithFlags:"></a>
    751. 

  751. 	<h3 class="method-title"><code><a href="#//api/name/openWithFlags:">&ndash;&nbsp;openWithFlags:</a></code>
    752. 

  752. </h3>
    753. 

  753. 

  754. 	<div class="method-info">
    755. 

  755. 		<div class="pointy-thing"></div>
    756. 

  756. 

  757. 		<div class="method-info-container">
    758. 

  758. 			
    759. 

  759. 			
    760. 

  760. 			<div class="method-subsection brief-description">
    761. 

  761. 				<p>Opening a new database connection with flags</p>
    762. 

  762. 			</div>
    763. 

  763. 			
    764. 

  764. 		    
    765. 

  765. 

  766. 			<div class="method-subsection method-declaration"><code>- (BOOL)openWithFlags:(int)<em>flags</em></code></div>
    767. 

  767. 

  768. 		    
    769. 

  769. 			
    770. 

  770. 			<div class="method-subsection arguments-section parameters">
    771. 

  771. 				<h4 class="method-subtitle parameter-title">Parameters</h4>
    772. 

  772. 				<table class="argument-def parameter-def">
    773. 

  773. 				
    774. 

  774. 					<tr>
    775. 

  775. 						<th scope="row" class="argument-name"><code>flags</code></th>
    776. 

  776. 						<td><p>one of the following three values, optionally combined with the <code>SQLITE_OPEN_NOMUTEX</code>, <code>SQLITE_OPEN_FULLMUTEX</code>, <code>SQLITE_OPEN_SHAREDCACHE</code>, <code>SQLITE_OPEN_PRIVATECACHE</code>, and/or <code>SQLITE_OPEN_URI</code> flags:</p>
    777. 

  777. 

  778. <p><code>SQLITE_OPEN_READONLY</code></p>
    779. 

  779. 

  780. <p>The database is opened in read-only mode. If the database does not already exist, an error is returned.</p>
    781. 

  781. 

  782. <p><code>SQLITE_OPEN_READWRITE</code></p>
    783. 

  783. 

  784. <p>The database is opened for reading and writing if possible, or reading only if the file is write protected by the operating system. In either case the database must already exist, otherwise an error is returned.</p>
    785. 

  785. 

  786. <p><code>SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE</code></p>
    787. 

  787. 

  788. <p>The database is opened for reading and writing, and is created if it does not already exist. This is the behavior that is always used for <code>open</code> method.</p></td>
    789. 

  789. 					</tr>
    790. 

  790. 				
    791. 

  791. 				</table>
    792. 

  792. 			</div>
    793. 

  793. 			
    794. 

  794. 

  795. 			
    796. 

  796. 			<div class="method-subsection return">
    797. 

  797. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    798. 

  798. 				<p><code>YES</code> if successful, <code>NO</code> on error.</p>
    799. 

  799. 			</div>
    800. 

  800. 			
    801. 

  801. 

  802. 			
    803. 

  803. 

  804. 			
    805. 

  805. 			<div class="method-subsection discussion-section">
    806. 

  806. 				<h4 class="method-subtitle">Discussion</h4>
    807. 

  807. 				<p>Opening a new database connection with flags</p>
    808. 

  808. 			</div>
    809. 

  809. 			
    810. 

  810. 

  811. 			
    812. 

  812. 

  813. 			
    814. 

  814. 			<div class="method-subsection see-also-section">
    815. 

  815. 				<h4 class="method-subtitle">See Also</h4>
    816. 

  816. 				<ul>
    817. 

  817. 					
    818. 

  818. 					<li><code><p><a href="http://sqlite.org/c3ref/open.html">sqlite3_open_v2()</a></p></code></li>
    819. 

  819. 					
    820. 

  820. 					<li><code><p><a href="#//api/name/open">- open</a></p></code></li>
    821. 

  821. 					
    822. 

  822. 					<li><code><p><a href="#//api/name/close">- close</a></p></code></li>
    823. 

  823. 					
    824. 

  824. 				</ul>
    825. 

  825. 			</div>
    826. 

  826. 			
    827. 

  827. 

  828. 			
    829. 

  829. 			<div class="method-subsection declared-in-section">
    830. 

  830. 				<h4 class="method-subtitle">Declared In</h4>
    831. 

  831. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    832. 

  832. 			</div>
    833. 

  833. 			
    834. 

  834. 			
    835. 

  835. 		</div>
    836. 

  836. 	</div>
    837. 

  837. </div><div class="section-method">
    838. 

  838. 	<a name="//api/name/close" title="close"></a>
    839. 

  839. 	<h3 class="method-title"><code><a href="#//api/name/close">&ndash;&nbsp;close</a></code>
    840. 

  840. </h3>
    841. 

  841. 

  842. 	<div class="method-info">
    843. 

  843. 		<div class="pointy-thing"></div>
    844. 

  844. 

  845. 		<div class="method-info-container">
    846. 

  846. 			
    847. 

  847. 			
    848. 

  848. 			<div class="method-subsection brief-description">
    849. 

  849. 				<p>Closing a database connection</p>
    850. 

  850. 			</div>
    851. 

  851. 			
    852. 

  852. 		    
    853. 

  853. 

  854. 			<div class="method-subsection method-declaration"><code>- (BOOL)close</code></div>
    855. 

  855. 

  856. 		    
    857. 

  857. 			
    858. 

  858. 

  859. 			
    860. 

  860. 			<div class="method-subsection return">
    861. 

  861. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    862. 

  862. 				<p><code>YES</code> if success, <code>NO</code> on error.</p>
    863. 

  863. 			</div>
    864. 

  864. 			
    865. 

  865. 

  866. 			
    867. 

  867. 

  868. 			
    869. 

  869. 			<div class="method-subsection discussion-section">
    870. 

  870. 				<h4 class="method-subtitle">Discussion</h4>
    871. 

  871. 				<p>Closing a database connection</p>
    872. 

  872. 			</div>
    873. 

  873. 			
    874. 

  874. 

  875. 			
    876. 

  876. 

  877. 			
    878. 

  878. 			<div class="method-subsection see-also-section">
    879. 

  879. 				<h4 class="method-subtitle">See Also</h4>
    880. 

  880. 				<ul>
    881. 

  881. 					
    882. 

  882. 					<li><code><p><a href="http://sqlite.org/c3ref/close.html">sqlite3_close()</a></p></code></li>
    883. 

  883. 					
    884. 

  884. 					<li><code><p><a href="#//api/name/open">- open</a></p></code></li>
    885. 

  885. 					
    886. 

  886. 					<li><code><p><a href="#//api/name/openWithFlags:">- openWithFlags:</a></p></code></li>
    887. 

  887. 					
    888. 

  888. 				</ul>
    889. 

  889. 			</div>
    890. 

  890. 			
    891. 

  891. 

  892. 			
    893. 

  893. 			<div class="method-subsection declared-in-section">
    894. 

  894. 				<h4 class="method-subtitle">Declared In</h4>
    895. 

  895. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    896. 

  896. 			</div>
    897. 

  897. 			
    898. 

  898. 			
    899. 

  899. 		</div>
    900. 

  900. 	</div>
    901. 

  901. </div><div class="section-method">
    902. 

  902. 	<a name="//api/name/goodConnection" title="goodConnection"></a>
    903. 

  903. 	<h3 class="method-title"><code><a href="#//api/name/goodConnection">&ndash;&nbsp;goodConnection</a></code>
    904. 

  904. </h3>
    905. 

  905. 

  906. 	<div class="method-info">
    907. 

  907. 		<div class="pointy-thing"></div>
    908. 

  908. 

  909. 		<div class="method-info-container">
    910. 

  910. 			
    911. 

  911. 			
    912. 

  912. 			<div class="method-subsection brief-description">
    913. 

  913. 				<p>Test to see if we have a good connection to the database.</p>
    914. 

  914. 			</div>
    915. 

  915. 			
    916. 

  916. 		    
    917. 

  917. 

  918. 			<div class="method-subsection method-declaration"><code>- (BOOL)goodConnection</code></div>
    919. 

  919. 

  920. 		    
    921. 

  921. 			
    922. 

  922. 

  923. 			
    924. 

  924. 			<div class="method-subsection return">
    925. 

  925. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    926. 

  926. 				<p><code>YES</code> if everything succeeds, <code>NO</code> on failure.</p>
    927. 

  927. 			</div>
    928. 

  928. 			
    929. 

  929. 

  930. 			
    931. 

  931. 

  932. 			
    933. 

  933. 			<div class="method-subsection discussion-section">
    934. 

  934. 				<h4 class="method-subtitle">Discussion</h4>
    935. 

  935. 				<p>Test to see if we have a good connection to the database.</p>
    936. 

  936. 

  937. <p>This will confirm whether:</p>
    938. 

  938. 

  939. <ul>
    940. 

  940. <li>is database open</li>
    941. 

  941. <li>if open, it will try a simple SELECT statement and confirm that it succeeds.</li>
    942. 

  942. </ul>
    943. 

  943. 

  944. 			</div>
    945. 

  945. 			
    946. 

  946. 

  947. 			
    948. 

  948. 

  949. 			
    950. 

  950. 

  951. 			
    952. 

  952. 			<div class="method-subsection declared-in-section">
    953. 

  953. 				<h4 class="method-subtitle">Declared In</h4>
    954. 

  954. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    955. 

  955. 			</div>
    956. 

  956. 			
    957. 

  957. 			
    958. 

  958. 		</div>
    959. 

  959. 	</div>
    960. 

  960. </div>
    961. 

  961. 						</div>
    962. 

  962. 						
    963. 

  963. 

  964. 						<a title="Perform updates" name="task_Perform updates"></a>
    965. 

  965. 						<h2 class="task-title">Perform updates</h2>
    966. 

  966. 

  967. 						<div class="task-list">
    968. 

  968. 							<div class="section-method">
    969. 

  969. 	<a name="//api/name/executeUpdate:withErrorAndBindings:" title="executeUpdate:withErrorAndBindings:"></a>
    970. 

  970. 	<h3 class="method-title"><code><a href="#//api/name/executeUpdate:withErrorAndBindings:">&ndash;&nbsp;executeUpdate:withErrorAndBindings:</a></code>
    971. 

  971. </h3>
    972. 

  972. 

  973. 	<div class="method-info">
    974. 

  974. 		<div class="pointy-thing"></div>
    975. 

  975. 

  976. 		<div class="method-info-container">
    977. 

  977. 			
    978. 

  978. 			
    979. 

  979. 			<div class="method-subsection brief-description">
    980. 

  980. 				<p>Execute single update statement</p>
    981. 

  981. 			</div>
    982. 

  982. 			
    983. 

  983. 		    
    984. 

  984. 

  985. 			<div class="method-subsection method-declaration"><code>- (BOOL)executeUpdate:(NSString *)<em>sql</em> withErrorAndBindings:(NSError **)<em>outErr</em>, <em>...</em></code></div>
    986. 

  986. 

  987. 		    
    988. 

  988. 			
    989. 

  989. 			<div class="method-subsection arguments-section parameters">
    990. 

  990. 				<h4 class="method-subtitle parameter-title">Parameters</h4>
    991. 

  991. 				<table class="argument-def parameter-def">
    992. 

  992. 				
    993. 

  993. 					<tr>
    994. 

  994. 						<th scope="row" class="argument-name"><code>sql</code></th>
    995. 

  995. 						<td><p>The SQL to be performed, with optional <code>?</code> placeholders.</p></td>
    996. 

  996. 					</tr>
    997. 

  997. 				
    998. 

  998. 					<tr>
    999. 

  999. 						<th scope="row" class="argument-name"><code>outErr</code></th>
    1000. 

  1000. 						<td><p>A reference to the <code>NSError</code> pointer to be updated with an auto released <code>NSError</code> object if an error if an error occurs. If <code>nil</code>, no <code>NSError</code> object will be returned.</p></td>
    1001. 

  1001. 					</tr>
    1002. 

  1002. 				
    1003. 

  1003. 					<tr>
    1004. 

  1004. 						<th scope="row" class="argument-name"><code>...</code></th>
    1005. 

  1005. 						<td><p>Optional parameters to bind to <code>?</code> placeholders in the SQL statement. These should be Objective-C objects (e.g. <code>NSString</code>, <code>NSNumber</code>, etc.), not fundamental C data types (e.g. <code>int</code>, <code>char *</code>, etc.).</p></td>
    1006. 

  1006. 					</tr>
    1007. 

  1007. 				
    1008. 

  1008. 				</table>
    1009. 

  1009. 			</div>
    1010. 

  1010. 			
    1011. 

  1011. 

  1012. 			
    1013. 

  1013. 			<div class="method-subsection return">
    1014. 

  1014. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    1015. 

  1015. 				<p><code>YES</code> upon success; <code>NO</code> upon failure. If failed, you can call <a href="#//api/name/lastError"><code>lastError</code></a>, <a href="#//api/name/lastErrorCode"><code>lastErrorCode</code></a>, or <a href="#//api/name/lastErrorMessage"><code>lastErrorMessage</code></a> for diagnostic information regarding the failure.</p>
    1016. 

  1016. 			</div>
    1017. 

  1017. 			
    1018. 

  1018. 

  1019. 			
    1020. 

  1020. 

  1021. 			
    1022. 

  1022. 			<div class="method-subsection discussion-section">
    1023. 

  1023. 				<h4 class="method-subtitle">Discussion</h4>
    1024. 

  1024. 				<p>Execute single update statement</p>
    1025. 

  1025. 

  1026. <p>This method executes a single SQL update statement (i.e. any SQL that does not return results, such as <code>UPDATE</code>, <code>INSERT</code>, or <code>DELETE</code>. This method employs <a href="http://sqlite.org/c3ref/prepare.html"><code>sqlite3_prepare_v2</code></a>, <a href="http://sqlite.org/c3ref/bind_blob.html"><code>sqlite3_bind</code></a> to bind values to <code>?</code> placeholders in the SQL with the optional list of parameters, and <a href="http://sqlite.org/c3ref/step.html"><code>sqlite_step</code></a> to perform the update.</p>
    1027. 

  1027. 

  1028. <p>The optional values provided to this method should be objects (e.g. <code>NSString</code>, <code>NSNumber</code>, <code>NSNull</code>, <code>NSDate</code>, and <code>NSData</code> objects), not fundamental data types (e.g. <code>int</code>, <code>long</code>, <code>NSInteger</code>, etc.). This method automatically handles the aforementioned object types, and all other object types will be interpreted as text values using the object&rsquo;s <code>description</code> method.</p>
    1029. 

  1029. 			</div>
    1030. 

  1030. 			
    1031. 

  1031. 

  1032. 			
    1033. 

  1033. 

  1034. 			
    1035. 

  1035. 			<div class="method-subsection see-also-section">
    1036. 

  1036. 				<h4 class="method-subtitle">See Also</h4>
    1037. 

  1037. 				<ul>
    1038. 

  1038. 					
    1039. 

  1039. 					<li><code><p><a href="#//api/name/lastError">- lastError</a></p></code></li>
    1040. 

  1040. 					
    1041. 

  1041. 					<li><code><p><a href="#//api/name/lastErrorCode">- lastErrorCode</a></p></code></li>
    1042. 

  1042. 					
    1043. 

  1043. 					<li><code><p><a href="#//api/name/lastErrorMessage">- lastErrorMessage</a></p></code></li>
    1044. 

  1044. 					
    1045. 

  1045. 					<li><code><p><a href="http://sqlite.org/c3ref/bind_blob.html"><code>sqlite3_bind</code></a></p></code></li>
    1046. 

  1046. 					
    1047. 

  1047. 				</ul>
    1048. 

  1048. 			</div>
    1049. 

  1049. 			
    1050. 

  1050. 

  1051. 			
    1052. 

  1052. 			<div class="method-subsection declared-in-section">
    1053. 

  1053. 				<h4 class="method-subtitle">Declared In</h4>
    1054. 

  1054. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    1055. 

  1055. 			</div>
    1056. 

  1056. 			
    1057. 

  1057. 			
    1058. 

  1058. 		</div>
    1059. 

  1059. 	</div>
    1060. 

  1060. </div><div class="section-method">
    1061. 

  1061. 	<a name="//api/name/update:withErrorAndBindings:" title="update:withErrorAndBindings:"></a>
    1062. 

  1062. 	<h3 class="method-title"><code><a href="#//api/name/update:withErrorAndBindings:">&ndash;&nbsp;update:withErrorAndBindings:</a></code>
    1063. 

  1063. </h3>
    1064. 

  1064. 

  1065. 	<div class="method-info">
    1066. 

  1066. 		<div class="pointy-thing"></div>
    1067. 

  1067. 

  1068. 		<div class="method-info-container">
    1069. 

  1069. 			
    1070. 

  1070. 			
    1071. 

  1071. 			<div class="method-subsection brief-description">
    1072. 

  1072. 				<p>Execute single update statement</p>
    1073. 

  1073. 			</div>
    1074. 

  1074. 			
    1075. 

  1075. 		    
    1076. 

  1076. 

  1077. 			<div class="method-subsection method-declaration"><code>- (BOOL)update:(NSString *)<em>sql</em> withErrorAndBindings:(NSError **)<em>outErr</em>, <em>...</em></code></div>
    1078. 

  1078. 

  1079. 		    
    1080. 

  1080. 			
    1081. 

  1081. 

  1082. 			
    1083. 

  1083. 

  1084. 			
    1085. 

  1085. 

  1086. 			
    1087. 

  1087. 			<div class="method-subsection discussion-section">
    1088. 

  1088. 				<h4 class="method-subtitle">Discussion</h4>
    1089. 

  1089. 				<p>Execute single update statement</p><div class="warning"><p><strong>Warning:</strong> <strong>Deprecated</strong>: Please use <code>&lt;executeUpdate:withErrorAndBindings&gt;</code> instead.</p></div>
    1090. 

  1090. 			</div>
    1091. 

  1091. 			
    1092. 

  1092. 

  1093. 			
    1094. 

  1094. 

  1095. 			
    1096. 

  1096. 			<div class="method-subsection see-also-section">
    1097. 

  1097. 				<h4 class="method-subtitle">See Also</h4>
    1098. 

  1098. 				<ul>
    1099. 

  1099. 					
    1100. 

  1100. 					<li><code><p><a href="#//api/name/executeUpdate:withErrorAndBindings:">- executeUpdate:withErrorAndBindings:</a></p></code></li>
    1101. 

  1101. 					
    1102. 

  1102. 				</ul>
    1103. 

  1103. 			</div>
    1104. 

  1104. 			
    1105. 

  1105. 

  1106. 			
    1107. 

  1107. 			<div class="method-subsection declared-in-section">
    1108. 

  1108. 				<h4 class="method-subtitle">Declared In</h4>
    1109. 

  1109. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    1110. 

  1110. 			</div>
    1111. 

  1111. 			
    1112. 

  1112. 			
    1113. 

  1113. 		</div>
    1114. 

  1114. 	</div>
    1115. 

  1115. </div><div class="section-method">
    1116. 

  1116. 	<a name="//api/name/executeUpdate:" title="executeUpdate:"></a>
    1117. 

  1117. 	<h3 class="method-title"><code><a href="#//api/name/executeUpdate:">&ndash;&nbsp;executeUpdate:</a></code>
    1118. 

  1118. </h3>
    1119. 

  1119. 

  1120. 	<div class="method-info">
    1121. 

  1121. 		<div class="pointy-thing"></div>
    1122. 

  1122. 

  1123. 		<div class="method-info-container">
    1124. 

  1124. 			
    1125. 

  1125. 			
    1126. 

  1126. 			<div class="method-subsection brief-description">
    1127. 

  1127. 				<p>Execute single update statement</p>
    1128. 

  1128. 			</div>
    1129. 

  1129. 			
    1130. 

  1130. 		    
    1131. 

  1131. 

  1132. 			<div class="method-subsection method-declaration"><code>- (BOOL)executeUpdate:(NSString *)<em>sql</em>, <em>...</em></code></div>
    1133. 

  1133. 

  1134. 		    
    1135. 

  1135. 			
    1136. 

  1136. 			<div class="method-subsection arguments-section parameters">
    1137. 

  1137. 				<h4 class="method-subtitle parameter-title">Parameters</h4>
    1138. 

  1138. 				<table class="argument-def parameter-def">
    1139. 

  1139. 				
    1140. 

  1140. 					<tr>
    1141. 

  1141. 						<th scope="row" class="argument-name"><code>sql</code></th>
    1142. 

  1142. 						<td><p>The SQL to be performed, with optional <code>?</code> placeholders.</p></td>
    1143. 

  1143. 					</tr>
    1144. 

  1144. 				
    1145. 

  1145. 					<tr>
    1146. 

  1146. 						<th scope="row" class="argument-name"><code>...</code></th>
    1147. 

  1147. 						<td><p>Optional parameters to bind to <code>?</code> placeholders in the SQL statement. These should be Objective-C objects (e.g. <code>NSString</code>, <code>NSNumber</code>, etc.), not fundamental C data types (e.g. <code>int</code>, <code>char *</code>, etc.).</p></td>
    1148. 

  1148. 					</tr>
    1149. 

  1149. 				
    1150. 

  1150. 				</table>
    1151. 

  1151. 			</div>
    1152. 

  1152. 			
    1153. 

  1153. 

  1154. 			
    1155. 

  1155. 			<div class="method-subsection return">
    1156. 

  1156. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    1157. 

  1157. 				<p><code>YES</code> upon success; <code>NO</code> upon failure. If failed, you can call <a href="#//api/name/lastError"><code>lastError</code></a>, <a href="#//api/name/lastErrorCode"><code>lastErrorCode</code></a>, or <a href="#//api/name/lastErrorMessage"><code>lastErrorMessage</code></a> for diagnostic information regarding the failure.</p>
    1158. 

  1158. 			</div>
    1159. 

  1159. 			
    1160. 

  1160. 

  1161. 			
    1162. 

  1162. 

  1163. 			
    1164. 

  1164. 			<div class="method-subsection discussion-section">
    1165. 

  1165. 				<h4 class="method-subtitle">Discussion</h4>
    1166. 

  1166. 				<p>Execute single update statement</p>
    1167. 

  1167. 

  1168. <p>This method executes a single SQL update statement (i.e. any SQL that does not return results, such as <code>UPDATE</code>, <code>INSERT</code>, or <code>DELETE</code>. This method employs <a href="http://sqlite.org/c3ref/prepare.html"><code>sqlite3_prepare_v2</code></a>, <a href="http://sqlite.org/c3ref/bind_blob.html"><code>sqlite3_bind</code></a> to bind values to <code>?</code> placeholders in the SQL with the optional list of parameters, and <a href="http://sqlite.org/c3ref/step.html"><code>sqlite_step</code></a> to perform the update.</p>
    1169. 

  1169. 

  1170. <p>The optional values provided to this method should be objects (e.g. <code>NSString</code>, <code>NSNumber</code>, <code>NSNull</code>, <code>NSDate</code>, and <code>NSData</code> objects), not fundamental data types (e.g. <code>int</code>, <code>long</code>, <code>NSInteger</code>, etc.). This method automatically handles the aforementioned object types, and all other object types will be interpreted as text values using the object&rsquo;s <code>description</code> method.</p><div class="note"><p><strong>Note:</strong> This technique supports the use of <code>?</code> placeholders in the SQL, automatically binding any supplied value parameters to those placeholders. This approach is more robust than techniques that entail using <code>stringWithFormat</code> to manually build SQL statements, which can be problematic if the values happened to include any characters that needed to be quoted.</p></div><div class="note"><p><strong>Note:</strong> If you want to use this from Swift, please note that you must include <code>FMDatabaseVariadic.swift</code> in your project. Without that, you cannot use this method directly, and instead have to use methods such as <a href="#//api/name/executeUpdate:withArgumentsInArray:"><code>executeUpdate:withArgumentsInArray:</code></a>.</p></div>
    1171. 

  1171. 			</div>
    1172. 

  1172. 			
    1173. 

  1173. 

  1174. 			
    1175. 

  1175. 

  1176. 			
    1177. 

  1177. 			<div class="method-subsection see-also-section">
    1178. 

  1178. 				<h4 class="method-subtitle">See Also</h4>
    1179. 

  1179. 				<ul>
    1180. 

  1180. 					
    1181. 

  1181. 					<li><code><p><a href="#//api/name/lastError">- lastError</a></p></code></li>
    1182. 

  1182. 					
    1183. 

  1183. 					<li><code><p><a href="#//api/name/lastErrorCode">- lastErrorCode</a></p></code></li>
    1184. 

  1184. 					
    1185. 

  1185. 					<li><code><p><a href="#//api/name/lastErrorMessage">- lastErrorMessage</a></p></code></li>
    1186. 

  1186. 					
    1187. 

  1187. 					<li><code><p><a href="http://sqlite.org/c3ref/bind_blob.html"><code>sqlite3_bind</code></a></p></code></li>
    1188. 

  1188. 					
    1189. 

  1189. 				</ul>
    1190. 

  1190. 			</div>
    1191. 

  1191. 			
    1192. 

  1192. 

  1193. 			
    1194. 

  1194. 			<div class="method-subsection declared-in-section">
    1195. 

  1195. 				<h4 class="method-subtitle">Declared In</h4>
    1196. 

  1196. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    1197. 

  1197. 			</div>
    1198. 

  1198. 			
    1199. 

  1199. 			
    1200. 

  1200. 		</div>
    1201. 

  1201. 	</div>
    1202. 

  1202. </div><div class="section-method">
    1203. 

  1203. 	<a name="//api/name/executeUpdateWithFormat:" title="executeUpdateWithFormat:"></a>
    1204. 

  1204. 	<h3 class="method-title"><code><a href="#//api/name/executeUpdateWithFormat:">&ndash;&nbsp;executeUpdateWithFormat:</a></code>
    1205. 

  1205. </h3>
    1206. 

  1206. 

  1207. 	<div class="method-info">
    1208. 

  1208. 		<div class="pointy-thing"></div>
    1209. 

  1209. 

  1210. 		<div class="method-info-container">
    1211. 

  1211. 			
    1212. 

  1212. 			
    1213. 

  1213. 			<div class="method-subsection brief-description">
    1214. 

  1214. 				<p>Execute single update statement</p>
    1215. 

  1215. 			</div>
    1216. 

  1216. 			
    1217. 

  1217. 		    
    1218. 

  1218. 

  1219. 			<div class="method-subsection method-declaration"><code>- (BOOL)executeUpdateWithFormat:(NSString *)<em>format</em>, <em>...</em></code></div>
    1220. 

  1220. 

  1221. 		    
    1222. 

  1222. 			
    1223. 

  1223. 			<div class="method-subsection arguments-section parameters">
    1224. 

  1224. 				<h4 class="method-subtitle parameter-title">Parameters</h4>
    1225. 

  1225. 				<table class="argument-def parameter-def">
    1226. 

  1226. 				
    1227. 

  1227. 					<tr>
    1228. 

  1228. 						<th scope="row" class="argument-name"><code>format</code></th>
    1229. 

  1229. 						<td><p>The SQL to be performed, with <code>printf</code>-style escape sequences.</p></td>
    1230. 

  1230. 					</tr>
    1231. 

  1231. 				
    1232. 

  1232. 					<tr>
    1233. 

  1233. 						<th scope="row" class="argument-name"><code>...</code></th>
    1234. 

  1234. 						<td><p>Optional parameters to bind to use in conjunction with the <code>printf</code>-style escape sequences in the SQL statement.</p></td>
    1235. 

  1235. 					</tr>
    1236. 

  1236. 				
    1237. 

  1237. 				</table>
    1238. 

  1238. 			</div>
    1239. 

  1239. 			
    1240. 

  1240. 

  1241. 			
    1242. 

  1242. 			<div class="method-subsection return">
    1243. 

  1243. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    1244. 

  1244. 				<p><code>YES</code> upon success; <code>NO</code> upon failure. If failed, you can call <a href="#//api/name/lastError"><code>lastError</code></a>, <a href="#//api/name/lastErrorCode"><code>lastErrorCode</code></a>, or <a href="#//api/name/lastErrorMessage"><code>lastErrorMessage</code></a> for diagnostic information regarding the failure.</p>
    1245. 

  1245. 			</div>
    1246. 

  1246. 			
    1247. 

  1247. 

  1248. 			
    1249. 

  1249. 

  1250. 			
    1251. 

  1251. 			<div class="method-subsection discussion-section">
    1252. 

  1252. 				<h4 class="method-subtitle">Discussion</h4>
    1253. 

  1253. 				<p>Execute single update statement</p>
    1254. 

  1254. 

  1255. <p>This method executes a single SQL update statement (i.e. any SQL that does not return results, such as <code>UPDATE</code>, <code>INSERT</code>, or <code>DELETE</code>. This method employs <a href="http://sqlite.org/c3ref/prepare.html"><code>sqlite3_prepare_v2</code></a> and <a href="http://sqlite.org/c3ref/step.html"><code>sqlite_step</code></a> to perform the update. Unlike the other <code>executeUpdate</code> methods, this uses printf-style formatters (e.g. <code>%s</code>, <code>%d</code>, etc.) to build the SQL. Do not use <code>?</code> placeholders in the SQL if you use this method.</p><div class="note"><p><strong>Note:</strong> This method does not technically perform a traditional printf-style replacement. What this method actually does is replace the printf-style percent sequences with a SQLite <code>?</code> placeholder, and then bind values to that placeholder. Thus the following command</p>
    1256. 

  1256. 

  1257. <pre><code>[db executeUpdateWithFormat:@"INSERT INTO test (name) VALUES (%@)", @"Gus"];
    1258. 

  1258. </code></pre>
    1259. 

  1259. 

  1260. <p>is actually replacing the <code>%@</code> with <code>?</code> placeholder, and then performing something equivalent to <a href="#//api/name/executeUpdate:"><code>executeUpdate:</code></a></p>
    1261. 

  1261. 

  1262. <pre><code>[db executeUpdate:@"INSERT INTO test (name) VALUES (?)", @"Gus"];
    1263. 

  1263. </code></pre>
    1264. 

  1264. 

  1265. <p>There are two reasons why this distinction is important. First, the printf-style escape sequences can only be used where it is permissible to use a SQLite <code>?</code> placeholder. You can use it only for values in SQL statements, but not for table names or column names or any other non-value context. This method also cannot be used in conjunction with <code>pragma</code> statements and the like. Second, note the lack of quotation marks in the SQL. The <code>VALUES</code> clause was <em>not</em> <code>VALUES ('%@')</code> (like you might have to do if you built a SQL statement using <code>NSString</code> method <code>stringWithFormat</code>), but rather simply <code>VALUES (%@)</code>.</p></div>
    1266. 

  1266. 			</div>
    1267. 

  1267. 			
    1268. 

  1268. 

  1269. 			
    1270. 

  1270. 

  1271. 			
    1272. 

  1272. 			<div class="method-subsection see-also-section">
    1273. 

  1273. 				<h4 class="method-subtitle">See Also</h4>
    1274. 

  1274. 				<ul>
    1275. 

  1275. 					
    1276. 

  1276. 					<li><code><p><a href="#//api/name/executeUpdate:">- executeUpdate:</a></p></code></li>
    1277. 

  1277. 					
    1278. 

  1278. 					<li><code><p><a href="#//api/name/lastError">- lastError</a></p></code></li>
    1279. 

  1279. 					
    1280. 

  1280. 					<li><code><p><a href="#//api/name/lastErrorCode">- lastErrorCode</a></p></code></li>
    1281. 

  1281. 					
    1282. 

  1282. 					<li><code><p><a href="#//api/name/lastErrorMessage">- lastErrorMessage</a></p></code></li>
    1283. 

  1283. 					
    1284. 

  1284. 				</ul>
    1285. 

  1285. 			</div>
    1286. 

  1286. 			
    1287. 

  1287. 

  1288. 			
    1289. 

  1289. 			<div class="method-subsection declared-in-section">
    1290. 

  1290. 				<h4 class="method-subtitle">Declared In</h4>
    1291. 

  1291. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    1292. 

  1292. 			</div>
    1293. 

  1293. 			
    1294. 

  1294. 			
    1295. 

  1295. 		</div>
    1296. 

  1296. 	</div>
    1297. 

  1297. </div><div class="section-method">
    1298. 

  1298. 	<a name="//api/name/executeUpdate:withArgumentsInArray:" title="executeUpdate:withArgumentsInArray:"></a>
    1299. 

  1299. 	<h3 class="method-title"><code><a href="#//api/name/executeUpdate:withArgumentsInArray:">&ndash;&nbsp;executeUpdate:withArgumentsInArray:</a></code>
    1300. 

  1300. </h3>
    1301. 

  1301. 

  1302. 	<div class="method-info">
    1303. 

  1303. 		<div class="pointy-thing"></div>
    1304. 

  1304. 

  1305. 		<div class="method-info-container">
    1306. 

  1306. 			
    1307. 

  1307. 			
    1308. 

  1308. 			<div class="method-subsection brief-description">
    1309. 

  1309. 				<p>Execute single update statement</p>
    1310. 

  1310. 			</div>
    1311. 

  1311. 			
    1312. 

  1312. 		    
    1313. 

  1313. 

  1314. 			<div class="method-subsection method-declaration"><code>- (BOOL)executeUpdate:(NSString *)<em>sql</em> withArgumentsInArray:(NSArray *)<em>arguments</em></code></div>
    1315. 

  1315. 

  1316. 		    
    1317. 

  1317. 			
    1318. 

  1318. 			<div class="method-subsection arguments-section parameters">
    1319. 

  1319. 				<h4 class="method-subtitle parameter-title">Parameters</h4>
    1320. 

  1320. 				<table class="argument-def parameter-def">
    1321. 

  1321. 				
    1322. 

  1322. 					<tr>
    1323. 

  1323. 						<th scope="row" class="argument-name"><code>sql</code></th>
    1324. 

  1324. 						<td><p>The SQL to be performed, with optional <code>?</code> placeholders.</p></td>
    1325. 

  1325. 					</tr>
    1326. 

  1326. 				
    1327. 

  1327. 					<tr>
    1328. 

  1328. 						<th scope="row" class="argument-name"><code>arguments</code></th>
    1329. 

  1329. 						<td><p>A <code>NSArray</code> of objects to be used when binding values to the <code>?</code> placeholders in the SQL statement.</p></td>
    1330. 

  1330. 					</tr>
    1331. 

  1331. 				
    1332. 

  1332. 				</table>
    1333. 

  1333. 			</div>
    1334. 

  1334. 			
    1335. 

  1335. 

  1336. 			
    1337. 

  1337. 			<div class="method-subsection return">
    1338. 

  1338. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    1339. 

  1339. 				<p><code>YES</code> upon success; <code>NO</code> upon failure. If failed, you can call <a href="#//api/name/lastError"><code>lastError</code></a>, <a href="#//api/name/lastErrorCode"><code>lastErrorCode</code></a>, or <a href="#//api/name/lastErrorMessage"><code>lastErrorMessage</code></a> for diagnostic information regarding the failure.</p>
    1340. 

  1340. 			</div>
    1341. 

  1341. 			
    1342. 

  1342. 

  1343. 			
    1344. 

  1344. 

  1345. 			
    1346. 

  1346. 			<div class="method-subsection discussion-section">
    1347. 

  1347. 				<h4 class="method-subtitle">Discussion</h4>
    1348. 

  1348. 				<p>Execute single update statement</p>
    1349. 

  1349. 

  1350. <p>This method executes a single SQL update statement (i.e. any SQL that does not return results, such as <code>UPDATE</code>, <code>INSERT</code>, or <code>DELETE</code>. This method employs <a href="http://sqlite.org/c3ref/prepare.html"><code>sqlite3_prepare_v2</code></a> and <a href="http://sqlite.org/c3ref/bind_blob.html"><code>sqlite3_bind</code></a> binding any <code>?</code> placeholders in the SQL with the optional list of parameters.</p>
    1351. 

  1351. 

  1352. <p>The optional values provided to this method should be objects (e.g. <code>NSString</code>, <code>NSNumber</code>, <code>NSNull</code>, <code>NSDate</code>, and <code>NSData</code> objects), not fundamental data types (e.g. <code>int</code>, <code>long</code>, <code>NSInteger</code>, etc.). This method automatically handles the aforementioned object types, and all other object types will be interpreted as text values using the object&rsquo;s <code>description</code> method.</p>
    1353. 

  1353. 			</div>
    1354. 

  1354. 			
    1355. 

  1355. 

  1356. 			
    1357. 

  1357. 

  1358. 			
    1359. 

  1359. 			<div class="method-subsection see-also-section">
    1360. 

  1360. 				<h4 class="method-subtitle">See Also</h4>
    1361. 

  1361. 				<ul>
    1362. 

  1362. 					
    1363. 

  1363. 					<li><code><p><a href="#//api/name/lastError">- lastError</a></p></code></li>
    1364. 

  1364. 					
    1365. 

  1365. 					<li><code><p><a href="#//api/name/lastErrorCode">- lastErrorCode</a></p></code></li>
    1366. 

  1366. 					
    1367. 

  1367. 					<li><code><p><a href="#//api/name/lastErrorMessage">- lastErrorMessage</a></p></code></li>
    1368. 

  1368. 					
    1369. 

  1369. 				</ul>
    1370. 

  1370. 			</div>
    1371. 

  1371. 			
    1372. 

  1372. 

  1373. 			
    1374. 

  1374. 			<div class="method-subsection declared-in-section">
    1375. 

  1375. 				<h4 class="method-subtitle">Declared In</h4>
    1376. 

  1376. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    1377. 

  1377. 			</div>
    1378. 

  1378. 			
    1379. 

  1379. 			
    1380. 

  1380. 		</div>
    1381. 

  1381. 	</div>
    1382. 

  1382. </div><div class="section-method">
    1383. 

  1383. 	<a name="//api/name/executeUpdate:withParameterDictionary:" title="executeUpdate:withParameterDictionary:"></a>
    1384. 

  1384. 	<h3 class="method-title"><code><a href="#//api/name/executeUpdate:withParameterDictionary:">&ndash;&nbsp;executeUpdate:withParameterDictionary:</a></code>
    1385. 

  1385. </h3>
    1386. 

  1386. 

  1387. 	<div class="method-info">
    1388. 

  1388. 		<div class="pointy-thing"></div>
    1389. 

  1389. 

  1390. 		<div class="method-info-container">
    1391. 

  1391. 			
    1392. 

  1392. 			
    1393. 

  1393. 			<div class="method-subsection brief-description">
    1394. 

  1394. 				<p>Execute single update statement</p>
    1395. 

  1395. 			</div>
    1396. 

  1396. 			
    1397. 

  1397. 		    
    1398. 

  1398. 

  1399. 			<div class="method-subsection method-declaration"><code>- (BOOL)executeUpdate:(NSString *)<em>sql</em> withParameterDictionary:(NSDictionary *)<em>arguments</em></code></div>
    1400. 

  1400. 

  1401. 		    
    1402. 

  1402. 			
    1403. 

  1403. 			<div class="method-subsection arguments-section parameters">
    1404. 

  1404. 				<h4 class="method-subtitle parameter-title">Parameters</h4>
    1405. 

  1405. 				<table class="argument-def parameter-def">
    1406. 

  1406. 				
    1407. 

  1407. 					<tr>
    1408. 

  1408. 						<th scope="row" class="argument-name"><code>sql</code></th>
    1409. 

  1409. 						<td><p>The SQL to be performed, with optional <code>?</code> placeholders.</p></td>
    1410. 

  1410. 					</tr>
    1411. 

  1411. 				
    1412. 

  1412. 					<tr>
    1413. 

  1413. 						<th scope="row" class="argument-name"><code>arguments</code></th>
    1414. 

  1414. 						<td><p>A <code>NSDictionary</code> of objects keyed by column names that will be used when binding values to the <code>?</code> placeholders in the SQL statement.</p></td>
    1415. 

  1415. 					</tr>
    1416. 

  1416. 				
    1417. 

  1417. 				</table>
    1418. 

  1418. 			</div>
    1419. 

  1419. 			
    1420. 

  1420. 

  1421. 			
    1422. 

  1422. 			<div class="method-subsection return">
    1423. 

  1423. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    1424. 

  1424. 				<p><code>YES</code> upon success; <code>NO</code> upon failure. If failed, you can call <a href="#//api/name/lastError"><code>lastError</code></a>, <a href="#//api/name/lastErrorCode"><code>lastErrorCode</code></a>, or <a href="#//api/name/lastErrorMessage"><code>lastErrorMessage</code></a> for diagnostic information regarding the failure.</p>
    1425. 

  1425. 			</div>
    1426. 

  1426. 			
    1427. 

  1427. 

  1428. 			
    1429. 

  1429. 

  1430. 			
    1431. 

  1431. 			<div class="method-subsection discussion-section">
    1432. 

  1432. 				<h4 class="method-subtitle">Discussion</h4>
    1433. 

  1433. 				<p>Execute single update statement</p>
    1434. 

  1434. 

  1435. <p>This method executes a single SQL update statement (i.e. any SQL that does not return results, such as <code>UPDATE</code>, <code>INSERT</code>, or <code>DELETE</code>. This method employs <a href="http://sqlite.org/c3ref/prepare.html"><code>sqlite3_prepare_v2</code></a> and <a href="http://sqlite.org/c3ref/step.html"><code>sqlite_step</code></a> to perform the update. Unlike the other <code>executeUpdate</code> methods, this uses printf-style formatters (e.g. <code>%s</code>, <code>%d</code>, etc.) to build the SQL.</p>
    1436. 

  1436. 

  1437. <p>The optional values provided to this method should be objects (e.g. <code>NSString</code>, <code>NSNumber</code>, <code>NSNull</code>, <code>NSDate</code>, and <code>NSData</code> objects), not fundamental data types (e.g. <code>int</code>, <code>long</code>, <code>NSInteger</code>, etc.). This method automatically handles the aforementioned object types, and all other object types will be interpreted as text values using the object&rsquo;s <code>description</code> method.</p>
    1438. 

  1438. 			</div>
    1439. 

  1439. 			
    1440. 

  1440. 

  1441. 			
    1442. 

  1442. 

  1443. 			
    1444. 

  1444. 			<div class="method-subsection see-also-section">
    1445. 

  1445. 				<h4 class="method-subtitle">See Also</h4>
    1446. 

  1446. 				<ul>
    1447. 

  1447. 					
    1448. 

  1448. 					<li><code><p><a href="#//api/name/lastError">- lastError</a></p></code></li>
    1449. 

  1449. 					
    1450. 

  1450. 					<li><code><p><a href="#//api/name/lastErrorCode">- lastErrorCode</a></p></code></li>
    1451. 

  1451. 					
    1452. 

  1452. 					<li><code><p><a href="#//api/name/lastErrorMessage">- lastErrorMessage</a></p></code></li>
    1453. 

  1453. 					
    1454. 

  1454. 				</ul>
    1455. 

  1455. 			</div>
    1456. 

  1456. 			
    1457. 

  1457. 

  1458. 			
    1459. 

  1459. 			<div class="method-subsection declared-in-section">
    1460. 

  1460. 				<h4 class="method-subtitle">Declared In</h4>
    1461. 

  1461. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    1462. 

  1462. 			</div>
    1463. 

  1463. 			
    1464. 

  1464. 			
    1465. 

  1465. 		</div>
    1466. 

  1466. 	</div>
    1467. 

  1467. </div><div class="section-method">
    1468. 

  1468. 	<a name="//api/name/executeUpdate:withVAList:" title="executeUpdate:withVAList:"></a>
    1469. 

  1469. 	<h3 class="method-title"><code><a href="#//api/name/executeUpdate:withVAList:">&ndash;&nbsp;executeUpdate:withVAList:</a></code>
    1470. 

  1470. </h3>
    1471. 

  1471. 

  1472. 	<div class="method-info">
    1473. 

  1473. 		<div class="pointy-thing"></div>
    1474. 

  1474. 

  1475. 		<div class="method-info-container">
    1476. 

  1476. 			
    1477. 

  1477. 			
    1478. 

  1478. 			<div class="method-subsection brief-description">
    1479. 

  1479. 				<p>Execute single update statement</p>
    1480. 

  1480. 			</div>
    1481. 

  1481. 			
    1482. 

  1482. 		    
    1483. 

  1483. 

  1484. 			<div class="method-subsection method-declaration"><code>- (BOOL)executeUpdate:(NSString *)<em>sql</em> withVAList:(va_list)<em>args</em></code></div>
    1485. 

  1485. 

  1486. 		    
    1487. 

  1487. 			
    1488. 

  1488. 			<div class="method-subsection arguments-section parameters">
    1489. 

  1489. 				<h4 class="method-subtitle parameter-title">Parameters</h4>
    1490. 

  1490. 				<table class="argument-def parameter-def">
    1491. 

  1491. 				
    1492. 

  1492. 					<tr>
    1493. 

  1493. 						<th scope="row" class="argument-name"><code>sql</code></th>
    1494. 

  1494. 						<td><p>The SQL to be performed, with optional <code>?</code> placeholders.</p></td>
    1495. 

  1495. 					</tr>
    1496. 

  1496. 				
    1497. 

  1497. 					<tr>
    1498. 

  1498. 						<th scope="row" class="argument-name"><code>args</code></th>
    1499. 

  1499. 						<td><p>A <code>va_list</code> of arguments.</p></td>
    1500. 

  1500. 					</tr>
    1501. 

  1501. 				
    1502. 

  1502. 				</table>
    1503. 

  1503. 			</div>
    1504. 

  1504. 			
    1505. 

  1505. 

  1506. 			
    1507. 

  1507. 			<div class="method-subsection return">
    1508. 

  1508. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    1509. 

  1509. 				<p><code>YES</code> upon success; <code>NO</code> upon failure. If failed, you can call <a href="#//api/name/lastError"><code>lastError</code></a>, <a href="#//api/name/lastErrorCode"><code>lastErrorCode</code></a>, or <a href="#//api/name/lastErrorMessage"><code>lastErrorMessage</code></a> for diagnostic information regarding the failure.</p>
    1510. 

  1510. 			</div>
    1511. 

  1511. 			
    1512. 

  1512. 

  1513. 			
    1514. 

  1514. 

  1515. 			
    1516. 

  1516. 			<div class="method-subsection discussion-section">
    1517. 

  1517. 				<h4 class="method-subtitle">Discussion</h4>
    1518. 

  1518. 				<p>Execute single update statement</p>
    1519. 

  1519. 

  1520. <p>This method executes a single SQL update statement (i.e. any SQL that does not return results, such as <code>UPDATE</code>, <code>INSERT</code>, or <code>DELETE</code>. This method employs <a href="http://sqlite.org/c3ref/prepare.html"><code>sqlite3_prepare_v2</code></a> and <a href="http://sqlite.org/c3ref/step.html"><code>sqlite_step</code></a> to perform the update. Unlike the other <code>executeUpdate</code> methods, this uses printf-style formatters (e.g. <code>%s</code>, <code>%d</code>, etc.) to build the SQL.</p>
    1521. 

  1521. 

  1522. <p>The optional values provided to this method should be objects (e.g. <code>NSString</code>, <code>NSNumber</code>, <code>NSNull</code>, <code>NSDate</code>, and <code>NSData</code> objects), not fundamental data types (e.g. <code>int</code>, <code>long</code>, <code>NSInteger</code>, etc.). This method automatically handles the aforementioned object types, and all other object types will be interpreted as text values using the object&rsquo;s <code>description</code> method.</p>
    1523. 

  1523. 			</div>
    1524. 

  1524. 			
    1525. 

  1525. 

  1526. 			
    1527. 

  1527. 

  1528. 			
    1529. 

  1529. 			<div class="method-subsection see-also-section">
    1530. 

  1530. 				<h4 class="method-subtitle">See Also</h4>
    1531. 

  1531. 				<ul>
    1532. 

  1532. 					
    1533. 

  1533. 					<li><code><p><a href="#//api/name/lastError">- lastError</a></p></code></li>
    1534. 

  1534. 					
    1535. 

  1535. 					<li><code><p><a href="#//api/name/lastErrorCode">- lastErrorCode</a></p></code></li>
    1536. 

  1536. 					
    1537. 

  1537. 					<li><code><p><a href="#//api/name/lastErrorMessage">- lastErrorMessage</a></p></code></li>
    1538. 

  1538. 					
    1539. 

  1539. 				</ul>
    1540. 

  1540. 			</div>
    1541. 

  1541. 			
    1542. 

  1542. 

  1543. 			
    1544. 

  1544. 			<div class="method-subsection declared-in-section">
    1545. 

  1545. 				<h4 class="method-subtitle">Declared In</h4>
    1546. 

  1546. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    1547. 

  1547. 			</div>
    1548. 

  1548. 			
    1549. 

  1549. 			
    1550. 

  1550. 		</div>
    1551. 

  1551. 	</div>
    1552. 

  1552. </div><div class="section-method">
    1553. 

  1553. 	<a name="//api/name/executeStatements:" title="executeStatements:"></a>
    1554. 

  1554. 	<h3 class="method-title"><code><a href="#//api/name/executeStatements:">&ndash;&nbsp;executeStatements:</a></code>
    1555. 

  1555. </h3>
    1556. 

  1556. 

  1557. 	<div class="method-info">
    1558. 

  1558. 		<div class="pointy-thing"></div>
    1559. 

  1559. 

  1560. 		<div class="method-info-container">
    1561. 

  1561. 			
    1562. 

  1562. 			
    1563. 

  1563. 			<div class="method-subsection brief-description">
    1564. 

  1564. 				<p>Execute multiple SQL statements</p>
    1565. 

  1565. 			</div>
    1566. 

  1566. 			
    1567. 

  1567. 		    
    1568. 

  1568. 

  1569. 			<div class="method-subsection method-declaration"><code>- (BOOL)executeStatements:(NSString *)<em>sql</em></code></div>
    1570. 

  1570. 

  1571. 		    
    1572. 

  1572. 			
    1573. 

  1573. 			<div class="method-subsection arguments-section parameters">
    1574. 

  1574. 				<h4 class="method-subtitle parameter-title">Parameters</h4>
    1575. 

  1575. 				<table class="argument-def parameter-def">
    1576. 

  1576. 				
    1577. 

  1577. 					<tr>
    1578. 

  1578. 						<th scope="row" class="argument-name"><code>sql</code></th>
    1579. 

  1579. 						<td><p>The SQL to be performed</p></td>
    1580. 

  1580. 					</tr>
    1581. 

  1581. 				
    1582. 

  1582. 				</table>
    1583. 

  1583. 			</div>
    1584. 

  1584. 			
    1585. 

  1585. 

  1586. 			
    1587. 

  1587. 			<div class="method-subsection return">
    1588. 

  1588. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    1589. 

  1589. 				<p><code>YES</code> upon success; <code>NO</code> upon failure. If failed, you can call <a href="#//api/name/lastError"><code>lastError</code></a>, <a href="#//api/name/lastErrorCode"><code>lastErrorCode</code></a>, or <a href="#//api/name/lastErrorMessage"><code>lastErrorMessage</code></a> for diagnostic information regarding the failure.</p>
    1590. 

  1590. 			</div>
    1591. 

  1591. 			
    1592. 

  1592. 

  1593. 			
    1594. 

  1594. 

  1595. 			
    1596. 

  1596. 			<div class="method-subsection discussion-section">
    1597. 

  1597. 				<h4 class="method-subtitle">Discussion</h4>
    1598. 

  1598. 				<p>Execute multiple SQL statements</p>
    1599. 

  1599. 

  1600. <p>This executes a series of SQL statements that are combined in a single string (e.g. the SQL generated by the <code>sqlite3</code> command line <code>.dump</code> command). This accepts no value parameters, but rather simply expects a single string with multiple SQL statements, each terminated with a semicolon. This uses <code>sqlite3_exec</code>.</p>
    1601. 

  1601. 			</div>
    1602. 

  1602. 			
    1603. 

  1603. 

  1604. 			
    1605. 

  1605. 

  1606. 			
    1607. 

  1607. 			<div class="method-subsection see-also-section">
    1608. 

  1608. 				<h4 class="method-subtitle">See Also</h4>
    1609. 

  1609. 				<ul>
    1610. 

  1610. 					
    1611. 

  1611. 					<li><code><p><a href="#//api/name/executeStatements:withResultBlock:">- executeStatements:withResultBlock:</a></p></code></li>
    1612. 

  1612. 					
    1613. 

  1613. 					<li><code><p><a href="http://sqlite.org/c3ref/exec.html">sqlite3_exec()</a></p></code></li>
    1614. 

  1614. 					
    1615. 

  1615. 				</ul>
    1616. 

  1616. 			</div>
    1617. 

  1617. 			
    1618. 

  1618. 

  1619. 			
    1620. 

  1620. 			<div class="method-subsection declared-in-section">
    1621. 

  1621. 				<h4 class="method-subtitle">Declared In</h4>
    1622. 

  1622. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    1623. 

  1623. 			</div>
    1624. 

  1624. 			
    1625. 

  1625. 			
    1626. 

  1626. 		</div>
    1627. 

  1627. 	</div>
    1628. 

  1628. </div><div class="section-method">
    1629. 

  1629. 	<a name="//api/name/executeStatements:withResultBlock:" title="executeStatements:withResultBlock:"></a>
    1630. 

  1630. 	<h3 class="method-title"><code><a href="#//api/name/executeStatements:withResultBlock:">&ndash;&nbsp;executeStatements:withResultBlock:</a></code>
    1631. 

  1631. </h3>
    1632. 

  1632. 

  1633. 	<div class="method-info">
    1634. 

  1634. 		<div class="pointy-thing"></div>
    1635. 

  1635. 

  1636. 		<div class="method-info-container">
    1637. 

  1637. 			
    1638. 

  1638. 			
    1639. 

  1639. 			<div class="method-subsection brief-description">
    1640. 

  1640. 				<p>Execute multiple SQL statements with callback handler</p>
    1641. 

  1641. 			</div>
    1642. 

  1642. 			
    1643. 

  1643. 		    
    1644. 

  1644. 

  1645. 			<div class="method-subsection method-declaration"><code>- (BOOL)executeStatements:(NSString *)<em>sql</em> withResultBlock:(FMDBExecuteStatementsCallbackBlock)<em>block</em></code></div>
    1646. 

  1646. 

  1647. 		    
    1648. 

  1648. 			
    1649. 

  1649. 			<div class="method-subsection arguments-section parameters">
    1650. 

  1650. 				<h4 class="method-subtitle parameter-title">Parameters</h4>
    1651. 

  1651. 				<table class="argument-def parameter-def">
    1652. 

  1652. 				
    1653. 

  1653. 					<tr>
    1654. 

  1654. 						<th scope="row" class="argument-name"><code>sql</code></th>
    1655. 

  1655. 						<td><p>The SQL to be performed.</p></td>
    1656. 

  1656. 					</tr>
    1657. 

  1657. 				
    1658. 

  1658. 					<tr>
    1659. 

  1659. 						<th scope="row" class="argument-name"><code>block</code></th>
    1660. 

  1660. 						<td><p>A block that will be called for any result sets returned by any SQL statements.
    1661. 

  1661.                   Note, if you supply this block, it must return integer value, zero upon success (this would be a good opportunity to use SQLITE_OK),
    1662. 

  1662.                   non-zero value upon failure (which will stop the bulk execution of the SQL).  If a statement returns values, the block will be called with the results from the query in NSDictionary *resultsDictionary.
    1663. 

  1663.                   This may be <code>nil</code> if you don&rsquo;t care to receive any results.</p></td>
    1664. 

  1664. 					</tr>
    1665. 

  1665. 				
    1666. 

  1666. 				</table>
    1667. 

  1667. 			</div>
    1668. 

  1668. 			
    1669. 

  1669. 

  1670. 			
    1671. 

  1671. 			<div class="method-subsection return">
    1672. 

  1672. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    1673. 

  1673. 				<p><code>YES</code> upon success; <code>NO</code> upon failure. If failed, you can call <a href="#//api/name/lastError"><code>lastError</code></a>,
    1674. 

  1674.                   <a href="#//api/name/lastErrorCode"><code>lastErrorCode</code></a>, or <a href="#//api/name/lastErrorMessage"><code>lastErrorMessage</code></a> for diagnostic information regarding the failure.</p>
    1675. 

  1675. 			</div>
    1676. 

  1676. 			
    1677. 

  1677. 

  1678. 			
    1679. 

  1679. 

  1680. 			
    1681. 

  1681. 			<div class="method-subsection discussion-section">
    1682. 

  1682. 				<h4 class="method-subtitle">Discussion</h4>
    1683. 

  1683. 				<p>Execute multiple SQL statements with callback handler</p>
    1684. 

  1684. 

  1685. <p>This executes a series of SQL statements that are combined in a single string (e.g. the SQL generated by the <code>sqlite3</code> command line <code>.dump</code> command). This accepts no value parameters, but rather simply expects a single string with multiple SQL statements, each terminated with a semicolon. This uses <code>sqlite3_exec</code>.</p>
    1686. 

  1686. 			</div>
    1687. 

  1687. 			
    1688. 

  1688. 

  1689. 			
    1690. 

  1690. 

  1691. 			
    1692. 

  1692. 			<div class="method-subsection see-also-section">
    1693. 

  1693. 				<h4 class="method-subtitle">See Also</h4>
    1694. 

  1694. 				<ul>
    1695. 

  1695. 					
    1696. 

  1696. 					<li><code><p><a href="#//api/name/executeStatements:">- executeStatements:</a></p></code></li>
    1697. 

  1697. 					
    1698. 

  1698. 					<li><code><p><a href="http://sqlite.org/c3ref/exec.html">sqlite3_exec()</a></p></code></li>
    1699. 

  1699. 					
    1700. 

  1700. 				</ul>
    1701. 

  1701. 			</div>
    1702. 

  1702. 			
    1703. 

  1703. 

  1704. 			
    1705. 

  1705. 			<div class="method-subsection declared-in-section">
    1706. 

  1706. 				<h4 class="method-subtitle">Declared In</h4>
    1707. 

  1707. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    1708. 

  1708. 			</div>
    1709. 

  1709. 			
    1710. 

  1710. 			
    1711. 

  1711. 		</div>
    1712. 

  1712. 	</div>
    1713. 

  1713. </div><div class="section-method">
    1714. 

  1714. 	<a name="//api/name/lastInsertRowId" title="lastInsertRowId"></a>
    1715. 

  1715. 	<h3 class="method-title"><code><a href="#//api/name/lastInsertRowId">&ndash;&nbsp;lastInsertRowId</a></code>
    1716. 

  1716. </h3>
    1717. 

  1717. 

  1718. 	<div class="method-info">
    1719. 

  1719. 		<div class="pointy-thing"></div>
    1720. 

  1720. 

  1721. 		<div class="method-info-container">
    1722. 

  1722. 			
    1723. 

  1723. 			
    1724. 

  1724. 			<div class="method-subsection brief-description">
    1725. 

  1725. 				<p>Last insert rowid</p>
    1726. 

  1726. 			</div>
    1727. 

  1727. 			
    1728. 

  1728. 		    
    1729. 

  1729. 

  1730. 			<div class="method-subsection method-declaration"><code>- (sqlite_int64)lastInsertRowId</code></div>
    1731. 

  1731. 

  1732. 		    
    1733. 

  1733. 			
    1734. 

  1734. 

  1735. 			
    1736. 

  1736. 			<div class="method-subsection return">
    1737. 

  1737. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    1738. 

  1738. 				<p>The rowid of the last inserted row.</p>
    1739. 

  1739. 			</div>
    1740. 

  1740. 			
    1741. 

  1741. 

  1742. 			
    1743. 

  1743. 

  1744. 			
    1745. 

  1745. 			<div class="method-subsection discussion-section">
    1746. 

  1746. 				<h4 class="method-subtitle">Discussion</h4>
    1747. 

  1747. 				<p>Last insert rowid</p>
    1748. 

  1748. 

  1749. <p>Each entry in an SQLite table has a unique 64-bit signed integer key called the &ldquo;rowid&rdquo;. The rowid is always available as an undeclared column named <code>ROWID</code>, <code>OID</code>, or <code>_ROWID_</code> as long as those names are not also used by explicitly declared columns. If the table has a column of type <code>INTEGER PRIMARY KEY</code> then that column is another alias for the rowid.</p>
    1750. 

  1750. 

  1751. <p>This routine returns the rowid of the most recent successful <code>INSERT</code> into the database from the database connection in the first argument. As of SQLite version 3.7.7, this routines records the last insert rowid of both ordinary tables and virtual tables. If no successful <code>INSERT</code>s have ever occurred on that database connection, zero is returned.</p>
    1752. 

  1752. 			</div>
    1753. 

  1753. 			
    1754. 

  1754. 

  1755. 			
    1756. 

  1756. 

  1757. 			
    1758. 

  1758. 			<div class="method-subsection see-also-section">
    1759. 

  1759. 				<h4 class="method-subtitle">See Also</h4>
    1760. 

  1760. 				<ul>
    1761. 

  1761. 					
    1762. 

  1762. 					<li><code><p><a href="http://sqlite.org/c3ref/last_insert_rowid.html">sqlite3_last_insert_rowid()</a></p></code></li>
    1763. 

  1763. 					
    1764. 

  1764. 				</ul>
    1765. 

  1765. 			</div>
    1766. 

  1766. 			
    1767. 

  1767. 

  1768. 			
    1769. 

  1769. 			<div class="method-subsection declared-in-section">
    1770. 

  1770. 				<h4 class="method-subtitle">Declared In</h4>
    1771. 

  1771. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    1772. 

  1772. 			</div>
    1773. 

  1773. 			
    1774. 

  1774. 			
    1775. 

  1775. 		</div>
    1776. 

  1776. 	</div>
    1777. 

  1777. </div><div class="section-method">
    1778. 

  1778. 	<a name="//api/name/changes" title="changes"></a>
    1779. 

  1779. 	<h3 class="method-title"><code><a href="#//api/name/changes">&ndash;&nbsp;changes</a></code>
    1780. 

  1780. </h3>
    1781. 

  1781. 

  1782. 	<div class="method-info">
    1783. 

  1783. 		<div class="pointy-thing"></div>
    1784. 

  1784. 

  1785. 		<div class="method-info-container">
    1786. 

  1786. 			
    1787. 

  1787. 			
    1788. 

  1788. 			<div class="method-subsection brief-description">
    1789. 

  1789. 				<p>The number of rows changed by prior SQL statement.</p>
    1790. 

  1790. 			</div>
    1791. 

  1791. 			
    1792. 

  1792. 		    
    1793. 

  1793. 

  1794. 			<div class="method-subsection method-declaration"><code>- (int)changes</code></div>
    1795. 

  1795. 

  1796. 		    
    1797. 

  1797. 			
    1798. 

  1798. 

  1799. 			
    1800. 

  1800. 			<div class="method-subsection return">
    1801. 

  1801. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    1802. 

  1802. 				<p>The number of rows changed by prior SQL statement.</p>
    1803. 

  1803. 			</div>
    1804. 

  1804. 			
    1805. 

  1805. 

  1806. 			
    1807. 

  1807. 

  1808. 			
    1809. 

  1809. 			<div class="method-subsection discussion-section">
    1810. 

  1810. 				<h4 class="method-subtitle">Discussion</h4>
    1811. 

  1811. 				<p>The number of rows changed by prior SQL statement.</p>
    1812. 

  1812. 

  1813. <p>This function returns the number of database rows that were changed or inserted or deleted by the most recently completed SQL statement on the database connection specified by the first parameter. Only changes that are directly specified by the INSERT, UPDATE, or DELETE statement are counted.</p>
    1814. 

  1814. 			</div>
    1815. 

  1815. 			
    1816. 

  1816. 

  1817. 			
    1818. 

  1818. 

  1819. 			
    1820. 

  1820. 			<div class="method-subsection see-also-section">
    1821. 

  1821. 				<h4 class="method-subtitle">See Also</h4>
    1822. 

  1822. 				<ul>
    1823. 

  1823. 					
    1824. 

  1824. 					<li><code><p><a href="http://sqlite.org/c3ref/changes.html">sqlite3_changes()</a></p></code></li>
    1825. 

  1825. 					
    1826. 

  1826. 				</ul>
    1827. 

  1827. 			</div>
    1828. 

  1828. 			
    1829. 

  1829. 

  1830. 			
    1831. 

  1831. 			<div class="method-subsection declared-in-section">
    1832. 

  1832. 				<h4 class="method-subtitle">Declared In</h4>
    1833. 

  1833. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    1834. 

  1834. 			</div>
    1835. 

  1835. 			
    1836. 

  1836. 			
    1837. 

  1837. 		</div>
    1838. 

  1838. 	</div>
    1839. 

  1839. </div>
    1840. 

  1840. 						</div>
    1841. 

  1841. 						
    1842. 

  1842. 

  1843. 						<a title="Retrieving results" name="task_Retrieving results"></a>
    1844. 

  1844. 						<h2 class="task-title">Retrieving results</h2>
    1845. 

  1845. 

  1846. 						<div class="task-list">
    1847. 

  1847. 							<div class="section-method">
    1848. 

  1848. 	<a name="//api/name/executeQuery:" title="executeQuery:"></a>
    1849. 

  1849. 	<h3 class="method-title"><code><a href="#//api/name/executeQuery:">&ndash;&nbsp;executeQuery:</a></code>
    1850. 

  1850. </h3>
    1851. 

  1851. 

  1852. 	<div class="method-info">
    1853. 

  1853. 		<div class="pointy-thing"></div>
    1854. 

  1854. 

  1855. 		<div class="method-info-container">
    1856. 

  1856. 			
    1857. 

  1857. 			
    1858. 

  1858. 			<div class="method-subsection brief-description">
    1859. 

  1859. 				<p>Execute select statement</p>
    1860. 

  1860. 			</div>
    1861. 

  1861. 			
    1862. 

  1862. 		    
    1863. 

  1863. 

  1864. 			<div class="method-subsection method-declaration"><code>- (FMResultSet *)executeQuery:(NSString *)<em>sql</em>, <em>...</em></code></div>
    1865. 

  1865. 

  1866. 		    
    1867. 

  1867. 			
    1868. 

  1868. 			<div class="method-subsection arguments-section parameters">
    1869. 

  1869. 				<h4 class="method-subtitle parameter-title">Parameters</h4>
    1870. 

  1870. 				<table class="argument-def parameter-def">
    1871. 

  1871. 				
    1872. 

  1872. 					<tr>
    1873. 

  1873. 						<th scope="row" class="argument-name"><code>sql</code></th>
    1874. 

  1874. 						<td><p>The SELECT statement to be performed, with optional <code>?</code> placeholders.</p></td>
    1875. 

  1875. 					</tr>
    1876. 

  1876. 				
    1877. 

  1877. 					<tr>
    1878. 

  1878. 						<th scope="row" class="argument-name"><code>...</code></th>
    1879. 

  1879. 						<td><p>Optional parameters to bind to <code>?</code> placeholders in the SQL statement. These should be Objective-C objects (e.g. <code>NSString</code>, <code>NSNumber</code>, etc.), not fundamental C data types (e.g. <code>int</code>, <code>char *</code>, etc.).</p></td>
    1880. 

  1880. 					</tr>
    1881. 

  1881. 				
    1882. 

  1882. 				</table>
    1883. 

  1883. 			</div>
    1884. 

  1884. 			
    1885. 

  1885. 

  1886. 			
    1887. 

  1887. 			<div class="method-subsection return">
    1888. 

  1888. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    1889. 

  1889. 				<p>A <a href="../Classes/FMResultSet.html"><code>FMResultSet</code></a> for the result set upon success; <code>nil</code> upon failure. If failed, you can call <a href="#//api/name/lastError"><code>lastError</code></a>, <a href="#//api/name/lastErrorCode"><code>lastErrorCode</code></a>, or <a href="#//api/name/lastErrorMessage"><code>lastErrorMessage</code></a> for diagnostic information regarding the failure.</p>
    1890. 

  1890. 			</div>
    1891. 

  1891. 			
    1892. 

  1892. 

  1893. 			
    1894. 

  1894. 

  1895. 			
    1896. 

  1896. 			<div class="method-subsection discussion-section">
    1897. 

  1897. 				<h4 class="method-subtitle">Discussion</h4>
    1898. 

  1898. 				<p>Execute select statement</p>
    1899. 

  1899. 

  1900. <p>Executing queries returns an <a href="../Classes/FMResultSet.html"><code>FMResultSet</code></a> object if successful, and <code>nil</code> upon failure.  Like executing updates, there is a variant that accepts an <code>NSError **</code> parameter.  Otherwise you should use the <a href="#//api/name/lastErrorMessage"><code>lastErrorMessage</code></a> and <a href="#//api/name/lastErrorMessage"><code>lastErrorMessage</code></a> methods to determine why a query failed.</p>
    1901. 

  1901. 

  1902. <p>In order to iterate through the results of your query, you use a <code>while()</code> loop.  You also need to &ldquo;step&rdquo; (via <a href="../Classes/FMResultSet.html#//api/name/next"><code>[FMResultSet next]</code></a>) from one record to the other.</p>
    1903. 

  1903. 

  1904. <p>This method employs <a href="http://sqlite.org/c3ref/bind_blob.html"><code>sqlite3_bind</code></a> for any optional value parameters. This  properly escapes any characters that need escape sequences (e.g. quotation marks), which eliminates simple SQL errors as well as protects against SQL injection attacks. This method natively handles <code>NSString</code>, <code>NSNumber</code>, <code>NSNull</code>, <code>NSDate</code>, and <code>NSData</code> objects. All other object types will be interpreted as text values using the object&rsquo;s <code>description</code> method.</p><div class="note"><p><strong>Note:</strong> If you want to use this from Swift, please note that you must include <code>FMDatabaseVariadic.swift</code> in your project. Without that, you cannot use this method directly, and instead have to use methods such as <a href="#//api/name/executeQuery:withArgumentsInArray:"><code>executeQuery:withArgumentsInArray:</code></a>.</p></div>
    1905. 

  1905. 			</div>
    1906. 

  1906. 			
    1907. 

  1907. 

  1908. 			
    1909. 

  1909. 

  1910. 			
    1911. 

  1911. 			<div class="method-subsection see-also-section">
    1912. 

  1912. 				<h4 class="method-subtitle">See Also</h4>
    1913. 

  1913. 				<ul>
    1914. 

  1914. 					
    1915. 

  1915. 					<li><code><p><a href="../Classes/FMResultSet.html">FMResultSet</a></p></code></li>
    1916. 

  1916. 					
    1917. 

  1917. 					<li><code><p><a href="../Classes/FMResultSet.html#//api/name/next"><code>FMResultSet next</code></a></p></code></li>
    1918. 

  1918. 					
    1919. 

  1919. 					<li><code><p><a href="http://sqlite.org/c3ref/bind_blob.html"><code>sqlite3_bind</code></a></p></code></li>
    1920. 

  1920. 					
    1921. 

  1921. 				</ul>
    1922. 

  1922. 			</div>
    1923. 

  1923. 			
    1924. 

  1924. 

  1925. 			
    1926. 

  1926. 			<div class="method-subsection declared-in-section">
    1927. 

  1927. 				<h4 class="method-subtitle">Declared In</h4>
    1928. 

  1928. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    1929. 

  1929. 			</div>
    1930. 

  1930. 			
    1931. 

  1931. 			
    1932. 

  1932. 		</div>
    1933. 

  1933. 	</div>
    1934. 

  1934. </div><div class="section-method">
    1935. 

  1935. 	<a name="//api/name/executeQueryWithFormat:" title="executeQueryWithFormat:"></a>
    1936. 

  1936. 	<h3 class="method-title"><code><a href="#//api/name/executeQueryWithFormat:">&ndash;&nbsp;executeQueryWithFormat:</a></code>
    1937. 

  1937. </h3>
    1938. 

  1938. 

  1939. 	<div class="method-info">
    1940. 

  1940. 		<div class="pointy-thing"></div>
    1941. 

  1941. 

  1942. 		<div class="method-info-container">
    1943. 

  1943. 			
    1944. 

  1944. 			
    1945. 

  1945. 			<div class="method-subsection brief-description">
    1946. 

  1946. 				<p>Execute select statement</p>
    1947. 

  1947. 			</div>
    1948. 

  1948. 			
    1949. 

  1949. 		    
    1950. 

  1950. 

  1951. 			<div class="method-subsection method-declaration"><code>- (FMResultSet *)executeQueryWithFormat:(NSString *)<em>format</em>, <em>...</em></code></div>
    1952. 

  1952. 

  1953. 		    
    1954. 

  1954. 			
    1955. 

  1955. 			<div class="method-subsection arguments-section parameters">
    1956. 

  1956. 				<h4 class="method-subtitle parameter-title">Parameters</h4>
    1957. 

  1957. 				<table class="argument-def parameter-def">
    1958. 

  1958. 				
    1959. 

  1959. 					<tr>
    1960. 

  1960. 						<th scope="row" class="argument-name"><code>format</code></th>
    1961. 

  1961. 						<td><p>The SQL to be performed, with <code>printf</code>-style escape sequences.</p></td>
    1962. 

  1962. 					</tr>
    1963. 

  1963. 				
    1964. 

  1964. 					<tr>
    1965. 

  1965. 						<th scope="row" class="argument-name"><code>...</code></th>
    1966. 

  1966. 						<td><p>Optional parameters to bind to use in conjunction with the <code>printf</code>-style escape sequences in the SQL statement.</p></td>
    1967. 

  1967. 					</tr>
    1968. 

  1968. 				
    1969. 

  1969. 				</table>
    1970. 

  1970. 			</div>
    1971. 

  1971. 			
    1972. 

  1972. 

  1973. 			
    1974. 

  1974. 			<div class="method-subsection return">
    1975. 

  1975. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    1976. 

  1976. 				<p>A <a href="../Classes/FMResultSet.html"><code>FMResultSet</code></a> for the result set upon success; <code>nil</code> upon failure. If failed, you can call <a href="#//api/name/lastError"><code>lastError</code></a>, <a href="#//api/name/lastErrorCode"><code>lastErrorCode</code></a>, or <a href="#//api/name/lastErrorMessage"><code>lastErrorMessage</code></a> for diagnostic information regarding the failure.</p>
    1977. 

  1977. 			</div>
    1978. 

  1978. 			
    1979. 

  1979. 

  1980. 			
    1981. 

  1981. 

  1982. 			
    1983. 

  1983. 			<div class="method-subsection discussion-section">
    1984. 

  1984. 				<h4 class="method-subtitle">Discussion</h4>
    1985. 

  1985. 				<p>Execute select statement</p>
    1986. 

  1986. 

  1987. <p>Executing queries returns an <a href="../Classes/FMResultSet.html"><code>FMResultSet</code></a> object if successful, and <code>nil</code> upon failure.  Like executing updates, there is a variant that accepts an <code>NSError **</code> parameter.  Otherwise you should use the <a href="#//api/name/lastErrorMessage"><code>lastErrorMessage</code></a> and <a href="#//api/name/lastErrorMessage"><code>lastErrorMessage</code></a> methods to determine why a query failed.</p>
    1988. 

  1988. 

  1989. <p>In order to iterate through the results of your query, you use a <code>while()</code> loop.  You also need to &ldquo;step&rdquo; (via <a href="../Classes/FMResultSet.html#//api/name/next"><code>[FMResultSet next]</code></a>) from one record to the other.</p><div class="note"><p><strong>Note:</strong> This method does not technically perform a traditional printf-style replacement. What this method actually does is replace the printf-style percent sequences with a SQLite <code>?</code> placeholder, and then bind values to that placeholder. Thus the following command</p>
    1990. 

  1990. 

  1991. <pre><code>[db executeQueryWithFormat:@"SELECT * FROM test WHERE name=%@", @"Gus"];
    1992. 

  1992. </code></pre>
    1993. 

  1993. 

  1994. <p>is actually replacing the <code>%@</code> with <code>?</code> placeholder, and then performing something equivalent to <code>executeQuery:</code></p>
    1995. 

  1995. 

  1996. <pre><code>[db executeQuery:@"SELECT * FROM test WHERE name=?", @"Gus"];
    1997. 

  1997. </code></pre>
    1998. 

  1998. 

  1999. <p>There are two reasons why this distinction is important. First, the printf-style escape sequences can only be used where it is permissible to use a SQLite <code>?</code> placeholder. You can use it only for values in SQL statements, but not for table names or column names or any other non-value context. This method also cannot be used in conjunction with <code>pragma</code> statements and the like. Second, note the lack of quotation marks in the SQL. The <code>WHERE</code> clause was <em>not</em> <code>WHERE name='%@'</code> (like you might have to do if you built a SQL statement using <code>NSString</code> method <code>stringWithFormat</code>), but rather simply <code>WHERE name=%@</code>.</p></div>
    2000. 

  2000. 			</div>
    2001. 

  2001. 			
    2002. 

  2002. 

  2003. 			
    2004. 

  2004. 

  2005. 			
    2006. 

  2006. 			<div class="method-subsection see-also-section">
    2007. 

  2007. 				<h4 class="method-subtitle">See Also</h4>
    2008. 

  2008. 				<ul>
    2009. 

  2009. 					
    2010. 

  2010. 					<li><code><p><a href="#//api/name/executeQuery:">- executeQuery:</a></p></code></li>
    2011. 

  2011. 					
    2012. 

  2012. 					<li><code><p><a href="../Classes/FMResultSet.html">FMResultSet</a></p></code></li>
    2013. 

  2013. 					
    2014. 

  2014. 					<li><code><p><a href="../Classes/FMResultSet.html#//api/name/next"><code>FMResultSet next</code></a></p></code></li>
    2015. 

  2015. 					
    2016. 

  2016. 				</ul>
    2017. 

  2017. 			</div>
    2018. 

  2018. 			
    2019. 

  2019. 

  2020. 			
    2021. 

  2021. 			<div class="method-subsection declared-in-section">
    2022. 

  2022. 				<h4 class="method-subtitle">Declared In</h4>
    2023. 

  2023. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    2024. 

  2024. 			</div>
    2025. 

  2025. 			
    2026. 

  2026. 			
    2027. 

  2027. 		</div>
    2028. 

  2028. 	</div>
    2029. 

  2029. </div><div class="section-method">
    2030. 

  2030. 	<a name="//api/name/executeQuery:withArgumentsInArray:" title="executeQuery:withArgumentsInArray:"></a>
    2031. 

  2031. 	<h3 class="method-title"><code><a href="#//api/name/executeQuery:withArgumentsInArray:">&ndash;&nbsp;executeQuery:withArgumentsInArray:</a></code>
    2032. 

  2032. </h3>
    2033. 

  2033. 

  2034. 	<div class="method-info">
    2035. 

  2035. 		<div class="pointy-thing"></div>
    2036. 

  2036. 

  2037. 		<div class="method-info-container">
    2038. 

  2038. 			
    2039. 

  2039. 			
    2040. 

  2040. 			<div class="method-subsection brief-description">
    2041. 

  2041. 				<p>Execute select statement</p>
    2042. 

  2042. 			</div>
    2043. 

  2043. 			
    2044. 

  2044. 		    
    2045. 

  2045. 

  2046. 			<div class="method-subsection method-declaration"><code>- (FMResultSet *)executeQuery:(NSString *)<em>sql</em> withArgumentsInArray:(NSArray *)<em>arguments</em></code></div>
    2047. 

  2047. 

  2048. 		    
    2049. 

  2049. 			
    2050. 

  2050. 			<div class="method-subsection arguments-section parameters">
    2051. 

  2051. 				<h4 class="method-subtitle parameter-title">Parameters</h4>
    2052. 

  2052. 				<table class="argument-def parameter-def">
    2053. 

  2053. 				
    2054. 

  2054. 					<tr>
    2055. 

  2055. 						<th scope="row" class="argument-name"><code>sql</code></th>
    2056. 

  2056. 						<td><p>The SELECT statement to be performed, with optional <code>?</code> placeholders.</p></td>
    2057. 

  2057. 					</tr>
    2058. 

  2058. 				
    2059. 

  2059. 					<tr>
    2060. 

  2060. 						<th scope="row" class="argument-name"><code>arguments</code></th>
    2061. 

  2061. 						<td><p>A <code>NSArray</code> of objects to be used when binding values to the <code>?</code> placeholders in the SQL statement.</p></td>
    2062. 

  2062. 					</tr>
    2063. 

  2063. 				
    2064. 

  2064. 				</table>
    2065. 

  2065. 			</div>
    2066. 

  2066. 			
    2067. 

  2067. 

  2068. 			
    2069. 

  2069. 			<div class="method-subsection return">
    2070. 

  2070. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    2071. 

  2071. 				<p>A <a href="../Classes/FMResultSet.html"><code>FMResultSet</code></a> for the result set upon success; <code>nil</code> upon failure. If failed, you can call <a href="#//api/name/lastError"><code>lastError</code></a>, <a href="#//api/name/lastErrorCode"><code>lastErrorCode</code></a>, or <a href="#//api/name/lastErrorMessage"><code>lastErrorMessage</code></a> for diagnostic information regarding the failure.</p>
    2072. 

  2072. 			</div>
    2073. 

  2073. 			
    2074. 

  2074. 

  2075. 			
    2076. 

  2076. 

  2077. 			
    2078. 

  2078. 			<div class="method-subsection discussion-section">
    2079. 

  2079. 				<h4 class="method-subtitle">Discussion</h4>
    2080. 

  2080. 				<p>Execute select statement</p>
    2081. 

  2081. 

  2082. <p>Executing queries returns an <a href="../Classes/FMResultSet.html"><code>FMResultSet</code></a> object if successful, and <code>nil</code> upon failure.  Like executing updates, there is a variant that accepts an <code>NSError **</code> parameter.  Otherwise you should use the <a href="#//api/name/lastErrorMessage"><code>lastErrorMessage</code></a> and <a href="#//api/name/lastErrorMessage"><code>lastErrorMessage</code></a> methods to determine why a query failed.</p>
    2083. 

  2083. 

  2084. <p>In order to iterate through the results of your query, you use a <code>while()</code> loop.  You also need to &ldquo;step&rdquo; (via <a href="../Classes/FMResultSet.html#//api/name/next"><code>[FMResultSet next]</code></a>) from one record to the other.</p>
    2085. 

  2085. 			</div>
    2086. 

  2086. 			
    2087. 

  2087. 

  2088. 			
    2089. 

  2089. 

  2090. 			
    2091. 

  2091. 			<div class="method-subsection see-also-section">
    2092. 

  2092. 				<h4 class="method-subtitle">See Also</h4>
    2093. 

  2093. 				<ul>
    2094. 

  2094. 					
    2095. 

  2095. 					<li><code><p><a href="../Classes/FMResultSet.html">FMResultSet</a></p></code></li>
    2096. 

  2096. 					
    2097. 

  2097. 					<li><code><p><a href="../Classes/FMResultSet.html#//api/name/next"><code>FMResultSet next</code></a></p></code></li>
    2098. 

  2098. 					
    2099. 

  2099. 				</ul>
    2100. 

  2100. 			</div>
    2101. 

  2101. 			
    2102. 

  2102. 

  2103. 			
    2104. 

  2104. 			<div class="method-subsection declared-in-section">
    2105. 

  2105. 				<h4 class="method-subtitle">Declared In</h4>
    2106. 

  2106. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    2107. 

  2107. 			</div>
    2108. 

  2108. 			
    2109. 

  2109. 			
    2110. 

  2110. 		</div>
    2111. 

  2111. 	</div>
    2112. 

  2112. </div><div class="section-method">
    2113. 

  2113. 	<a name="//api/name/executeQuery:withParameterDictionary:" title="executeQuery:withParameterDictionary:"></a>
    2114. 

  2114. 	<h3 class="method-title"><code><a href="#//api/name/executeQuery:withParameterDictionary:">&ndash;&nbsp;executeQuery:withParameterDictionary:</a></code>
    2115. 

  2115. </h3>
    2116. 

  2116. 

  2117. 	<div class="method-info">
    2118. 

  2118. 		<div class="pointy-thing"></div>
    2119. 

  2119. 

  2120. 		<div class="method-info-container">
    2121. 

  2121. 			
    2122. 

  2122. 			
    2123. 

  2123. 			<div class="method-subsection brief-description">
    2124. 

  2124. 				<p>Execute select statement</p>
    2125. 

  2125. 			</div>
    2126. 

  2126. 			
    2127. 

  2127. 		    
    2128. 

  2128. 

  2129. 			<div class="method-subsection method-declaration"><code>- (FMResultSet *)executeQuery:(NSString *)<em>sql</em> withParameterDictionary:(NSDictionary *)<em>arguments</em></code></div>
    2130. 

  2130. 

  2131. 		    
    2132. 

  2132. 			
    2133. 

  2133. 			<div class="method-subsection arguments-section parameters">
    2134. 

  2134. 				<h4 class="method-subtitle parameter-title">Parameters</h4>
    2135. 

  2135. 				<table class="argument-def parameter-def">
    2136. 

  2136. 				
    2137. 

  2137. 					<tr>
    2138. 

  2138. 						<th scope="row" class="argument-name"><code>sql</code></th>
    2139. 

  2139. 						<td><p>The SELECT statement to be performed, with optional <code>?</code> placeholders.</p></td>
    2140. 

  2140. 					</tr>
    2141. 

  2141. 				
    2142. 

  2142. 					<tr>
    2143. 

  2143. 						<th scope="row" class="argument-name"><code>arguments</code></th>
    2144. 

  2144. 						<td><p>A <code>NSDictionary</code> of objects keyed by column names that will be used when binding values to the <code>?</code> placeholders in the SQL statement.</p></td>
    2145. 

  2145. 					</tr>
    2146. 

  2146. 				
    2147. 

  2147. 				</table>
    2148. 

  2148. 			</div>
    2149. 

  2149. 			
    2150. 

  2150. 

  2151. 			
    2152. 

  2152. 			<div class="method-subsection return">
    2153. 

  2153. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    2154. 

  2154. 				<p>A <a href="../Classes/FMResultSet.html"><code>FMResultSet</code></a> for the result set upon success; <code>nil</code> upon failure. If failed, you can call <a href="#//api/name/lastError"><code>lastError</code></a>, <a href="#//api/name/lastErrorCode"><code>lastErrorCode</code></a>, or <a href="#//api/name/lastErrorMessage"><code>lastErrorMessage</code></a> for diagnostic information regarding the failure.</p>
    2155. 

  2155. 			</div>
    2156. 

  2156. 			
    2157. 

  2157. 

  2158. 			
    2159. 

  2159. 

  2160. 			
    2161. 

  2161. 			<div class="method-subsection discussion-section">
    2162. 

  2162. 				<h4 class="method-subtitle">Discussion</h4>
    2163. 

  2163. 				<p>Execute select statement</p>
    2164. 

  2164. 

  2165. <p>Executing queries returns an <a href="../Classes/FMResultSet.html"><code>FMResultSet</code></a> object if successful, and <code>nil</code> upon failure.  Like executing updates, there is a variant that accepts an <code>NSError **</code> parameter.  Otherwise you should use the <a href="#//api/name/lastErrorMessage"><code>lastErrorMessage</code></a> and <a href="#//api/name/lastErrorMessage"><code>lastErrorMessage</code></a> methods to determine why a query failed.</p>
    2166. 

  2166. 

  2167. <p>In order to iterate through the results of your query, you use a <code>while()</code> loop.  You also need to &ldquo;step&rdquo; (via <a href="../Classes/FMResultSet.html#//api/name/next"><code>[FMResultSet next]</code></a>) from one record to the other.</p>
    2168. 

  2168. 			</div>
    2169. 

  2169. 			
    2170. 

  2170. 

  2171. 			
    2172. 

  2172. 

  2173. 			
    2174. 

  2174. 			<div class="method-subsection see-also-section">
    2175. 

  2175. 				<h4 class="method-subtitle">See Also</h4>
    2176. 

  2176. 				<ul>
    2177. 

  2177. 					
    2178. 

  2178. 					<li><code><p><a href="../Classes/FMResultSet.html">FMResultSet</a></p></code></li>
    2179. 

  2179. 					
    2180. 

  2180. 					<li><code><p><a href="../Classes/FMResultSet.html#//api/name/next"><code>FMResultSet next</code></a></p></code></li>
    2181. 

  2181. 					
    2182. 

  2182. 				</ul>
    2183. 

  2183. 			</div>
    2184. 

  2184. 			
    2185. 

  2185. 

  2186. 			
    2187. 

  2187. 			<div class="method-subsection declared-in-section">
    2188. 

  2188. 				<h4 class="method-subtitle">Declared In</h4>
    2189. 

  2189. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    2190. 

  2190. 			</div>
    2191. 

  2191. 			
    2192. 

  2192. 			
    2193. 

  2193. 		</div>
    2194. 

  2194. 	</div>
    2195. 

  2195. </div>
    2196. 

  2196. 						</div>
    2197. 

  2197. 						
    2198. 

  2198. 

  2199. 						<a title="Transactions" name="task_Transactions"></a>
    2200. 

  2200. 						<h2 class="task-title">Transactions</h2>
    2201. 

  2201. 

  2202. 						<div class="task-list">
    2203. 

  2203. 							<div class="section-method">
    2204. 

  2204. 	<a name="//api/name/beginTransaction" title="beginTransaction"></a>
    2205. 

  2205. 	<h3 class="method-title"><code><a href="#//api/name/beginTransaction">&ndash;&nbsp;beginTransaction</a></code>
    2206. 

  2206. </h3>
    2207. 

  2207. 

  2208. 	<div class="method-info">
    2209. 

  2209. 		<div class="pointy-thing"></div>
    2210. 

  2210. 

  2211. 		<div class="method-info-container">
    2212. 

  2212. 			
    2213. 

  2213. 			
    2214. 

  2214. 			<div class="method-subsection brief-description">
    2215. 

  2215. 				<p>Begin a transaction</p>
    2216. 

  2216. 			</div>
    2217. 

  2217. 			
    2218. 

  2218. 		    
    2219. 

  2219. 

  2220. 			<div class="method-subsection method-declaration"><code>- (BOOL)beginTransaction</code></div>
    2221. 

  2221. 

  2222. 		    
    2223. 

  2223. 			
    2224. 

  2224. 

  2225. 			
    2226. 

  2226. 			<div class="method-subsection return">
    2227. 

  2227. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    2228. 

  2228. 				<p><code>YES</code> on success; <code>NO</code> on failure. If failed, you can call <a href="#//api/name/lastError"><code>lastError</code></a>, <a href="#//api/name/lastErrorCode"><code>lastErrorCode</code></a>, or <a href="#//api/name/lastErrorMessage"><code>lastErrorMessage</code></a> for diagnostic information regarding the failure.</p>
    2229. 

  2229. 			</div>
    2230. 

  2230. 			
    2231. 

  2231. 

  2232. 			
    2233. 

  2233. 

  2234. 			
    2235. 

  2235. 			<div class="method-subsection discussion-section">
    2236. 

  2236. 				<h4 class="method-subtitle">Discussion</h4>
    2237. 

  2237. 				<p>Begin a transaction</p>
    2238. 

  2238. 			</div>
    2239. 

  2239. 			
    2240. 

  2240. 

  2241. 			
    2242. 

  2242. 

  2243. 			
    2244. 

  2244. 			<div class="method-subsection see-also-section">
    2245. 

  2245. 				<h4 class="method-subtitle">See Also</h4>
    2246. 

  2246. 				<ul>
    2247. 

  2247. 					
    2248. 

  2248. 					<li><code><p><a href="#//api/name/commit">- commit</a></p></code></li>
    2249. 

  2249. 					
    2250. 

  2250. 					<li><code><p><a href="#//api/name/rollback">- rollback</a></p></code></li>
    2251. 

  2251. 					
    2252. 

  2252. 					<li><code><p><a href="#//api/name/beginDeferredTransaction">- beginDeferredTransaction</a></p></code></li>
    2253. 

  2253. 					
    2254. 

  2254. 					<li><code><p><a href="#//api/name/inTransaction">- inTransaction</a></p></code></li>
    2255. 

  2255. 					
    2256. 

  2256. 				</ul>
    2257. 

  2257. 			</div>
    2258. 

  2258. 			
    2259. 

  2259. 

  2260. 			
    2261. 

  2261. 			<div class="method-subsection declared-in-section">
    2262. 

  2262. 				<h4 class="method-subtitle">Declared In</h4>
    2263. 

  2263. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    2264. 

  2264. 			</div>
    2265. 

  2265. 			
    2266. 

  2266. 			
    2267. 

  2267. 		</div>
    2268. 

  2268. 	</div>
    2269. 

  2269. </div><div class="section-method">
    2270. 

  2270. 	<a name="//api/name/beginDeferredTransaction" title="beginDeferredTransaction"></a>
    2271. 

  2271. 	<h3 class="method-title"><code><a href="#//api/name/beginDeferredTransaction">&ndash;&nbsp;beginDeferredTransaction</a></code>
    2272. 

  2272. </h3>
    2273. 

  2273. 

  2274. 	<div class="method-info">
    2275. 

  2275. 		<div class="pointy-thing"></div>
    2276. 

  2276. 

  2277. 		<div class="method-info-container">
    2278. 

  2278. 			
    2279. 

  2279. 			
    2280. 

  2280. 			<div class="method-subsection brief-description">
    2281. 

  2281. 				<p>Begin a deferred transaction</p>
    2282. 

  2282. 			</div>
    2283. 

  2283. 			
    2284. 

  2284. 		    
    2285. 

  2285. 

  2286. 			<div class="method-subsection method-declaration"><code>- (BOOL)beginDeferredTransaction</code></div>
    2287. 

  2287. 

  2288. 		    
    2289. 

  2289. 			
    2290. 

  2290. 

  2291. 			
    2292. 

  2292. 			<div class="method-subsection return">
    2293. 

  2293. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    2294. 

  2294. 				<p><code>YES</code> on success; <code>NO</code> on failure. If failed, you can call <a href="#//api/name/lastError"><code>lastError</code></a>, <a href="#//api/name/lastErrorCode"><code>lastErrorCode</code></a>, or <a href="#//api/name/lastErrorMessage"><code>lastErrorMessage</code></a> for diagnostic information regarding the failure.</p>
    2295. 

  2295. 			</div>
    2296. 

  2296. 			
    2297. 

  2297. 

  2298. 			
    2299. 

  2299. 

  2300. 			
    2301. 

  2301. 			<div class="method-subsection discussion-section">
    2302. 

  2302. 				<h4 class="method-subtitle">Discussion</h4>
    2303. 

  2303. 				<p>Begin a deferred transaction</p>
    2304. 

  2304. 			</div>
    2305. 

  2305. 			
    2306. 

  2306. 

  2307. 			
    2308. 

  2308. 

  2309. 			
    2310. 

  2310. 			<div class="method-subsection see-also-section">
    2311. 

  2311. 				<h4 class="method-subtitle">See Also</h4>
    2312. 

  2312. 				<ul>
    2313. 

  2313. 					
    2314. 

  2314. 					<li><code><p><a href="#//api/name/commit">- commit</a></p></code></li>
    2315. 

  2315. 					
    2316. 

  2316. 					<li><code><p><a href="#//api/name/rollback">- rollback</a></p></code></li>
    2317. 

  2317. 					
    2318. 

  2318. 					<li><code><p><a href="#//api/name/beginTransaction">- beginTransaction</a></p></code></li>
    2319. 

  2319. 					
    2320. 

  2320. 					<li><code><p><a href="#//api/name/inTransaction">- inTransaction</a></p></code></li>
    2321. 

  2321. 					
    2322. 

  2322. 				</ul>
    2323. 

  2323. 			</div>
    2324. 

  2324. 			
    2325. 

  2325. 

  2326. 			
    2327. 

  2327. 			<div class="method-subsection declared-in-section">
    2328. 

  2328. 				<h4 class="method-subtitle">Declared In</h4>
    2329. 

  2329. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    2330. 

  2330. 			</div>
    2331. 

  2331. 			
    2332. 

  2332. 			
    2333. 

  2333. 		</div>
    2334. 

  2334. 	</div>
    2335. 

  2335. </div><div class="section-method">
    2336. 

  2336. 	<a name="//api/name/commit" title="commit"></a>
    2337. 

  2337. 	<h3 class="method-title"><code><a href="#//api/name/commit">&ndash;&nbsp;commit</a></code>
    2338. 

  2338. </h3>
    2339. 

  2339. 

  2340. 	<div class="method-info">
    2341. 

  2341. 		<div class="pointy-thing"></div>
    2342. 

  2342. 

  2343. 		<div class="method-info-container">
    2344. 

  2344. 			
    2345. 

  2345. 			
    2346. 

  2346. 			<div class="method-subsection brief-description">
    2347. 

  2347. 				<p>Commit a transaction</p>
    2348. 

  2348. 			</div>
    2349. 

  2349. 			
    2350. 

  2350. 		    
    2351. 

  2351. 

  2352. 			<div class="method-subsection method-declaration"><code>- (BOOL)commit</code></div>
    2353. 

  2353. 

  2354. 		    
    2355. 

  2355. 			
    2356. 

  2356. 

  2357. 			
    2358. 

  2358. 			<div class="method-subsection return">
    2359. 

  2359. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    2360. 

  2360. 				<p><code>YES</code> on success; <code>NO</code> on failure. If failed, you can call <a href="#//api/name/lastError"><code>lastError</code></a>, <a href="#//api/name/lastErrorCode"><code>lastErrorCode</code></a>, or <a href="#//api/name/lastErrorMessage"><code>lastErrorMessage</code></a> for diagnostic information regarding the failure.</p>
    2361. 

  2361. 			</div>
    2362. 

  2362. 			
    2363. 

  2363. 

  2364. 			
    2365. 

  2365. 

  2366. 			
    2367. 

  2367. 			<div class="method-subsection discussion-section">
    2368. 

  2368. 				<h4 class="method-subtitle">Discussion</h4>
    2369. 

  2369. 				<p>Commit a transaction</p>
    2370. 

  2370. 

  2371. <p>Commit a transaction that was initiated with either <a href="#//api/name/beginTransaction"><code>beginTransaction</code></a> or with <a href="#//api/name/beginDeferredTransaction"><code>beginDeferredTransaction</code></a>.</p>
    2372. 

  2372. 			</div>
    2373. 

  2373. 			
    2374. 

  2374. 

  2375. 			
    2376. 

  2376. 

  2377. 			
    2378. 

  2378. 			<div class="method-subsection see-also-section">
    2379. 

  2379. 				<h4 class="method-subtitle">See Also</h4>
    2380. 

  2380. 				<ul>
    2381. 

  2381. 					
    2382. 

  2382. 					<li><code><p><a href="#//api/name/beginTransaction">- beginTransaction</a></p></code></li>
    2383. 

  2383. 					
    2384. 

  2384. 					<li><code><p><a href="#//api/name/beginDeferredTransaction">- beginDeferredTransaction</a></p></code></li>
    2385. 

  2385. 					
    2386. 

  2386. 					<li><code><p><a href="#//api/name/rollback">- rollback</a></p></code></li>
    2387. 

  2387. 					
    2388. 

  2388. 					<li><code><p><a href="#//api/name/inTransaction">- inTransaction</a></p></code></li>
    2389. 

  2389. 					
    2390. 

  2390. 				</ul>
    2391. 

  2391. 			</div>
    2392. 

  2392. 			
    2393. 

  2393. 

  2394. 			
    2395. 

  2395. 			<div class="method-subsection declared-in-section">
    2396. 

  2396. 				<h4 class="method-subtitle">Declared In</h4>
    2397. 

  2397. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    2398. 

  2398. 			</div>
    2399. 

  2399. 			
    2400. 

  2400. 			
    2401. 

  2401. 		</div>
    2402. 

  2402. 	</div>
    2403. 

  2403. </div><div class="section-method">
    2404. 

  2404. 	<a name="//api/name/rollback" title="rollback"></a>
    2405. 

  2405. 	<h3 class="method-title"><code><a href="#//api/name/rollback">&ndash;&nbsp;rollback</a></code>
    2406. 

  2406. </h3>
    2407. 

  2407. 

  2408. 	<div class="method-info">
    2409. 

  2409. 		<div class="pointy-thing"></div>
    2410. 

  2410. 

  2411. 		<div class="method-info-container">
    2412. 

  2412. 			
    2413. 

  2413. 			
    2414. 

  2414. 			<div class="method-subsection brief-description">
    2415. 

  2415. 				<p>Rollback a transaction</p>
    2416. 

  2416. 			</div>
    2417. 

  2417. 			
    2418. 

  2418. 		    
    2419. 

  2419. 

  2420. 			<div class="method-subsection method-declaration"><code>- (BOOL)rollback</code></div>
    2421. 

  2421. 

  2422. 		    
    2423. 

  2423. 			
    2424. 

  2424. 

  2425. 			
    2426. 

  2426. 			<div class="method-subsection return">
    2427. 

  2427. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    2428. 

  2428. 				<p><code>YES</code> on success; <code>NO</code> on failure. If failed, you can call <a href="#//api/name/lastError"><code>lastError</code></a>, <a href="#//api/name/lastErrorCode"><code>lastErrorCode</code></a>, or <a href="#//api/name/lastErrorMessage"><code>lastErrorMessage</code></a> for diagnostic information regarding the failure.</p>
    2429. 

  2429. 			</div>
    2430. 

  2430. 			
    2431. 

  2431. 

  2432. 			
    2433. 

  2433. 

  2434. 			
    2435. 

  2435. 			<div class="method-subsection discussion-section">
    2436. 

  2436. 				<h4 class="method-subtitle">Discussion</h4>
    2437. 

  2437. 				<p>Rollback a transaction</p>
    2438. 

  2438. 

  2439. <p>Rollback a transaction that was initiated with either <a href="#//api/name/beginTransaction"><code>beginTransaction</code></a> or with <a href="#//api/name/beginDeferredTransaction"><code>beginDeferredTransaction</code></a>.</p>
    2440. 

  2440. 			</div>
    2441. 

  2441. 			
    2442. 

  2442. 

  2443. 			
    2444. 

  2444. 

  2445. 			
    2446. 

  2446. 			<div class="method-subsection see-also-section">
    2447. 

  2447. 				<h4 class="method-subtitle">See Also</h4>
    2448. 

  2448. 				<ul>
    2449. 

  2449. 					
    2450. 

  2450. 					<li><code><p><a href="#//api/name/beginTransaction">- beginTransaction</a></p></code></li>
    2451. 

  2451. 					
    2452. 

  2452. 					<li><code><p><a href="#//api/name/beginDeferredTransaction">- beginDeferredTransaction</a></p></code></li>
    2453. 

  2453. 					
    2454. 

  2454. 					<li><code><p><a href="#//api/name/commit">- commit</a></p></code></li>
    2455. 

  2455. 					
    2456. 

  2456. 					<li><code><p><a href="#//api/name/inTransaction">- inTransaction</a></p></code></li>
    2457. 

  2457. 					
    2458. 

  2458. 				</ul>
    2459. 

  2459. 			</div>
    2460. 

  2460. 			
    2461. 

  2461. 

  2462. 			
    2463. 

  2463. 			<div class="method-subsection declared-in-section">
    2464. 

  2464. 				<h4 class="method-subtitle">Declared In</h4>
    2465. 

  2465. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    2466. 

  2466. 			</div>
    2467. 

  2467. 			
    2468. 

  2468. 			
    2469. 

  2469. 		</div>
    2470. 

  2470. 	</div>
    2471. 

  2471. </div><div class="section-method">
    2472. 

  2472. 	<a name="//api/name/inTransaction" title="inTransaction"></a>
    2473. 

  2473. 	<h3 class="method-title"><code><a href="#//api/name/inTransaction">&ndash;&nbsp;inTransaction</a></code>
    2474. 

  2474. </h3>
    2475. 

  2475. 

  2476. 	<div class="method-info">
    2477. 

  2477. 		<div class="pointy-thing"></div>
    2478. 

  2478. 

  2479. 		<div class="method-info-container">
    2480. 

  2480. 			
    2481. 

  2481. 			
    2482. 

  2482. 			<div class="method-subsection brief-description">
    2483. 

  2483. 				<p>Identify whether currently in a transaction or not</p>
    2484. 

  2484. 			</div>
    2485. 

  2485. 			
    2486. 

  2486. 		    
    2487. 

  2487. 

  2488. 			<div class="method-subsection method-declaration"><code>- (BOOL)inTransaction</code></div>
    2489. 

  2489. 

  2490. 		    
    2491. 

  2491. 			
    2492. 

  2492. 

  2493. 			
    2494. 

  2494. 			<div class="method-subsection return">
    2495. 

  2495. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    2496. 

  2496. 				<p><code>YES</code> if currently within transaction; <code>NO</code> if not.</p>
    2497. 

  2497. 			</div>
    2498. 

  2498. 			
    2499. 

  2499. 

  2500. 			
    2501. 

  2501. 

  2502. 			
    2503. 

  2503. 			<div class="method-subsection discussion-section">
    2504. 

  2504. 				<h4 class="method-subtitle">Discussion</h4>
    2505. 

  2505. 				<p>Identify whether currently in a transaction or not</p>
    2506. 

  2506. 			</div>
    2507. 

  2507. 			
    2508. 

  2508. 

  2509. 			
    2510. 

  2510. 

  2511. 			
    2512. 

  2512. 			<div class="method-subsection see-also-section">
    2513. 

  2513. 				<h4 class="method-subtitle">See Also</h4>
    2514. 

  2514. 				<ul>
    2515. 

  2515. 					
    2516. 

  2516. 					<li><code><p><a href="#//api/name/beginTransaction">- beginTransaction</a></p></code></li>
    2517. 

  2517. 					
    2518. 

  2518. 					<li><code><p><a href="#//api/name/beginDeferredTransaction">- beginDeferredTransaction</a></p></code></li>
    2519. 

  2519. 					
    2520. 

  2520. 					<li><code><p><a href="#//api/name/commit">- commit</a></p></code></li>
    2521. 

  2521. 					
    2522. 

  2522. 					<li><code><p><a href="#//api/name/rollback">- rollback</a></p></code></li>
    2523. 

  2523. 					
    2524. 

  2524. 				</ul>
    2525. 

  2525. 			</div>
    2526. 

  2526. 			
    2527. 

  2527. 

  2528. 			
    2529. 

  2529. 			<div class="method-subsection declared-in-section">
    2530. 

  2530. 				<h4 class="method-subtitle">Declared In</h4>
    2531. 

  2531. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    2532. 

  2532. 			</div>
    2533. 

  2533. 			
    2534. 

  2534. 			
    2535. 

  2535. 		</div>
    2536. 

  2536. 	</div>
    2537. 

  2537. </div>
    2538. 

  2538. 						</div>
    2539. 

  2539. 						
    2540. 

  2540. 

  2541. 						<a title="Cached statements and result sets" name="task_Cached statements and result sets"></a>
    2542. 

  2542. 						<h2 class="task-title">Cached statements and result sets</h2>
    2543. 

  2543. 

  2544. 						<div class="task-list">
    2545. 

  2545. 							<div class="section-method">
    2546. 

  2546. 	<a name="//api/name/clearCachedStatements" title="clearCachedStatements"></a>
    2547. 

  2547. 	<h3 class="method-title"><code><a href="#//api/name/clearCachedStatements">&ndash;&nbsp;clearCachedStatements</a></code>
    2548. 

  2548. </h3>
    2549. 

  2549. 

  2550. 	<div class="method-info">
    2551. 

  2551. 		<div class="pointy-thing"></div>
    2552. 

  2552. 

  2553. 		<div class="method-info-container">
    2554. 

  2554. 			
    2555. 

  2555. 			
    2556. 

  2556. 			<div class="method-subsection brief-description">
    2557. 

  2557. 				<p>Clear cached statements</p>
    2558. 

  2558. 			</div>
    2559. 

  2559. 			
    2560. 

  2560. 		    
    2561. 

  2561. 

  2562. 			<div class="method-subsection method-declaration"><code>- (void)clearCachedStatements</code></div>
    2563. 

  2563. 

  2564. 		    
    2565. 

  2565. 			
    2566. 

  2566. 

  2567. 			
    2568. 

  2568. 

  2569. 			
    2570. 

  2570. 

  2571. 			
    2572. 

  2572. 			<div class="method-subsection discussion-section">
    2573. 

  2573. 				<h4 class="method-subtitle">Discussion</h4>
    2574. 

  2574. 				<p>Clear cached statements</p>
    2575. 

  2575. 			</div>
    2576. 

  2576. 			
    2577. 

  2577. 

  2578. 			
    2579. 

  2579. 

  2580. 			
    2581. 

  2581. 

  2582. 			
    2583. 

  2583. 			<div class="method-subsection declared-in-section">
    2584. 

  2584. 				<h4 class="method-subtitle">Declared In</h4>
    2585. 

  2585. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    2586. 

  2586. 			</div>
    2587. 

  2587. 			
    2588. 

  2588. 			
    2589. 

  2589. 		</div>
    2590. 

  2590. 	</div>
    2591. 

  2591. </div><div class="section-method">
    2592. 

  2592. 	<a name="//api/name/closeOpenResultSets" title="closeOpenResultSets"></a>
    2593. 

  2593. 	<h3 class="method-title"><code><a href="#//api/name/closeOpenResultSets">&ndash;&nbsp;closeOpenResultSets</a></code>
    2594. 

  2594. </h3>
    2595. 

  2595. 

  2596. 	<div class="method-info">
    2597. 

  2597. 		<div class="pointy-thing"></div>
    2598. 

  2598. 

  2599. 		<div class="method-info-container">
    2600. 

  2600. 			
    2601. 

  2601. 			
    2602. 

  2602. 			<div class="method-subsection brief-description">
    2603. 

  2603. 				<p>Close all open result sets</p>
    2604. 

  2604. 			</div>
    2605. 

  2605. 			
    2606. 

  2606. 		    
    2607. 

  2607. 

  2608. 			<div class="method-subsection method-declaration"><code>- (void)closeOpenResultSets</code></div>
    2609. 

  2609. 

  2610. 		    
    2611. 

  2611. 			
    2612. 

  2612. 

  2613. 			
    2614. 

  2614. 

  2615. 			
    2616. 

  2616. 

  2617. 			
    2618. 

  2618. 			<div class="method-subsection discussion-section">
    2619. 

  2619. 				<h4 class="method-subtitle">Discussion</h4>
    2620. 

  2620. 				<p>Close all open result sets</p>
    2621. 

  2621. 			</div>
    2622. 

  2622. 			
    2623. 

  2623. 

  2624. 			
    2625. 

  2625. 

  2626. 			
    2627. 

  2627. 

  2628. 			
    2629. 

  2629. 			<div class="method-subsection declared-in-section">
    2630. 

  2630. 				<h4 class="method-subtitle">Declared In</h4>
    2631. 

  2631. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    2632. 

  2632. 			</div>
    2633. 

  2633. 			
    2634. 

  2634. 			
    2635. 

  2635. 		</div>
    2636. 

  2636. 	</div>
    2637. 

  2637. </div><div class="section-method">
    2638. 

  2638. 	<a name="//api/name/hasOpenResultSets" title="hasOpenResultSets"></a>
    2639. 

  2639. 	<h3 class="method-title"><code><a href="#//api/name/hasOpenResultSets">&ndash;&nbsp;hasOpenResultSets</a></code>
    2640. 

  2640. </h3>
    2641. 

  2641. 

  2642. 	<div class="method-info">
    2643. 

  2643. 		<div class="pointy-thing"></div>
    2644. 

  2644. 

  2645. 		<div class="method-info-container">
    2646. 

  2646. 			
    2647. 

  2647. 			
    2648. 

  2648. 			<div class="method-subsection brief-description">
    2649. 

  2649. 				<p>Whether database has any open result sets</p>
    2650. 

  2650. 			</div>
    2651. 

  2651. 			
    2652. 

  2652. 		    
    2653. 

  2653. 

  2654. 			<div class="method-subsection method-declaration"><code>- (BOOL)hasOpenResultSets</code></div>
    2655. 

  2655. 

  2656. 		    
    2657. 

  2657. 			
    2658. 

  2658. 

  2659. 			
    2660. 

  2660. 			<div class="method-subsection return">
    2661. 

  2661. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    2662. 

  2662. 				<p><code>YES</code> if there are open result sets; <code>NO</code> if not.</p>
    2663. 

  2663. 			</div>
    2664. 

  2664. 			
    2665. 

  2665. 

  2666. 			
    2667. 

  2667. 

  2668. 			
    2669. 

  2669. 			<div class="method-subsection discussion-section">
    2670. 

  2670. 				<h4 class="method-subtitle">Discussion</h4>
    2671. 

  2671. 				<p>Whether database has any open result sets</p>
    2672. 

  2672. 			</div>
    2673. 

  2673. 			
    2674. 

  2674. 

  2675. 			
    2676. 

  2676. 

  2677. 			
    2678. 

  2678. 

  2679. 			
    2680. 

  2680. 			<div class="method-subsection declared-in-section">
    2681. 

  2681. 				<h4 class="method-subtitle">Declared In</h4>
    2682. 

  2682. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    2683. 

  2683. 			</div>
    2684. 

  2684. 			
    2685. 

  2685. 			
    2686. 

  2686. 		</div>
    2687. 

  2687. 	</div>
    2688. 

  2688. </div><div class="section-method">
    2689. 

  2689. 	<a name="//api/name/shouldCacheStatements" title="shouldCacheStatements"></a>
    2690. 

  2690. 	<h3 class="method-title"><code><a href="#//api/name/shouldCacheStatements">&ndash;&nbsp;shouldCacheStatements</a></code>
    2691. 

  2691. </h3>
    2692. 

  2692. 

  2693. 	<div class="method-info">
    2694. 

  2694. 		<div class="pointy-thing"></div>
    2695. 

  2695. 

  2696. 		<div class="method-info-container">
    2697. 

  2697. 			
    2698. 

  2698. 			
    2699. 

  2699. 			<div class="method-subsection brief-description">
    2700. 

  2700. 				<p>Return whether should cache statements or not</p>
    2701. 

  2701. 			</div>
    2702. 

  2702. 			
    2703. 

  2703. 		    
    2704. 

  2704. 

  2705. 			<div class="method-subsection method-declaration"><code>- (BOOL)shouldCacheStatements</code></div>
    2706. 

  2706. 

  2707. 		    
    2708. 

  2708. 			
    2709. 

  2709. 

  2710. 			
    2711. 

  2711. 			<div class="method-subsection return">
    2712. 

  2712. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    2713. 

  2713. 				<p><code>YES</code> if should cache statements; <code>NO</code> if not.</p>
    2714. 

  2714. 			</div>
    2715. 

  2715. 			
    2716. 

  2716. 

  2717. 			
    2718. 

  2718. 

  2719. 			
    2720. 

  2720. 			<div class="method-subsection discussion-section">
    2721. 

  2721. 				<h4 class="method-subtitle">Discussion</h4>
    2722. 

  2722. 				<p>Return whether should cache statements or not</p>
    2723. 

  2723. 			</div>
    2724. 

  2724. 			
    2725. 

  2725. 

  2726. 			
    2727. 

  2727. 

  2728. 			
    2729. 

  2729. 

  2730. 			
    2731. 

  2731. 			<div class="method-subsection declared-in-section">
    2732. 

  2732. 				<h4 class="method-subtitle">Declared In</h4>
    2733. 

  2733. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    2734. 

  2734. 			</div>
    2735. 

  2735. 			
    2736. 

  2736. 			
    2737. 

  2737. 		</div>
    2738. 

  2738. 	</div>
    2739. 

  2739. </div><div class="section-method">
    2740. 

  2740. 	<a name="//api/name/setShouldCacheStatements:" title="setShouldCacheStatements:"></a>
    2741. 

  2741. 	<h3 class="method-title"><code><a href="#//api/name/setShouldCacheStatements:">&ndash;&nbsp;setShouldCacheStatements:</a></code>
    2742. 

  2742. </h3>
    2743. 

  2743. 

  2744. 	<div class="method-info">
    2745. 

  2745. 		<div class="pointy-thing"></div>
    2746. 

  2746. 

  2747. 		<div class="method-info-container">
    2748. 

  2748. 			
    2749. 

  2749. 			
    2750. 

  2750. 			<div class="method-subsection brief-description">
    2751. 

  2751. 				<p>Set whether should cache statements or not</p>
    2752. 

  2752. 			</div>
    2753. 

  2753. 			
    2754. 

  2754. 		    
    2755. 

  2755. 

  2756. 			<div class="method-subsection method-declaration"><code>- (void)setShouldCacheStatements:(BOOL)<em>value</em></code></div>
    2757. 

  2757. 

  2758. 		    
    2759. 

  2759. 			
    2760. 

  2760. 			<div class="method-subsection arguments-section parameters">
    2761. 

  2761. 				<h4 class="method-subtitle parameter-title">Parameters</h4>
    2762. 

  2762. 				<table class="argument-def parameter-def">
    2763. 

  2763. 				
    2764. 

  2764. 					<tr>
    2765. 

  2765. 						<th scope="row" class="argument-name"><code>value</code></th>
    2766. 

  2766. 						<td><p><code>YES</code> if should cache statements; <code>NO</code> if not.</p></td>
    2767. 

  2767. 					</tr>
    2768. 

  2768. 				
    2769. 

  2769. 				</table>
    2770. 

  2770. 			</div>
    2771. 

  2771. 			
    2772. 

  2772. 

  2773. 			
    2774. 

  2774. 

  2775. 			
    2776. 

  2776. 

  2777. 			
    2778. 

  2778. 			<div class="method-subsection discussion-section">
    2779. 

  2779. 				<h4 class="method-subtitle">Discussion</h4>
    2780. 

  2780. 				<p>Set whether should cache statements or not</p>
    2781. 

  2781. 			</div>
    2782. 

  2782. 			
    2783. 

  2783. 

  2784. 			
    2785. 

  2785. 

  2786. 			
    2787. 

  2787. 

  2788. 			
    2789. 

  2789. 			<div class="method-subsection declared-in-section">
    2790. 

  2790. 				<h4 class="method-subtitle">Declared In</h4>
    2791. 

  2791. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    2792. 

  2792. 			</div>
    2793. 

  2793. 			
    2794. 

  2794. 			
    2795. 

  2795. 		</div>
    2796. 

  2796. 	</div>
    2797. 

  2797. </div>
    2798. 

  2798. 						</div>
    2799. 

  2799. 						
    2800. 

  2800. 

  2801. 						<a title="Encryption methods" name="task_Encryption methods"></a>
    2802. 

  2802. 						<h2 class="task-title">Encryption methods</h2>
    2803. 

  2803. 

  2804. 						<div class="task-list">
    2805. 

  2805. 							<div class="section-method">
    2806. 

  2806. 	<a name="//api/name/setKey:" title="setKey:"></a>
    2807. 

  2807. 	<h3 class="method-title"><code><a href="#//api/name/setKey:">&ndash;&nbsp;setKey:</a></code>
    2808. 

  2808. </h3>
    2809. 

  2809. 

  2810. 	<div class="method-info">
    2811. 

  2811. 		<div class="pointy-thing"></div>
    2812. 

  2812. 

  2813. 		<div class="method-info-container">
    2814. 

  2814. 			
    2815. 

  2815. 			
    2816. 

  2816. 			<div class="method-subsection brief-description">
    2817. 

  2817. 				<p>Set encryption key.</p>
    2818. 

  2818. 			</div>
    2819. 

  2819. 			
    2820. 

  2820. 		    
    2821. 

  2821. 

  2822. 			<div class="method-subsection method-declaration"><code>- (BOOL)setKey:(NSString *)<em>key</em></code></div>
    2823. 

  2823. 

  2824. 		    
    2825. 

  2825. 			
    2826. 

  2826. 			<div class="method-subsection arguments-section parameters">
    2827. 

  2827. 				<h4 class="method-subtitle parameter-title">Parameters</h4>
    2828. 

  2828. 				<table class="argument-def parameter-def">
    2829. 

  2829. 				
    2830. 

  2830. 					<tr>
    2831. 

  2831. 						<th scope="row" class="argument-name"><code>key</code></th>
    2832. 

  2832. 						<td><p>The key to be used.</p></td>
    2833. 

  2833. 					</tr>
    2834. 

  2834. 				
    2835. 

  2835. 				</table>
    2836. 

  2836. 			</div>
    2837. 

  2837. 			
    2838. 

  2838. 

  2839. 			
    2840. 

  2840. 			<div class="method-subsection return">
    2841. 

  2841. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    2842. 

  2842. 				<p><code>YES</code> if success, <code>NO</code> on error.</p>
    2843. 

  2843. 			</div>
    2844. 

  2844. 			
    2845. 

  2845. 

  2846. 			
    2847. 

  2847. 

  2848. 			
    2849. 

  2849. 			<div class="method-subsection discussion-section">
    2850. 

  2850. 				<h4 class="method-subtitle">Discussion</h4>
    2851. 

  2851. 				<p>Set encryption key.</p><div class="warning"><p><strong>Warning:</strong> You need to have purchased the sqlite encryption extensions for this method to work.</p></div>
    2852. 

  2852. 			</div>
    2853. 

  2853. 			
    2854. 

  2854. 

  2855. 			
    2856. 

  2856. 

  2857. 			
    2858. 

  2858. 			<div class="method-subsection see-also-section">
    2859. 

  2859. 				<h4 class="method-subtitle">See Also</h4>
    2860. 

  2860. 				<ul>
    2861. 

  2861. 					
    2862. 

  2862. 					<li><code><p><a href="http://www.sqlite-encrypt.com/develop-guide.htm">http://www.sqlite-encrypt.com/develop-guide.htm</a></p></code></li>
    2863. 

  2863. 					
    2864. 

  2864. 				</ul>
    2865. 

  2865. 			</div>
    2866. 

  2866. 			
    2867. 

  2867. 

  2868. 			
    2869. 

  2869. 			<div class="method-subsection declared-in-section">
    2870. 

  2870. 				<h4 class="method-subtitle">Declared In</h4>
    2871. 

  2871. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    2872. 

  2872. 			</div>
    2873. 

  2873. 			
    2874. 

  2874. 			
    2875. 

  2875. 		</div>
    2876. 

  2876. 	</div>
    2877. 

  2877. </div><div class="section-method">
    2878. 

  2878. 	<a name="//api/name/rekey:" title="rekey:"></a>
    2879. 

  2879. 	<h3 class="method-title"><code><a href="#//api/name/rekey:">&ndash;&nbsp;rekey:</a></code>
    2880. 

  2880. </h3>
    2881. 

  2881. 

  2882. 	<div class="method-info">
    2883. 

  2883. 		<div class="pointy-thing"></div>
    2884. 

  2884. 

  2885. 		<div class="method-info-container">
    2886. 

  2886. 			
    2887. 

  2887. 			
    2888. 

  2888. 			<div class="method-subsection brief-description">
    2889. 

  2889. 				<p>Reset encryption key</p>
    2890. 

  2890. 			</div>
    2891. 

  2891. 			
    2892. 

  2892. 		    
    2893. 

  2893. 

  2894. 			<div class="method-subsection method-declaration"><code>- (BOOL)rekey:(NSString *)<em>key</em></code></div>
    2895. 

  2895. 

  2896. 		    
    2897. 

  2897. 			
    2898. 

  2898. 			<div class="method-subsection arguments-section parameters">
    2899. 

  2899. 				<h4 class="method-subtitle parameter-title">Parameters</h4>
    2900. 

  2900. 				<table class="argument-def parameter-def">
    2901. 

  2901. 				
    2902. 

  2902. 					<tr>
    2903. 

  2903. 						<th scope="row" class="argument-name"><code>key</code></th>
    2904. 

  2904. 						<td><p>The key to be used.</p></td>
    2905. 

  2905. 					</tr>
    2906. 

  2906. 				
    2907. 

  2907. 				</table>
    2908. 

  2908. 			</div>
    2909. 

  2909. 			
    2910. 

  2910. 

  2911. 			
    2912. 

  2912. 			<div class="method-subsection return">
    2913. 

  2913. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    2914. 

  2914. 				<p><code>YES</code> if success, <code>NO</code> on error.</p>
    2915. 

  2915. 			</div>
    2916. 

  2916. 			
    2917. 

  2917. 

  2918. 			
    2919. 

  2919. 

  2920. 			
    2921. 

  2921. 			<div class="method-subsection discussion-section">
    2922. 

  2922. 				<h4 class="method-subtitle">Discussion</h4>
    2923. 

  2923. 				<p>Reset encryption key</p><div class="warning"><p><strong>Warning:</strong> You need to have purchased the sqlite encryption extensions for this method to work.</p></div>
    2924. 

  2924. 			</div>
    2925. 

  2925. 			
    2926. 

  2926. 

  2927. 			
    2928. 

  2928. 

  2929. 			
    2930. 

  2930. 			<div class="method-subsection see-also-section">
    2931. 

  2931. 				<h4 class="method-subtitle">See Also</h4>
    2932. 

  2932. 				<ul>
    2933. 

  2933. 					
    2934. 

  2934. 					<li><code><p><a href="http://www.sqlite-encrypt.com/develop-guide.htm">http://www.sqlite-encrypt.com/develop-guide.htm</a></p></code></li>
    2935. 

  2935. 					
    2936. 

  2936. 				</ul>
    2937. 

  2937. 			</div>
    2938. 

  2938. 			
    2939. 

  2939. 

  2940. 			
    2941. 

  2941. 			<div class="method-subsection declared-in-section">
    2942. 

  2942. 				<h4 class="method-subtitle">Declared In</h4>
    2943. 

  2943. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    2944. 

  2944. 			</div>
    2945. 

  2945. 			
    2946. 

  2946. 			
    2947. 

  2947. 		</div>
    2948. 

  2948. 	</div>
    2949. 

  2949. </div><div class="section-method">
    2950. 

  2950. 	<a name="//api/name/setKeyWithData:" title="setKeyWithData:"></a>
    2951. 

  2951. 	<h3 class="method-title"><code><a href="#//api/name/setKeyWithData:">&ndash;&nbsp;setKeyWithData:</a></code>
    2952. 

  2952. </h3>
    2953. 

  2953. 

  2954. 	<div class="method-info">
    2955. 

  2955. 		<div class="pointy-thing"></div>
    2956. 

  2956. 

  2957. 		<div class="method-info-container">
    2958. 

  2958. 			
    2959. 

  2959. 			
    2960. 

  2960. 			<div class="method-subsection brief-description">
    2961. 

  2961. 				<p>Set encryption key using <code>keyData</code>.</p>
    2962. 

  2962. 			</div>
    2963. 

  2963. 			
    2964. 

  2964. 		    
    2965. 

  2965. 

  2966. 			<div class="method-subsection method-declaration"><code>- (BOOL)setKeyWithData:(NSData *)<em>keyData</em></code></div>
    2967. 

  2967. 

  2968. 		    
    2969. 

  2969. 			
    2970. 

  2970. 			<div class="method-subsection arguments-section parameters">
    2971. 

  2971. 				<h4 class="method-subtitle parameter-title">Parameters</h4>
    2972. 

  2972. 				<table class="argument-def parameter-def">
    2973. 

  2973. 				
    2974. 

  2974. 					<tr>
    2975. 

  2975. 						<th scope="row" class="argument-name"><code>keyData</code></th>
    2976. 

  2976. 						<td><p>The <code>NSData</code> to be used.</p></td>
    2977. 

  2977. 					</tr>
    2978. 

  2978. 				
    2979. 

  2979. 				</table>
    2980. 

  2980. 			</div>
    2981. 

  2981. 			
    2982. 

  2982. 

  2983. 			
    2984. 

  2984. 			<div class="method-subsection return">
    2985. 

  2985. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    2986. 

  2986. 				<p><code>YES</code> if success, <code>NO</code> on error.</p>
    2987. 

  2987. 			</div>
    2988. 

  2988. 			
    2989. 

  2989. 

  2990. 			
    2991. 

  2991. 

  2992. 			
    2993. 

  2993. 			<div class="method-subsection discussion-section">
    2994. 

  2994. 				<h4 class="method-subtitle">Discussion</h4>
    2995. 

  2995. 				<p>Set encryption key using <code>keyData</code>.</p><div class="warning"><p><strong>Warning:</strong> You need to have purchased the sqlite encryption extensions for this method to work.</p></div>
    2996. 

  2996. 			</div>
    2997. 

  2997. 			
    2998. 

  2998. 

  2999. 			
    3000. 

  3000. 

  3001. 			
    3002. 

  3002. 			<div class="method-subsection see-also-section">
    3003. 

  3003. 				<h4 class="method-subtitle">See Also</h4>
    3004. 

  3004. 				<ul>
    3005. 

  3005. 					
    3006. 

  3006. 					<li><code><p><a href="http://www.sqlite-encrypt.com/develop-guide.htm">http://www.sqlite-encrypt.com/develop-guide.htm</a></p></code></li>
    3007. 

  3007. 					
    3008. 

  3008. 				</ul>
    3009. 

  3009. 			</div>
    3010. 

  3010. 			
    3011. 

  3011. 

  3012. 			
    3013. 

  3013. 			<div class="method-subsection declared-in-section">
    3014. 

  3014. 				<h4 class="method-subtitle">Declared In</h4>
    3015. 

  3015. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    3016. 

  3016. 			</div>
    3017. 

  3017. 			
    3018. 

  3018. 			
    3019. 

  3019. 		</div>
    3020. 

  3020. 	</div>
    3021. 

  3021. </div><div class="section-method">
    3022. 

  3022. 	<a name="//api/name/rekeyWithData:" title="rekeyWithData:"></a>
    3023. 

  3023. 	<h3 class="method-title"><code><a href="#//api/name/rekeyWithData:">&ndash;&nbsp;rekeyWithData:</a></code>
    3024. 

  3024. </h3>
    3025. 

  3025. 

  3026. 	<div class="method-info">
    3027. 

  3027. 		<div class="pointy-thing"></div>
    3028. 

  3028. 

  3029. 		<div class="method-info-container">
    3030. 

  3030. 			
    3031. 

  3031. 			
    3032. 

  3032. 			<div class="method-subsection brief-description">
    3033. 

  3033. 				<p>Reset encryption key using <code>keyData</code>.</p>
    3034. 

  3034. 			</div>
    3035. 

  3035. 			
    3036. 

  3036. 		    
    3037. 

  3037. 

  3038. 			<div class="method-subsection method-declaration"><code>- (BOOL)rekeyWithData:(NSData *)<em>keyData</em></code></div>
    3039. 

  3039. 

  3040. 		    
    3041. 

  3041. 			
    3042. 

  3042. 			<div class="method-subsection arguments-section parameters">
    3043. 

  3043. 				<h4 class="method-subtitle parameter-title">Parameters</h4>
    3044. 

  3044. 				<table class="argument-def parameter-def">
    3045. 

  3045. 				
    3046. 

  3046. 					<tr>
    3047. 

  3047. 						<th scope="row" class="argument-name"><code>keyData</code></th>
    3048. 

  3048. 						<td><p>The <code>NSData</code> to be used.</p></td>
    3049. 

  3049. 					</tr>
    3050. 

  3050. 				
    3051. 

  3051. 				</table>
    3052. 

  3052. 			</div>
    3053. 

  3053. 			
    3054. 

  3054. 

  3055. 			
    3056. 

  3056. 			<div class="method-subsection return">
    3057. 

  3057. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    3058. 

  3058. 				<p><code>YES</code> if success, <code>NO</code> on error.</p>
    3059. 

  3059. 			</div>
    3060. 

  3060. 			
    3061. 

  3061. 

  3062. 			
    3063. 

  3063. 

  3064. 			
    3065. 

  3065. 			<div class="method-subsection discussion-section">
    3066. 

  3066. 				<h4 class="method-subtitle">Discussion</h4>
    3067. 

  3067. 				<p>Reset encryption key using <code>keyData</code>.</p><div class="warning"><p><strong>Warning:</strong> You need to have purchased the sqlite encryption extensions for this method to work.</p></div>
    3068. 

  3068. 			</div>
    3069. 

  3069. 			
    3070. 

  3070. 

  3071. 			
    3072. 

  3072. 

  3073. 			
    3074. 

  3074. 			<div class="method-subsection see-also-section">
    3075. 

  3075. 				<h4 class="method-subtitle">See Also</h4>
    3076. 

  3076. 				<ul>
    3077. 

  3077. 					
    3078. 

  3078. 					<li><code><p><a href="http://www.sqlite-encrypt.com/develop-guide.htm">http://www.sqlite-encrypt.com/develop-guide.htm</a></p></code></li>
    3079. 

  3079. 					
    3080. 

  3080. 				</ul>
    3081. 

  3081. 			</div>
    3082. 

  3082. 			
    3083. 

  3083. 

  3084. 			
    3085. 

  3085. 			<div class="method-subsection declared-in-section">
    3086. 

  3086. 				<h4 class="method-subtitle">Declared In</h4>
    3087. 

  3087. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    3088. 

  3088. 			</div>
    3089. 

  3089. 			
    3090. 

  3090. 			
    3091. 

  3091. 		</div>
    3092. 

  3092. 	</div>
    3093. 

  3093. </div>
    3094. 

  3094. 						</div>
    3095. 

  3095. 						
    3096. 

  3096. 

  3097. 						<a title="General inquiry methods" name="task_General inquiry methods"></a>
    3098. 

  3098. 						<h2 class="task-title">General inquiry methods</h2>
    3099. 

  3099. 

  3100. 						<div class="task-list">
    3101. 

  3101. 							<div class="section-method">
    3102. 

  3102. 	<a name="//api/name/databasePath" title="databasePath"></a>
    3103. 

  3103. 	<h3 class="method-title"><code><a href="#//api/name/databasePath">&ndash;&nbsp;databasePath</a></code>
    3104. 

  3104. </h3>
    3105. 

  3105. 

  3106. 	<div class="method-info">
    3107. 

  3107. 		<div class="pointy-thing"></div>
    3108. 

  3108. 

  3109. 		<div class="method-info-container">
    3110. 

  3110. 			
    3111. 

  3111. 			
    3112. 

  3112. 			<div class="method-subsection brief-description">
    3113. 

  3113. 				<p>The path of the database file</p>
    3114. 

  3114. 			</div>
    3115. 

  3115. 			
    3116. 

  3116. 		    
    3117. 

  3117. 

  3118. 			<div class="method-subsection method-declaration"><code>- (NSString *)databasePath</code></div>
    3119. 

  3119. 

  3120. 		    
    3121. 

  3121. 			
    3122. 

  3122. 

  3123. 			
    3124. 

  3124. 			<div class="method-subsection return">
    3125. 

  3125. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    3126. 

  3126. 				<p>path of database.</p>
    3127. 

  3127. 			</div>
    3128. 

  3128. 			
    3129. 

  3129. 

  3130. 			
    3131. 

  3131. 

  3132. 			
    3133. 

  3133. 			<div class="method-subsection discussion-section">
    3134. 

  3134. 				<h4 class="method-subtitle">Discussion</h4>
    3135. 

  3135. 				<p>The path of the database file</p>
    3136. 

  3136. 			</div>
    3137. 

  3137. 			
    3138. 

  3138. 

  3139. 			
    3140. 

  3140. 

  3141. 			
    3142. 

  3142. 

  3143. 			
    3144. 

  3144. 			<div class="method-subsection declared-in-section">
    3145. 

  3145. 				<h4 class="method-subtitle">Declared In</h4>
    3146. 

  3146. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    3147. 

  3147. 			</div>
    3148. 

  3148. 			
    3149. 

  3149. 			
    3150. 

  3150. 		</div>
    3151. 

  3151. 	</div>
    3152. 

  3152. </div><div class="section-method">
    3153. 

  3153. 	<a name="//api/name/sqliteHandle" title="sqliteHandle"></a>
    3154. 

  3154. 	<h3 class="method-title"><code><a href="#//api/name/sqliteHandle">&ndash;&nbsp;sqliteHandle</a></code>
    3155. 

  3155. </h3>
    3156. 

  3156. 

  3157. 	<div class="method-info">
    3158. 

  3158. 		<div class="pointy-thing"></div>
    3159. 

  3159. 

  3160. 		<div class="method-info-container">
    3161. 

  3161. 			
    3162. 

  3162. 			
    3163. 

  3163. 			<div class="method-subsection brief-description">
    3164. 

  3164. 				<p>The underlying SQLite handle</p>
    3165. 

  3165. 			</div>
    3166. 

  3166. 			
    3167. 

  3167. 		    
    3168. 

  3168. 

  3169. 			<div class="method-subsection method-declaration"><code>- (sqlite3 *)sqliteHandle</code></div>
    3170. 

  3170. 

  3171. 		    
    3172. 

  3172. 			
    3173. 

  3173. 

  3174. 			
    3175. 

  3175. 			<div class="method-subsection return">
    3176. 

  3176. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    3177. 

  3177. 				<p>The <code>sqlite3</code> pointer.</p>
    3178. 

  3178. 			</div>
    3179. 

  3179. 			
    3180. 

  3180. 

  3181. 			
    3182. 

  3182. 

  3183. 			
    3184. 

  3184. 			<div class="method-subsection discussion-section">
    3185. 

  3185. 				<h4 class="method-subtitle">Discussion</h4>
    3186. 

  3186. 				<p>The underlying SQLite handle</p>
    3187. 

  3187. 			</div>
    3188. 

  3188. 			
    3189. 

  3189. 

  3190. 			
    3191. 

  3191. 

  3192. 			
    3193. 

  3193. 

  3194. 			
    3195. 

  3195. 			<div class="method-subsection declared-in-section">
    3196. 

  3196. 				<h4 class="method-subtitle">Declared In</h4>
    3197. 

  3197. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    3198. 

  3198. 			</div>
    3199. 

  3199. 			
    3200. 

  3200. 			
    3201. 

  3201. 		</div>
    3202. 

  3202. 	</div>
    3203. 

  3203. </div>
    3204. 

  3204. 						</div>
    3205. 

  3205. 						
    3206. 

  3206. 

  3207. 						<a title="Retrieving error codes" name="task_Retrieving error codes"></a>
    3208. 

  3208. 						<h2 class="task-title">Retrieving error codes</h2>
    3209. 

  3209. 

  3210. 						<div class="task-list">
    3211. 

  3211. 							<div class="section-method">
    3212. 

  3212. 	<a name="//api/name/lastErrorMessage" title="lastErrorMessage"></a>
    3213. 

  3213. 	<h3 class="method-title"><code><a href="#//api/name/lastErrorMessage">&ndash;&nbsp;lastErrorMessage</a></code>
    3214. 

  3214. </h3>
    3215. 

  3215. 

  3216. 	<div class="method-info">
    3217. 

  3217. 		<div class="pointy-thing"></div>
    3218. 

  3218. 

  3219. 		<div class="method-info-container">
    3220. 

  3220. 			
    3221. 

  3221. 			
    3222. 

  3222. 			<div class="method-subsection brief-description">
    3223. 

  3223. 				<p>Last error message</p>
    3224. 

  3224. 			</div>
    3225. 

  3225. 			
    3226. 

  3226. 		    
    3227. 

  3227. 

  3228. 			<div class="method-subsection method-declaration"><code>- (NSString *)lastErrorMessage</code></div>
    3229. 

  3229. 

  3230. 		    
    3231. 

  3231. 			
    3232. 

  3232. 

  3233. 			
    3234. 

  3234. 			<div class="method-subsection return">
    3235. 

  3235. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    3236. 

  3236. 				<p><code>NSString</code> of the last error message.</p>
    3237. 

  3237. 			</div>
    3238. 

  3238. 			
    3239. 

  3239. 

  3240. 			
    3241. 

  3241. 

  3242. 			
    3243. 

  3243. 			<div class="method-subsection discussion-section">
    3244. 

  3244. 				<h4 class="method-subtitle">Discussion</h4>
    3245. 

  3245. 				<p>Last error message</p>
    3246. 

  3246. 

  3247. <p>Returns the English-language text that describes the most recent failed SQLite API call associated with a database connection. If a prior API call failed but the most recent API call succeeded, this return value is undefined.</p>
    3248. 

  3248. 			</div>
    3249. 

  3249. 			
    3250. 

  3250. 

  3251. 			
    3252. 

  3252. 

  3253. 			
    3254. 

  3254. 			<div class="method-subsection see-also-section">
    3255. 

  3255. 				<h4 class="method-subtitle">See Also</h4>
    3256. 

  3256. 				<ul>
    3257. 

  3257. 					
    3258. 

  3258. 					<li><code><p><a href="http://sqlite.org/c3ref/errcode.html">sqlite3_errmsg()</a></p></code></li>
    3259. 

  3259. 					
    3260. 

  3260. 					<li><code><p><a href="#//api/name/lastErrorCode">- lastErrorCode</a></p></code></li>
    3261. 

  3261. 					
    3262. 

  3262. 					<li><code><p><a href="#//api/name/lastError">- lastError</a></p></code></li>
    3263. 

  3263. 					
    3264. 

  3264. 				</ul>
    3265. 

  3265. 			</div>
    3266. 

  3266. 			
    3267. 

  3267. 

  3268. 			
    3269. 

  3269. 			<div class="method-subsection declared-in-section">
    3270. 

  3270. 				<h4 class="method-subtitle">Declared In</h4>
    3271. 

  3271. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    3272. 

  3272. 			</div>
    3273. 

  3273. 			
    3274. 

  3274. 			
    3275. 

  3275. 		</div>
    3276. 

  3276. 	</div>
    3277. 

  3277. </div><div class="section-method">
    3278. 

  3278. 	<a name="//api/name/lastErrorCode" title="lastErrorCode"></a>
    3279. 

  3279. 	<h3 class="method-title"><code><a href="#//api/name/lastErrorCode">&ndash;&nbsp;lastErrorCode</a></code>
    3280. 

  3280. </h3>
    3281. 

  3281. 

  3282. 	<div class="method-info">
    3283. 

  3283. 		<div class="pointy-thing"></div>
    3284. 

  3284. 

  3285. 		<div class="method-info-container">
    3286. 

  3286. 			
    3287. 

  3287. 			
    3288. 

  3288. 			<div class="method-subsection brief-description">
    3289. 

  3289. 				<p>Last error code</p>
    3290. 

  3290. 			</div>
    3291. 

  3291. 			
    3292. 

  3292. 		    
    3293. 

  3293. 

  3294. 			<div class="method-subsection method-declaration"><code>- (int)lastErrorCode</code></div>
    3295. 

  3295. 

  3296. 		    
    3297. 

  3297. 			
    3298. 

  3298. 

  3299. 			
    3300. 

  3300. 			<div class="method-subsection return">
    3301. 

  3301. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    3302. 

  3302. 				<p>Integer value of the last error code.</p>
    3303. 

  3303. 			</div>
    3304. 

  3304. 			
    3305. 

  3305. 

  3306. 			
    3307. 

  3307. 

  3308. 			
    3309. 

  3309. 			<div class="method-subsection discussion-section">
    3310. 

  3310. 				<h4 class="method-subtitle">Discussion</h4>
    3311. 

  3311. 				<p>Last error code</p>
    3312. 

  3312. 

  3313. <p>Returns the numeric result code or extended result code for the most recent failed SQLite API call associated with a database connection. If a prior API call failed but the most recent API call succeeded, this return value is undefined.</p>
    3314. 

  3314. 			</div>
    3315. 

  3315. 			
    3316. 

  3316. 

  3317. 			
    3318. 

  3318. 

  3319. 			
    3320. 

  3320. 			<div class="method-subsection see-also-section">
    3321. 

  3321. 				<h4 class="method-subtitle">See Also</h4>
    3322. 

  3322. 				<ul>
    3323. 

  3323. 					
    3324. 

  3324. 					<li><code><p><a href="http://sqlite.org/c3ref/errcode.html">sqlite3_errcode()</a></p></code></li>
    3325. 

  3325. 					
    3326. 

  3326. 					<li><code><p><a href="#//api/name/lastErrorMessage">- lastErrorMessage</a></p></code></li>
    3327. 

  3327. 					
    3328. 

  3328. 					<li><code><p><a href="#//api/name/lastError">- lastError</a></p></code></li>
    3329. 

  3329. 					
    3330. 

  3330. 				</ul>
    3331. 

  3331. 			</div>
    3332. 

  3332. 			
    3333. 

  3333. 

  3334. 			
    3335. 

  3335. 			<div class="method-subsection declared-in-section">
    3336. 

  3336. 				<h4 class="method-subtitle">Declared In</h4>
    3337. 

  3337. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    3338. 

  3338. 			</div>
    3339. 

  3339. 			
    3340. 

  3340. 			
    3341. 

  3341. 		</div>
    3342. 

  3342. 	</div>
    3343. 

  3343. </div><div class="section-method">
    3344. 

  3344. 	<a name="//api/name/hadError" title="hadError"></a>
    3345. 

  3345. 	<h3 class="method-title"><code><a href="#//api/name/hadError">&ndash;&nbsp;hadError</a></code>
    3346. 

  3346. </h3>
    3347. 

  3347. 

  3348. 	<div class="method-info">
    3349. 

  3349. 		<div class="pointy-thing"></div>
    3350. 

  3350. 

  3351. 		<div class="method-info-container">
    3352. 

  3352. 			
    3353. 

  3353. 			
    3354. 

  3354. 			<div class="method-subsection brief-description">
    3355. 

  3355. 				<p>Had error</p>
    3356. 

  3356. 			</div>
    3357. 

  3357. 			
    3358. 

  3358. 		    
    3359. 

  3359. 

  3360. 			<div class="method-subsection method-declaration"><code>- (BOOL)hadError</code></div>
    3361. 

  3361. 

  3362. 		    
    3363. 

  3363. 			
    3364. 

  3364. 

  3365. 			
    3366. 

  3366. 			<div class="method-subsection return">
    3367. 

  3367. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    3368. 

  3368. 				<p><code>YES</code> if there was an error, <code>NO</code> if no error.</p>
    3369. 

  3369. 			</div>
    3370. 

  3370. 			
    3371. 

  3371. 

  3372. 			
    3373. 

  3373. 

  3374. 			
    3375. 

  3375. 			<div class="method-subsection discussion-section">
    3376. 

  3376. 				<h4 class="method-subtitle">Discussion</h4>
    3377. 

  3377. 				<p>Had error</p>
    3378. 

  3378. 			</div>
    3379. 

  3379. 			
    3380. 

  3380. 

  3381. 			
    3382. 

  3382. 

  3383. 			
    3384. 

  3384. 			<div class="method-subsection see-also-section">
    3385. 

  3385. 				<h4 class="method-subtitle">See Also</h4>
    3386. 

  3386. 				<ul>
    3387. 

  3387. 					
    3388. 

  3388. 					<li><code><p><a href="#//api/name/lastError">- lastError</a></p></code></li>
    3389. 

  3389. 					
    3390. 

  3390. 					<li><code><p><a href="#//api/name/lastErrorCode">- lastErrorCode</a></p></code></li>
    3391. 

  3391. 					
    3392. 

  3392. 					<li><code><p><a href="#//api/name/lastErrorMessage">- lastErrorMessage</a></p></code></li>
    3393. 

  3393. 					
    3394. 

  3394. 				</ul>
    3395. 

  3395. 			</div>
    3396. 

  3396. 			
    3397. 

  3397. 

  3398. 			
    3399. 

  3399. 			<div class="method-subsection declared-in-section">
    3400. 

  3400. 				<h4 class="method-subtitle">Declared In</h4>
    3401. 

  3401. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    3402. 

  3402. 			</div>
    3403. 

  3403. 			
    3404. 

  3404. 			
    3405. 

  3405. 		</div>
    3406. 

  3406. 	</div>
    3407. 

  3407. </div><div class="section-method">
    3408. 

  3408. 	<a name="//api/name/lastError" title="lastError"></a>
    3409. 

  3409. 	<h3 class="method-title"><code><a href="#//api/name/lastError">&ndash;&nbsp;lastError</a></code>
    3410. 

  3410. </h3>
    3411. 

  3411. 

  3412. 	<div class="method-info">
    3413. 

  3413. 		<div class="pointy-thing"></div>
    3414. 

  3414. 

  3415. 		<div class="method-info-container">
    3416. 

  3416. 			
    3417. 

  3417. 			
    3418. 

  3418. 			<div class="method-subsection brief-description">
    3419. 

  3419. 				<p>Last error</p>
    3420. 

  3420. 			</div>
    3421. 

  3421. 			
    3422. 

  3422. 		    
    3423. 

  3423. 

  3424. 			<div class="method-subsection method-declaration"><code>- (NSError *)lastError</code></div>
    3425. 

  3425. 

  3426. 		    
    3427. 

  3427. 			
    3428. 

  3428. 

  3429. 			
    3430. 

  3430. 			<div class="method-subsection return">
    3431. 

  3431. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    3432. 

  3432. 				<p><code>NSError</code> representing the last error.</p>
    3433. 

  3433. 			</div>
    3434. 

  3434. 			
    3435. 

  3435. 

  3436. 			
    3437. 

  3437. 

  3438. 			
    3439. 

  3439. 			<div class="method-subsection discussion-section">
    3440. 

  3440. 				<h4 class="method-subtitle">Discussion</h4>
    3441. 

  3441. 				<p>Last error</p>
    3442. 

  3442. 			</div>
    3443. 

  3443. 			
    3444. 

  3444. 

  3445. 			
    3446. 

  3446. 

  3447. 			
    3448. 

  3448. 			<div class="method-subsection see-also-section">
    3449. 

  3449. 				<h4 class="method-subtitle">See Also</h4>
    3450. 

  3450. 				<ul>
    3451. 

  3451. 					
    3452. 

  3452. 					<li><code><p><a href="#//api/name/lastErrorCode">- lastErrorCode</a></p></code></li>
    3453. 

  3453. 					
    3454. 

  3454. 					<li><code><p><a href="#//api/name/lastErrorMessage">- lastErrorMessage</a></p></code></li>
    3455. 

  3455. 					
    3456. 

  3456. 				</ul>
    3457. 

  3457. 			</div>
    3458. 

  3458. 			
    3459. 

  3459. 

  3460. 			
    3461. 

  3461. 			<div class="method-subsection declared-in-section">
    3462. 

  3462. 				<h4 class="method-subtitle">Declared In</h4>
    3463. 

  3463. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    3464. 

  3464. 			</div>
    3465. 

  3465. 			
    3466. 

  3466. 			
    3467. 

  3467. 		</div>
    3468. 

  3468. 	</div>
    3469. 

  3469. </div>
    3470. 

  3470. 						</div>
    3471. 

  3471. 						
    3472. 

  3472. 

  3473. 						<a title="Save points" name="task_Save points"></a>
    3474. 

  3474. 						<h2 class="task-title">Save points</h2>
    3475. 

  3475. 

  3476. 						<div class="task-list">
    3477. 

  3477. 							<div class="section-method">
    3478. 

  3478. 	<a name="//api/name/startSavePointWithName:error:" title="startSavePointWithName:error:"></a>
    3479. 

  3479. 	<h3 class="method-title"><code><a href="#//api/name/startSavePointWithName:error:">&ndash;&nbsp;startSavePointWithName:error:</a></code>
    3480. 

  3480. </h3>
    3481. 

  3481. 

  3482. 	<div class="method-info">
    3483. 

  3483. 		<div class="pointy-thing"></div>
    3484. 

  3484. 

  3485. 		<div class="method-info-container">
    3486. 

  3486. 			
    3487. 

  3487. 			
    3488. 

  3488. 			<div class="method-subsection brief-description">
    3489. 

  3489. 				<p>Start save point</p>
    3490. 

  3490. 			</div>
    3491. 

  3491. 			
    3492. 

  3492. 		    
    3493. 

  3493. 

  3494. 			<div class="method-subsection method-declaration"><code>- (BOOL)startSavePointWithName:(NSString *)<em>name</em> error:(NSError **)<em>outErr</em></code></div>
    3495. 

  3495. 

  3496. 		    
    3497. 

  3497. 			
    3498. 

  3498. 			<div class="method-subsection arguments-section parameters">
    3499. 

  3499. 				<h4 class="method-subtitle parameter-title">Parameters</h4>
    3500. 

  3500. 				<table class="argument-def parameter-def">
    3501. 

  3501. 				
    3502. 

  3502. 					<tr>
    3503. 

  3503. 						<th scope="row" class="argument-name"><code>name</code></th>
    3504. 

  3504. 						<td><p>Name of save point.</p></td>
    3505. 

  3505. 					</tr>
    3506. 

  3506. 				
    3507. 

  3507. 					<tr>
    3508. 

  3508. 						<th scope="row" class="argument-name"><code>outErr</code></th>
    3509. 

  3509. 						<td><p>A <code>NSError</code> object to receive any error object (if any).</p></td>
    3510. 

  3510. 					</tr>
    3511. 

  3511. 				
    3512. 

  3512. 				</table>
    3513. 

  3513. 			</div>
    3514. 

  3514. 			
    3515. 

  3515. 

  3516. 			
    3517. 

  3517. 			<div class="method-subsection return">
    3518. 

  3518. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    3519. 

  3519. 				<p><code>YES</code> on success; <code>NO</code> on failure. If failed, you can call <a href="#//api/name/lastError"><code>lastError</code></a>, <a href="#//api/name/lastErrorCode"><code>lastErrorCode</code></a>, or <a href="#//api/name/lastErrorMessage"><code>lastErrorMessage</code></a> for diagnostic information regarding the failure.</p>
    3520. 

  3520. 			</div>
    3521. 

  3521. 			
    3522. 

  3522. 

  3523. 			
    3524. 

  3524. 

  3525. 			
    3526. 

  3526. 			<div class="method-subsection discussion-section">
    3527. 

  3527. 				<h4 class="method-subtitle">Discussion</h4>
    3528. 

  3528. 				<p>Start save point</p>
    3529. 

  3529. 			</div>
    3530. 

  3530. 			
    3531. 

  3531. 

  3532. 			
    3533. 

  3533. 

  3534. 			
    3535. 

  3535. 			<div class="method-subsection see-also-section">
    3536. 

  3536. 				<h4 class="method-subtitle">See Also</h4>
    3537. 

  3537. 				<ul>
    3538. 

  3538. 					
    3539. 

  3539. 					<li><code><p><a href="#//api/name/releaseSavePointWithName:error:">- releaseSavePointWithName:error:</a></p></code></li>
    3540. 

  3540. 					
    3541. 

  3541. 					<li><code><p><a href="#//api/name/rollbackToSavePointWithName:error:">- rollbackToSavePointWithName:error:</a></p></code></li>
    3542. 

  3542. 					
    3543. 

  3543. 				</ul>
    3544. 

  3544. 			</div>
    3545. 

  3545. 			
    3546. 

  3546. 

  3547. 			
    3548. 

  3548. 			<div class="method-subsection declared-in-section">
    3549. 

  3549. 				<h4 class="method-subtitle">Declared In</h4>
    3550. 

  3550. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    3551. 

  3551. 			</div>
    3552. 

  3552. 			
    3553. 

  3553. 			
    3554. 

  3554. 		</div>
    3555. 

  3555. 	</div>
    3556. 

  3556. </div><div class="section-method">
    3557. 

  3557. 	<a name="//api/name/releaseSavePointWithName:error:" title="releaseSavePointWithName:error:"></a>
    3558. 

  3558. 	<h3 class="method-title"><code><a href="#//api/name/releaseSavePointWithName:error:">&ndash;&nbsp;releaseSavePointWithName:error:</a></code>
    3559. 

  3559. </h3>
    3560. 

  3560. 

  3561. 	<div class="method-info">
    3562. 

  3562. 		<div class="pointy-thing"></div>
    3563. 

  3563. 

  3564. 		<div class="method-info-container">
    3565. 

  3565. 			
    3566. 

  3566. 			
    3567. 

  3567. 			<div class="method-subsection brief-description">
    3568. 

  3568. 				<p>Release save point</p>
    3569. 

  3569. 			</div>
    3570. 

  3570. 			
    3571. 

  3571. 		    
    3572. 

  3572. 

  3573. 			<div class="method-subsection method-declaration"><code>- (BOOL)releaseSavePointWithName:(NSString *)<em>name</em> error:(NSError **)<em>outErr</em></code></div>
    3574. 

  3574. 

  3575. 		    
    3576. 

  3576. 			
    3577. 

  3577. 			<div class="method-subsection arguments-section parameters">
    3578. 

  3578. 				<h4 class="method-subtitle parameter-title">Parameters</h4>
    3579. 

  3579. 				<table class="argument-def parameter-def">
    3580. 

  3580. 				
    3581. 

  3581. 					<tr>
    3582. 

  3582. 						<th scope="row" class="argument-name"><code>name</code></th>
    3583. 

  3583. 						<td><p>Name of save point.</p></td>
    3584. 

  3584. 					</tr>
    3585. 

  3585. 				
    3586. 

  3586. 					<tr>
    3587. 

  3587. 						<th scope="row" class="argument-name"><code>outErr</code></th>
    3588. 

  3588. 						<td><p>A <code>NSError</code> object to receive any error object (if any).</p></td>
    3589. 

  3589. 					</tr>
    3590. 

  3590. 				
    3591. 

  3591. 				</table>
    3592. 

  3592. 			</div>
    3593. 

  3593. 			
    3594. 

  3594. 

  3595. 			
    3596. 

  3596. 			<div class="method-subsection return">
    3597. 

  3597. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    3598. 

  3598. 				<p><code>YES</code> on success; <code>NO</code> on failure. If failed, you can call <a href="#//api/name/lastError"><code>lastError</code></a>, <a href="#//api/name/lastErrorCode"><code>lastErrorCode</code></a>, or <a href="#//api/name/lastErrorMessage"><code>lastErrorMessage</code></a> for diagnostic information regarding the failure.</p>
    3599. 

  3599. 			</div>
    3600. 

  3600. 			
    3601. 

  3601. 

  3602. 			
    3603. 

  3603. 

  3604. 			
    3605. 

  3605. 			<div class="method-subsection discussion-section">
    3606. 

  3606. 				<h4 class="method-subtitle">Discussion</h4>
    3607. 

  3607. 				<p>Release save point</p>
    3608. 

  3608. 			</div>
    3609. 

  3609. 			
    3610. 

  3610. 

  3611. 			
    3612. 

  3612. 

  3613. 			
    3614. 

  3614. 			<div class="method-subsection see-also-section">
    3615. 

  3615. 				<h4 class="method-subtitle">See Also</h4>
    3616. 

  3616. 				<ul>
    3617. 

  3617. 					
    3618. 

  3618. 					<li><code><p><a href="#//api/name/startSavePointWithName:error:">- startSavePointWithName:error:</a></p></code></li>
    3619. 

  3619. 					
    3620. 

  3620. 					<li><code><p><a href="#//api/name/rollbackToSavePointWithName:error:">- rollbackToSavePointWithName:error:</a></p></code></li>
    3621. 

  3621. 					
    3622. 

  3622. 				</ul>
    3623. 

  3623. 			</div>
    3624. 

  3624. 			
    3625. 

  3625. 

  3626. 			
    3627. 

  3627. 			<div class="method-subsection declared-in-section">
    3628. 

  3628. 				<h4 class="method-subtitle">Declared In</h4>
    3629. 

  3629. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    3630. 

  3630. 			</div>
    3631. 

  3631. 			
    3632. 

  3632. 			
    3633. 

  3633. 		</div>
    3634. 

  3634. 	</div>
    3635. 

  3635. </div><div class="section-method">
    3636. 

  3636. 	<a name="//api/name/rollbackToSavePointWithName:error:" title="rollbackToSavePointWithName:error:"></a>
    3637. 

  3637. 	<h3 class="method-title"><code><a href="#//api/name/rollbackToSavePointWithName:error:">&ndash;&nbsp;rollbackToSavePointWithName:error:</a></code>
    3638. 

  3638. </h3>
    3639. 

  3639. 

  3640. 	<div class="method-info">
    3641. 

  3641. 		<div class="pointy-thing"></div>
    3642. 

  3642. 

  3643. 		<div class="method-info-container">
    3644. 

  3644. 			
    3645. 

  3645. 			
    3646. 

  3646. 			<div class="method-subsection brief-description">
    3647. 

  3647. 				<p>Roll back to save point</p>
    3648. 

  3648. 			</div>
    3649. 

  3649. 			
    3650. 

  3650. 		    
    3651. 

  3651. 

  3652. 			<div class="method-subsection method-declaration"><code>- (BOOL)rollbackToSavePointWithName:(NSString *)<em>name</em> error:(NSError **)<em>outErr</em></code></div>
    3653. 

  3653. 

  3654. 		    
    3655. 

  3655. 			
    3656. 

  3656. 			<div class="method-subsection arguments-section parameters">
    3657. 

  3657. 				<h4 class="method-subtitle parameter-title">Parameters</h4>
    3658. 

  3658. 				<table class="argument-def parameter-def">
    3659. 

  3659. 				
    3660. 

  3660. 					<tr>
    3661. 

  3661. 						<th scope="row" class="argument-name"><code>name</code></th>
    3662. 

  3662. 						<td><p>Name of save point.</p></td>
    3663. 

  3663. 					</tr>
    3664. 

  3664. 				
    3665. 

  3665. 					<tr>
    3666. 

  3666. 						<th scope="row" class="argument-name"><code>outErr</code></th>
    3667. 

  3667. 						<td><p>A <code>NSError</code> object to receive any error object (if any).</p></td>
    3668. 

  3668. 					</tr>
    3669. 

  3669. 				
    3670. 

  3670. 				</table>
    3671. 

  3671. 			</div>
    3672. 

  3672. 			
    3673. 

  3673. 

  3674. 			
    3675. 

  3675. 			<div class="method-subsection return">
    3676. 

  3676. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    3677. 

  3677. 				<p><code>YES</code> on success; <code>NO</code> on failure. If failed, you can call <a href="#//api/name/lastError"><code>lastError</code></a>, <a href="#//api/name/lastErrorCode"><code>lastErrorCode</code></a>, or <a href="#//api/name/lastErrorMessage"><code>lastErrorMessage</code></a> for diagnostic information regarding the failure.</p>
    3678. 

  3678. 			</div>
    3679. 

  3679. 			
    3680. 

  3680. 

  3681. 			
    3682. 

  3682. 

  3683. 			
    3684. 

  3684. 			<div class="method-subsection discussion-section">
    3685. 

  3685. 				<h4 class="method-subtitle">Discussion</h4>
    3686. 

  3686. 				<p>Roll back to save point</p>
    3687. 

  3687. 			</div>
    3688. 

  3688. 			
    3689. 

  3689. 

  3690. 			
    3691. 

  3691. 

  3692. 			
    3693. 

  3693. 			<div class="method-subsection see-also-section">
    3694. 

  3694. 				<h4 class="method-subtitle">See Also</h4>
    3695. 

  3695. 				<ul>
    3696. 

  3696. 					
    3697. 

  3697. 					<li><code><p><a href="#//api/name/startSavePointWithName:error:">- startSavePointWithName:error:</a></p></code></li>
    3698. 

  3698. 					
    3699. 

  3699. 					<li><code><p><a href="#//api/name/releaseSavePointWithName:error:">- releaseSavePointWithName:error:</a></p></code></li>
    3700. 

  3700. 					
    3701. 

  3701. 				</ul>
    3702. 

  3702. 			</div>
    3703. 

  3703. 			
    3704. 

  3704. 

  3705. 			
    3706. 

  3706. 			<div class="method-subsection declared-in-section">
    3707. 

  3707. 				<h4 class="method-subtitle">Declared In</h4>
    3708. 

  3708. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    3709. 

  3709. 			</div>
    3710. 

  3710. 			
    3711. 

  3711. 			
    3712. 

  3712. 		</div>
    3713. 

  3713. 	</div>
    3714. 

  3714. </div><div class="section-method">
    3715. 

  3715. 	<a name="//api/name/inSavePoint:" title="inSavePoint:"></a>
    3716. 

  3716. 	<h3 class="method-title"><code><a href="#//api/name/inSavePoint:">&ndash;&nbsp;inSavePoint:</a></code>
    3717. 

  3717. </h3>
    3718. 

  3718. 

  3719. 	<div class="method-info">
    3720. 

  3720. 		<div class="pointy-thing"></div>
    3721. 

  3721. 

  3722. 		<div class="method-info-container">
    3723. 

  3723. 			
    3724. 

  3724. 			
    3725. 

  3725. 			<div class="method-subsection brief-description">
    3726. 

  3726. 				<p>Start save point</p>
    3727. 

  3727. 			</div>
    3728. 

  3728. 			
    3729. 

  3729. 		    
    3730. 

  3730. 

  3731. 			<div class="method-subsection method-declaration"><code>- (NSError *)inSavePoint:(void ( ^ ) ( BOOL *rollback ))<em>block</em></code></div>
    3732. 

  3732. 

  3733. 		    
    3734. 

  3734. 			
    3735. 

  3735. 			<div class="method-subsection arguments-section parameters">
    3736. 

  3736. 				<h4 class="method-subtitle parameter-title">Parameters</h4>
    3737. 

  3737. 				<table class="argument-def parameter-def">
    3738. 

  3738. 				
    3739. 

  3739. 					<tr>
    3740. 

  3740. 						<th scope="row" class="argument-name"><code>block</code></th>
    3741. 

  3741. 						<td><p>Block of code to perform from within save point.</p></td>
    3742. 

  3742. 					</tr>
    3743. 

  3743. 				
    3744. 

  3744. 				</table>
    3745. 

  3745. 			</div>
    3746. 

  3746. 			
    3747. 

  3747. 

  3748. 			
    3749. 

  3749. 			<div class="method-subsection return">
    3750. 

  3750. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    3751. 

  3751. 				<p>The NSError corresponding to the error, if any. If no error, returns <code>nil</code>.</p>
    3752. 

  3752. 			</div>
    3753. 

  3753. 			
    3754. 

  3754. 

  3755. 			
    3756. 

  3756. 

  3757. 			
    3758. 

  3758. 			<div class="method-subsection discussion-section">
    3759. 

  3759. 				<h4 class="method-subtitle">Discussion</h4>
    3760. 

  3760. 				<p>Start save point</p>
    3761. 

  3761. 			</div>
    3762. 

  3762. 			
    3763. 

  3763. 

  3764. 			
    3765. 

  3765. 

  3766. 			
    3767. 

  3767. 			<div class="method-subsection see-also-section">
    3768. 

  3768. 				<h4 class="method-subtitle">See Also</h4>
    3769. 

  3769. 				<ul>
    3770. 

  3770. 					
    3771. 

  3771. 					<li><code><p><a href="#//api/name/startSavePointWithName:error:">- startSavePointWithName:error:</a></p></code></li>
    3772. 

  3772. 					
    3773. 

  3773. 					<li><code><p><a href="#//api/name/releaseSavePointWithName:error:">- releaseSavePointWithName:error:</a></p></code></li>
    3774. 

  3774. 					
    3775. 

  3775. 					<li><code><p><a href="#//api/name/rollbackToSavePointWithName:error:">- rollbackToSavePointWithName:error:</a></p></code></li>
    3776. 

  3776. 					
    3777. 

  3777. 				</ul>
    3778. 

  3778. 			</div>
    3779. 

  3779. 			
    3780. 

  3780. 

  3781. 			
    3782. 

  3782. 			<div class="method-subsection declared-in-section">
    3783. 

  3783. 				<h4 class="method-subtitle">Declared In</h4>
    3784. 

  3784. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    3785. 

  3785. 			</div>
    3786. 

  3786. 			
    3787. 

  3787. 			
    3788. 

  3788. 		</div>
    3789. 

  3789. 	</div>
    3790. 

  3790. </div>
    3791. 

  3791. 						</div>
    3792. 

  3792. 						
    3793. 

  3793. 

  3794. 						<a title="SQLite library status" name="task_SQLite library status"></a>
    3795. 

  3795. 						<h2 class="task-title">SQLite library status</h2>
    3796. 

  3796. 

  3797. 						<div class="task-list">
    3798. 

  3798. 							<div class="section-method">
    3799. 

  3799. 	<a name="//api/name/isSQLiteThreadSafe" title="isSQLiteThreadSafe"></a>
    3800. 

  3800. 	<h3 class="method-title"><code><a href="#//api/name/isSQLiteThreadSafe">+&nbsp;isSQLiteThreadSafe</a></code>
    3801. 

  3801. </h3>
    3802. 

  3802. 

  3803. 	<div class="method-info">
    3804. 

  3804. 		<div class="pointy-thing"></div>
    3805. 

  3805. 

  3806. 		<div class="method-info-container">
    3807. 

  3807. 			
    3808. 

  3808. 			
    3809. 

  3809. 			<div class="method-subsection brief-description">
    3810. 

  3810. 				<p>Test to see if the library is threadsafe</p>
    3811. 

  3811. 			</div>
    3812. 

  3812. 			
    3813. 

  3813. 		    
    3814. 

  3814. 

  3815. 			<div class="method-subsection method-declaration"><code>+ (BOOL)isSQLiteThreadSafe</code></div>
    3816. 

  3816. 

  3817. 		    
    3818. 

  3818. 			
    3819. 

  3819. 

  3820. 			
    3821. 

  3821. 			<div class="method-subsection return">
    3822. 

  3822. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    3823. 

  3823. 				<p><code>NO</code> if and only if SQLite was compiled with mutexing code omitted due to the SQLITE_THREADSAFE compile-time option being set to 0.</p>
    3824. 

  3824. 			</div>
    3825. 

  3825. 			
    3826. 

  3826. 

  3827. 			
    3828. 

  3828. 

  3829. 			
    3830. 

  3830. 			<div class="method-subsection discussion-section">
    3831. 

  3831. 				<h4 class="method-subtitle">Discussion</h4>
    3832. 

  3832. 				<p>Test to see if the library is threadsafe</p>
    3833. 

  3833. 			</div>
    3834. 

  3834. 			
    3835. 

  3835. 

  3836. 			
    3837. 

  3837. 

  3838. 			
    3839. 

  3839. 			<div class="method-subsection see-also-section">
    3840. 

  3840. 				<h4 class="method-subtitle">See Also</h4>
    3841. 

  3841. 				<ul>
    3842. 

  3842. 					
    3843. 

  3843. 					<li><code><p><a href="http://sqlite.org/c3ref/threadsafe.html">sqlite3_threadsafe()</a></p></code></li>
    3844. 

  3844. 					
    3845. 

  3845. 				</ul>
    3846. 

  3846. 			</div>
    3847. 

  3847. 			
    3848. 

  3848. 

  3849. 			
    3850. 

  3850. 			<div class="method-subsection declared-in-section">
    3851. 

  3851. 				<h4 class="method-subtitle">Declared In</h4>
    3852. 

  3852. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    3853. 

  3853. 			</div>
    3854. 

  3854. 			
    3855. 

  3855. 			
    3856. 

  3856. 		</div>
    3857. 

  3857. 	</div>
    3858. 

  3858. </div><div class="section-method">
    3859. 

  3859. 	<a name="//api/name/sqliteLibVersion" title="sqliteLibVersion"></a>
    3860. 

  3860. 	<h3 class="method-title"><code><a href="#//api/name/sqliteLibVersion">+&nbsp;sqliteLibVersion</a></code>
    3861. 

  3861. </h3>
    3862. 

  3862. 

  3863. 	<div class="method-info">
    3864. 

  3864. 		<div class="pointy-thing"></div>
    3865. 

  3865. 

  3866. 		<div class="method-info-container">
    3867. 

  3867. 			
    3868. 

  3868. 			
    3869. 

  3869. 			<div class="method-subsection brief-description">
    3870. 

  3870. 				<p>Run-time library version numbers</p>
    3871. 

  3871. 			</div>
    3872. 

  3872. 			
    3873. 

  3873. 		    
    3874. 

  3874. 

  3875. 			<div class="method-subsection method-declaration"><code>+ (NSString *)sqliteLibVersion</code></div>
    3876. 

  3876. 

  3877. 		    
    3878. 

  3878. 			
    3879. 

  3879. 

  3880. 			
    3881. 

  3881. 			<div class="method-subsection return">
    3882. 

  3882. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    3883. 

  3883. 				<p>The sqlite library version string.</p>
    3884. 

  3884. 			</div>
    3885. 

  3885. 			
    3886. 

  3886. 

  3887. 			
    3888. 

  3888. 

  3889. 			
    3890. 

  3890. 			<div class="method-subsection discussion-section">
    3891. 

  3891. 				<h4 class="method-subtitle">Discussion</h4>
    3892. 

  3892. 				<p>Run-time library version numbers</p>
    3893. 

  3893. 			</div>
    3894. 

  3894. 			
    3895. 

  3895. 

  3896. 			
    3897. 

  3897. 

  3898. 			
    3899. 

  3899. 			<div class="method-subsection see-also-section">
    3900. 

  3900. 				<h4 class="method-subtitle">See Also</h4>
    3901. 

  3901. 				<ul>
    3902. 

  3902. 					
    3903. 

  3903. 					<li><code><p><a href="http://sqlite.org/c3ref/libversion.html">sqlite3_libversion()</a></p></code></li>
    3904. 

  3904. 					
    3905. 

  3905. 				</ul>
    3906. 

  3906. 			</div>
    3907. 

  3907. 			
    3908. 

  3908. 

  3909. 			
    3910. 

  3910. 			<div class="method-subsection declared-in-section">
    3911. 

  3911. 				<h4 class="method-subtitle">Declared In</h4>
    3912. 

  3912. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    3913. 

  3913. 			</div>
    3914. 

  3914. 			
    3915. 

  3915. 			
    3916. 

  3916. 		</div>
    3917. 

  3917. 	</div>
    3918. 

  3918. </div>
    3919. 

  3919. 						</div>
    3920. 

  3920. 						
    3921. 

  3921. 

  3922. 						<a title="Make SQL function" name="task_Make SQL function"></a>
    3923. 

  3923. 						<h2 class="task-title">Make SQL function</h2>
    3924. 

  3924. 

  3925. 						<div class="task-list">
    3926. 

  3926. 							<div class="section-method">
    3927. 

  3927. 	<a name="//api/name/makeFunctionNamed:maximumArguments:withBlock:" title="makeFunctionNamed:maximumArguments:withBlock:"></a>
    3928. 

  3928. 	<h3 class="method-title"><code><a href="#//api/name/makeFunctionNamed:maximumArguments:withBlock:">&ndash;&nbsp;makeFunctionNamed:maximumArguments:withBlock:</a></code>
    3929. 

  3929. </h3>
    3930. 

  3930. 

  3931. 	<div class="method-info">
    3932. 

  3932. 		<div class="pointy-thing"></div>
    3933. 

  3933. 

  3934. 		<div class="method-info-container">
    3935. 

  3935. 			
    3936. 

  3936. 			
    3937. 

  3937. 			<div class="method-subsection brief-description">
    3938. 

  3938. 				<p>Adds SQL functions or aggregates or to redefine the behavior of existing SQL functions or aggregates.</p>
    3939. 

  3939. 			</div>
    3940. 

  3940. 			
    3941. 

  3941. 		    
    3942. 

  3942. 

  3943. 			<div class="method-subsection method-declaration"><code>- (void)makeFunctionNamed:(NSString *)<em>name</em> maximumArguments:(int)<em>count</em> withBlock:(void ( ^ ) ( sqlite3_context *context , int argc , sqlite3_value **argv ))<em>block</em></code></div>
    3944. 

  3944. 

  3945. 		    
    3946. 

  3946. 			
    3947. 

  3947. 			<div class="method-subsection arguments-section parameters">
    3948. 

  3948. 				<h4 class="method-subtitle parameter-title">Parameters</h4>
    3949. 

  3949. 				<table class="argument-def parameter-def">
    3950. 

  3950. 				
    3951. 

  3951. 					<tr>
    3952. 

  3952. 						<th scope="row" class="argument-name"><code>name</code></th>
    3953. 

  3953. 						<td><p>Name of function</p></td>
    3954. 

  3954. 					</tr>
    3955. 

  3955. 				
    3956. 

  3956. 					<tr>
    3957. 

  3957. 						<th scope="row" class="argument-name"><code>count</code></th>
    3958. 

  3958. 						<td><p>Maximum number of parameters</p></td>
    3959. 

  3959. 					</tr>
    3960. 

  3960. 				
    3961. 

  3961. 					<tr>
    3962. 

  3962. 						<th scope="row" class="argument-name"><code>block</code></th>
    3963. 

  3963. 						<td><p>The block of code for the function</p></td>
    3964. 

  3964. 					</tr>
    3965. 

  3965. 				
    3966. 

  3966. 				</table>
    3967. 

  3967. 			</div>
    3968. 

  3968. 			
    3969. 

  3969. 

  3970. 			
    3971. 

  3971. 

  3972. 			
    3973. 

  3973. 

  3974. 			
    3975. 

  3975. 			<div class="method-subsection discussion-section">
    3976. 

  3976. 				<h4 class="method-subtitle">Discussion</h4>
    3977. 

  3977. 				<p>Adds SQL functions or aggregates or to redefine the behavior of existing SQL functions or aggregates.</p>
    3978. 

  3978. 

  3979. <p>For example:</p>
    3980. 

  3980. 

  3981. <pre><code>[queue inDatabase:^(FMDatabase *adb) {
    3982. 

  3982. 

  3983.     [adb executeUpdate:@"create table ftest (foo text)"];
    3984. 

  3984.     [adb executeUpdate:@"insert into ftest values ('hello')"];
    3985. 

  3985.     [adb executeUpdate:@"insert into ftest values ('hi')"];
    3986. 

  3986.     [adb executeUpdate:@"insert into ftest values ('not h!')"];
    3987. 

  3987.     [adb executeUpdate:@"insert into ftest values ('definitely not h!')"];
    3988. 

  3988. 

  3989.     [adb makeFunctionNamed:@"StringStartsWithH" maximumArguments:1 withBlock:^(sqlite3_context *context, int aargc, sqlite3_value **aargv) {
    3990. 

  3990.         if (sqlite3_value_type(aargv[0]) == SQLITE_TEXT) {
    3991. 

  3991.             @autoreleasepool {
    3992. 

  3992.                 const char *c = (const char *)sqlite3_value_text(aargv[0]);
    3993. 

  3993.                 NSString *s = [NSString stringWithUTF8String:c];
    3994. 

  3994.                 sqlite3_result_int(context, [s hasPrefix:@"h"]);
    3995. 

  3995.             }
    3996. 

  3996.         }
    3997. 

  3997.         else {
    3998. 

  3998.             NSLog(@"Unknown formart for StringStartsWithH (%d) %s:%d", sqlite3_value_type(aargv[0]), __FUNCTION__, __LINE__);
    3999. 

  3999.             sqlite3_result_null(context);
    4000. 

  4000.         }
    4001. 

  4001.     }];
    4002. 

  4002. 

  4003.     int rowCount = 0;
    4004. 

  4004.     FMResultSet *ars = [adb executeQuery:@"select * from ftest where StringStartsWithH(foo)"];
    4005. 

  4005.     while ([ars next]) {
    4006. 

  4006.         rowCount++;
    4007. 

  4007.         NSLog(@"Does %@ start with 'h'?", [rs stringForColumnIndex:0]);
    4008. 

  4008.     }
    4009. 

  4009.     FMDBQuickCheck(rowCount == 2);
    4010. 

  4010. }];
    4011. 

  4011. </code></pre>
    4012. 

  4012. 			</div>
    4013. 

  4013. 			
    4014. 

  4014. 

  4015. 			
    4016. 

  4016. 

  4017. 			
    4018. 

  4018. 			<div class="method-subsection see-also-section">
    4019. 

  4019. 				<h4 class="method-subtitle">See Also</h4>
    4020. 

  4020. 				<ul>
    4021. 

  4021. 					
    4022. 

  4022. 					<li><code><p><a href="http://sqlite.org/c3ref/create_function.html">sqlite3_create_function()</a></p></code></li>
    4023. 

  4023. 					
    4024. 

  4024. 				</ul>
    4025. 

  4025. 			</div>
    4026. 

  4026. 			
    4027. 

  4027. 

  4028. 			
    4029. 

  4029. 			<div class="method-subsection declared-in-section">
    4030. 

  4030. 				<h4 class="method-subtitle">Declared In</h4>
    4031. 

  4031. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    4032. 

  4032. 			</div>
    4033. 

  4033. 			
    4034. 

  4034. 			
    4035. 

  4035. 		</div>
    4036. 

  4036. 	</div>
    4037. 

  4037. </div>
    4038. 

  4038. 						</div>
    4039. 

  4039. 						
    4040. 

  4040. 

  4041. 						<a title="Date formatter" name="task_Date formatter"></a>
    4042. 

  4042. 						<h2 class="task-title">Date formatter</h2>
    4043. 

  4043. 

  4044. 						<div class="task-list">
    4045. 

  4045. 							<div class="section-method">
    4046. 

  4046. 	<a name="//api/name/storeableDateFormat:" title="storeableDateFormat:"></a>
    4047. 

  4047. 	<h3 class="method-title"><code><a href="#//api/name/storeableDateFormat:">+&nbsp;storeableDateFormat:</a></code>
    4048. 

  4048. </h3>
    4049. 

  4049. 

  4050. 	<div class="method-info">
    4051. 

  4051. 		<div class="pointy-thing"></div>
    4052. 

  4052. 

  4053. 		<div class="method-info-container">
    4054. 

  4054. 			
    4055. 

  4055. 			
    4056. 

  4056. 			<div class="method-subsection brief-description">
    4057. 

  4057. 				<p>Generate an <code>NSDateFormatter</code> that won&rsquo;t be broken by permutations of timezones or locales.</p>
    4058. 

  4058. 			</div>
    4059. 

  4059. 			
    4060. 

  4060. 		    
    4061. 

  4061. 

  4062. 			<div class="method-subsection method-declaration"><code>+ (NSDateFormatter *)storeableDateFormat:(NSString *)<em>format</em></code></div>
    4063. 

  4063. 

  4064. 		    
    4065. 

  4065. 			
    4066. 

  4066. 			<div class="method-subsection arguments-section parameters">
    4067. 

  4067. 				<h4 class="method-subtitle parameter-title">Parameters</h4>
    4068. 

  4068. 				<table class="argument-def parameter-def">
    4069. 

  4069. 				
    4070. 

  4070. 					<tr>
    4071. 

  4071. 						<th scope="row" class="argument-name"><code>format</code></th>
    4072. 

  4072. 						<td><p>A valid NSDateFormatter format string.</p></td>
    4073. 

  4073. 					</tr>
    4074. 

  4074. 				
    4075. 

  4075. 				</table>
    4076. 

  4076. 			</div>
    4077. 

  4077. 			
    4078. 

  4078. 

  4079. 			
    4080. 

  4080. 			<div class="method-subsection return">
    4081. 

  4081. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    4082. 

  4082. 				<p>A <code>NSDateFormatter</code> that can be used for converting dates to strings and vice versa.</p>
    4083. 

  4083. 			</div>
    4084. 

  4084. 			
    4085. 

  4085. 

  4086. 			
    4087. 

  4087. 

  4088. 			
    4089. 

  4089. 			<div class="method-subsection discussion-section">
    4090. 

  4090. 				<h4 class="method-subtitle">Discussion</h4>
    4091. 

  4091. 				<p>Generate an <code>NSDateFormatter</code> that won&rsquo;t be broken by permutations of timezones or locales.</p>
    4092. 

  4092. 

  4093. <p>Use this method to generate values to set the dateFormat property.</p>
    4094. 

  4094. 

  4095. <p>Example:</p>
    4096. 

  4096. 

  4097. <pre><code>myDB.dateFormat = [FMDatabase storeableDateFormat:@"yyyy-MM-dd HH:mm:ss"];
    4098. 

  4098. </code></pre><div class="warning"><p><strong>Warning:</strong> Note that <code>NSDateFormatter</code> is not thread-safe, so the formatter generated by this method should be assigned to only one FMDB instance and should not be used for other purposes.</p></div>
    4099. 

  4099. 			</div>
    4100. 

  4100. 			
    4101. 

  4101. 

  4102. 			
    4103. 

  4103. 

  4104. 			
    4105. 

  4105. 			<div class="method-subsection see-also-section">
    4106. 

  4106. 				<h4 class="method-subtitle">See Also</h4>
    4107. 

  4107. 				<ul>
    4108. 

  4108. 					
    4109. 

  4109. 					<li><code><p><a href="#//api/name/hasDateFormatter">- hasDateFormatter</a></p></code></li>
    4110. 

  4110. 					
    4111. 

  4111. 					<li><code><p><a href="#//api/name/setDateFormat:">- setDateFormat:</a></p></code></li>
    4112. 

  4112. 					
    4113. 

  4113. 					<li><code><p><a href="#//api/name/dateFromString:">- dateFromString:</a></p></code></li>
    4114. 

  4114. 					
    4115. 

  4115. 					<li><code><p><a href="#//api/name/stringFromDate:">- stringFromDate:</a></p></code></li>
    4116. 

  4116. 					
    4117. 

  4117. 					<li><code><p><a href="#//api/name/storeableDateFormat:">+ storeableDateFormat:</a></p></code></li>
    4118. 

  4118. 					
    4119. 

  4119. 				</ul>
    4120. 

  4120. 			</div>
    4121. 

  4121. 			
    4122. 

  4122. 

  4123. 			
    4124. 

  4124. 			<div class="method-subsection declared-in-section">
    4125. 

  4125. 				<h4 class="method-subtitle">Declared In</h4>
    4126. 

  4126. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    4127. 

  4127. 			</div>
    4128. 

  4128. 			
    4129. 

  4129. 			
    4130. 

  4130. 		</div>
    4131. 

  4131. 	</div>
    4132. 

  4132. </div><div class="section-method">
    4133. 

  4133. 	<a name="//api/name/hasDateFormatter" title="hasDateFormatter"></a>
    4134. 

  4134. 	<h3 class="method-title"><code><a href="#//api/name/hasDateFormatter">&ndash;&nbsp;hasDateFormatter</a></code>
    4135. 

  4135. </h3>
    4136. 

  4136. 

  4137. 	<div class="method-info">
    4138. 

  4138. 		<div class="pointy-thing"></div>
    4139. 

  4139. 

  4140. 		<div class="method-info-container">
    4141. 

  4141. 			
    4142. 

  4142. 			
    4143. 

  4143. 			<div class="method-subsection brief-description">
    4144. 

  4144. 				<p>Test whether the database has a date formatter assigned.</p>
    4145. 

  4145. 			</div>
    4146. 

  4146. 			
    4147. 

  4147. 		    
    4148. 

  4148. 

  4149. 			<div class="method-subsection method-declaration"><code>- (BOOL)hasDateFormatter</code></div>
    4150. 

  4150. 

  4151. 		    
    4152. 

  4152. 			
    4153. 

  4153. 

  4154. 			
    4155. 

  4155. 			<div class="method-subsection return">
    4156. 

  4156. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    4157. 

  4157. 				<p><code>YES</code> if there is a date formatter; <code>NO</code> if not.</p>
    4158. 

  4158. 			</div>
    4159. 

  4159. 			
    4160. 

  4160. 

  4161. 			
    4162. 

  4162. 

  4163. 			
    4164. 

  4164. 			<div class="method-subsection discussion-section">
    4165. 

  4165. 				<h4 class="method-subtitle">Discussion</h4>
    4166. 

  4166. 				<p>Test whether the database has a date formatter assigned.</p>
    4167. 

  4167. 			</div>
    4168. 

  4168. 			
    4169. 

  4169. 

  4170. 			
    4171. 

  4171. 

  4172. 			
    4173. 

  4173. 			<div class="method-subsection see-also-section">
    4174. 

  4174. 				<h4 class="method-subtitle">See Also</h4>
    4175. 

  4175. 				<ul>
    4176. 

  4176. 					
    4177. 

  4177. 					<li><code><p><a href="#//api/name/hasDateFormatter">- hasDateFormatter</a></p></code></li>
    4178. 

  4178. 					
    4179. 

  4179. 					<li><code><p><a href="#//api/name/setDateFormat:">- setDateFormat:</a></p></code></li>
    4180. 

  4180. 					
    4181. 

  4181. 					<li><code><p><a href="#//api/name/dateFromString:">- dateFromString:</a></p></code></li>
    4182. 

  4182. 					
    4183. 

  4183. 					<li><code><p><a href="#//api/name/stringFromDate:">- stringFromDate:</a></p></code></li>
    4184. 

  4184. 					
    4185. 

  4185. 					<li><code><p><a href="#//api/name/storeableDateFormat:">+ storeableDateFormat:</a></p></code></li>
    4186. 

  4186. 					
    4187. 

  4187. 				</ul>
    4188. 

  4188. 			</div>
    4189. 

  4189. 			
    4190. 

  4190. 

  4191. 			
    4192. 

  4192. 			<div class="method-subsection declared-in-section">
    4193. 

  4193. 				<h4 class="method-subtitle">Declared In</h4>
    4194. 

  4194. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    4195. 

  4195. 			</div>
    4196. 

  4196. 			
    4197. 

  4197. 			
    4198. 

  4198. 		</div>
    4199. 

  4199. 	</div>
    4200. 

  4200. </div><div class="section-method">
    4201. 

  4201. 	<a name="//api/name/setDateFormat:" title="setDateFormat:"></a>
    4202. 

  4202. 	<h3 class="method-title"><code><a href="#//api/name/setDateFormat:">&ndash;&nbsp;setDateFormat:</a></code>
    4203. 

  4203. </h3>
    4204. 

  4204. 

  4205. 	<div class="method-info">
    4206. 

  4206. 		<div class="pointy-thing"></div>
    4207. 

  4207. 

  4208. 		<div class="method-info-container">
    4209. 

  4209. 			
    4210. 

  4210. 			
    4211. 

  4211. 			<div class="method-subsection brief-description">
    4212. 

  4212. 				<p>Set to a date formatter to use string dates with sqlite instead of the default UNIX timestamps.</p>
    4213. 

  4213. 			</div>
    4214. 

  4214. 			
    4215. 

  4215. 		    
    4216. 

  4216. 

  4217. 			<div class="method-subsection method-declaration"><code>- (void)setDateFormat:(NSDateFormatter *)<em>format</em></code></div>
    4218. 

  4218. 

  4219. 		    
    4220. 

  4220. 			
    4221. 

  4221. 			<div class="method-subsection arguments-section parameters">
    4222. 

  4222. 				<h4 class="method-subtitle parameter-title">Parameters</h4>
    4223. 

  4223. 				<table class="argument-def parameter-def">
    4224. 

  4224. 				
    4225. 

  4225. 					<tr>
    4226. 

  4226. 						<th scope="row" class="argument-name"><code>format</code></th>
    4227. 

  4227. 						<td><p>Set to nil to use UNIX timestamps. Defaults to nil. Should be set using a formatter generated using FMDatabase::storeableDateFormat.</p></td>
    4228. 

  4228. 					</tr>
    4229. 

  4229. 				
    4230. 

  4230. 				</table>
    4231. 

  4231. 			</div>
    4232. 

  4232. 			
    4233. 

  4233. 

  4234. 			
    4235. 

  4235. 

  4236. 			
    4237. 

  4237. 

  4238. 			
    4239. 

  4239. 			<div class="method-subsection discussion-section">
    4240. 

  4240. 				<h4 class="method-subtitle">Discussion</h4>
    4241. 

  4241. 				<p>Set to a date formatter to use string dates with sqlite instead of the default UNIX timestamps.</p><div class="warning"><p><strong>Warning:</strong> Note there is no direct getter for the <code>NSDateFormatter</code>, and you should not use the formatter you pass to FMDB for other purposes, as <code>NSDateFormatter</code> is not thread-safe.</p></div>
    4242. 

  4242. 			</div>
    4243. 

  4243. 			
    4244. 

  4244. 

  4245. 			
    4246. 

  4246. 

  4247. 			
    4248. 

  4248. 			<div class="method-subsection see-also-section">
    4249. 

  4249. 				<h4 class="method-subtitle">See Also</h4>
    4250. 

  4250. 				<ul>
    4251. 

  4251. 					
    4252. 

  4252. 					<li><code><p><a href="#//api/name/hasDateFormatter">- hasDateFormatter</a></p></code></li>
    4253. 

  4253. 					
    4254. 

  4254. 					<li><code><p><a href="#//api/name/setDateFormat:">- setDateFormat:</a></p></code></li>
    4255. 

  4255. 					
    4256. 

  4256. 					<li><code><p><a href="#//api/name/dateFromString:">- dateFromString:</a></p></code></li>
    4257. 

  4257. 					
    4258. 

  4258. 					<li><code><p><a href="#//api/name/stringFromDate:">- stringFromDate:</a></p></code></li>
    4259. 

  4259. 					
    4260. 

  4260. 					<li><code><p><a href="#//api/name/storeableDateFormat:">+ storeableDateFormat:</a></p></code></li>
    4261. 

  4261. 					
    4262. 

  4262. 				</ul>
    4263. 

  4263. 			</div>
    4264. 

  4264. 			
    4265. 

  4265. 

  4266. 			
    4267. 

  4267. 			<div class="method-subsection declared-in-section">
    4268. 

  4268. 				<h4 class="method-subtitle">Declared In</h4>
    4269. 

  4269. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    4270. 

  4270. 			</div>
    4271. 

  4271. 			
    4272. 

  4272. 			
    4273. 

  4273. 		</div>
    4274. 

  4274. 	</div>
    4275. 

  4275. </div><div class="section-method">
    4276. 

  4276. 	<a name="//api/name/dateFromString:" title="dateFromString:"></a>
    4277. 

  4277. 	<h3 class="method-title"><code><a href="#//api/name/dateFromString:">&ndash;&nbsp;dateFromString:</a></code>
    4278. 

  4278. </h3>
    4279. 

  4279. 

  4280. 	<div class="method-info">
    4281. 

  4281. 		<div class="pointy-thing"></div>
    4282. 

  4282. 

  4283. 		<div class="method-info-container">
    4284. 

  4284. 			
    4285. 

  4285. 			
    4286. 

  4286. 			<div class="method-subsection brief-description">
    4287. 

  4287. 				<p>Convert the supplied NSString to NSDate, using the current database formatter.</p>
    4288. 

  4288. 			</div>
    4289. 

  4289. 			
    4290. 

  4290. 		    
    4291. 

  4291. 

  4292. 			<div class="method-subsection method-declaration"><code>- (NSDate *)dateFromString:(NSString *)<em>s</em></code></div>
    4293. 

  4293. 

  4294. 		    
    4295. 

  4295. 			
    4296. 

  4296. 			<div class="method-subsection arguments-section parameters">
    4297. 

  4297. 				<h4 class="method-subtitle parameter-title">Parameters</h4>
    4298. 

  4298. 				<table class="argument-def parameter-def">
    4299. 

  4299. 				
    4300. 

  4300. 					<tr>
    4301. 

  4301. 						<th scope="row" class="argument-name"><code>s</code></th>
    4302. 

  4302. 						<td><p><code>NSString</code> to convert to <code>NSDate</code>.</p></td>
    4303. 

  4303. 					</tr>
    4304. 

  4304. 				
    4305. 

  4305. 				</table>
    4306. 

  4306. 			</div>
    4307. 

  4307. 			
    4308. 

  4308. 

  4309. 			
    4310. 

  4310. 			<div class="method-subsection return">
    4311. 

  4311. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    4312. 

  4312. 				<p>The <code>NSDate</code> object; or <code>nil</code> if no formatter is set.</p>
    4313. 

  4313. 			</div>
    4314. 

  4314. 			
    4315. 

  4315. 

  4316. 			
    4317. 

  4317. 

  4318. 			
    4319. 

  4319. 			<div class="method-subsection discussion-section">
    4320. 

  4320. 				<h4 class="method-subtitle">Discussion</h4>
    4321. 

  4321. 				<p>Convert the supplied NSString to NSDate, using the current database formatter.</p>
    4322. 

  4322. 			</div>
    4323. 

  4323. 			
    4324. 

  4324. 

  4325. 			
    4326. 

  4326. 

  4327. 			
    4328. 

  4328. 			<div class="method-subsection see-also-section">
    4329. 

  4329. 				<h4 class="method-subtitle">See Also</h4>
    4330. 

  4330. 				<ul>
    4331. 

  4331. 					
    4332. 

  4332. 					<li><code><p><a href="#//api/name/hasDateFormatter">- hasDateFormatter</a></p></code></li>
    4333. 

  4333. 					
    4334. 

  4334. 					<li><code><p><a href="#//api/name/setDateFormat:">- setDateFormat:</a></p></code></li>
    4335. 

  4335. 					
    4336. 

  4336. 					<li><code><p><a href="#//api/name/dateFromString:">- dateFromString:</a></p></code></li>
    4337. 

  4337. 					
    4338. 

  4338. 					<li><code><p><a href="#//api/name/stringFromDate:">- stringFromDate:</a></p></code></li>
    4339. 

  4339. 					
    4340. 

  4340. 					<li><code><p><a href="#//api/name/storeableDateFormat:">+ storeableDateFormat:</a></p></code></li>
    4341. 

  4341. 					
    4342. 

  4342. 				</ul>
    4343. 

  4343. 			</div>
    4344. 

  4344. 			
    4345. 

  4345. 

  4346. 			
    4347. 

  4347. 			<div class="method-subsection declared-in-section">
    4348. 

  4348. 				<h4 class="method-subtitle">Declared In</h4>
    4349. 

  4349. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    4350. 

  4350. 			</div>
    4351. 

  4351. 			
    4352. 

  4352. 			
    4353. 

  4353. 		</div>
    4354. 

  4354. 	</div>
    4355. 

  4355. </div><div class="section-method">
    4356. 

  4356. 	<a name="//api/name/stringFromDate:" title="stringFromDate:"></a>
    4357. 

  4357. 	<h3 class="method-title"><code><a href="#//api/name/stringFromDate:">&ndash;&nbsp;stringFromDate:</a></code>
    4358. 

  4358. </h3>
    4359. 

  4359. 

  4360. 	<div class="method-info">
    4361. 

  4361. 		<div class="pointy-thing"></div>
    4362. 

  4362. 

  4363. 		<div class="method-info-container">
    4364. 

  4364. 			
    4365. 

  4365. 			
    4366. 

  4366. 			<div class="method-subsection brief-description">
    4367. 

  4367. 				<p>Convert the supplied NSDate to NSString, using the current database formatter.</p>
    4368. 

  4368. 			</div>
    4369. 

  4369. 			
    4370. 

  4370. 		    
    4371. 

  4371. 

  4372. 			<div class="method-subsection method-declaration"><code>- (NSString *)stringFromDate:(NSDate *)<em>date</em></code></div>
    4373. 

  4373. 

  4374. 		    
    4375. 

  4375. 			
    4376. 

  4376. 			<div class="method-subsection arguments-section parameters">
    4377. 

  4377. 				<h4 class="method-subtitle parameter-title">Parameters</h4>
    4378. 

  4378. 				<table class="argument-def parameter-def">
    4379. 

  4379. 				
    4380. 

  4380. 					<tr>
    4381. 

  4381. 						<th scope="row" class="argument-name"><code>date</code></th>
    4382. 

  4382. 						<td><p><code>NSDate</code> of date to convert to <code>NSString</code>.</p></td>
    4383. 

  4383. 					</tr>
    4384. 

  4384. 				
    4385. 

  4385. 				</table>
    4386. 

  4386. 			</div>
    4387. 

  4387. 			
    4388. 

  4388. 

  4389. 			
    4390. 

  4390. 			<div class="method-subsection return">
    4391. 

  4391. 				<h4 class="method-subtitle parameter-title">Return Value</h4>
    4392. 

  4392. 				<p>The <code>NSString</code> representation of the date; <code>nil</code> if no formatter is set.</p>
    4393. 

  4393. 			</div>
    4394. 

  4394. 			
    4395. 

  4395. 

  4396. 			
    4397. 

  4397. 

  4398. 			
    4399. 

  4399. 			<div class="method-subsection discussion-section">
    4400. 

  4400. 				<h4 class="method-subtitle">Discussion</h4>
    4401. 

  4401. 				<p>Convert the supplied NSDate to NSString, using the current database formatter.</p>
    4402. 

  4402. 			</div>
    4403. 

  4403. 			
    4404. 

  4404. 

  4405. 			
    4406. 

  4406. 

  4407. 			
    4408. 

  4408. 			<div class="method-subsection see-also-section">
    4409. 

  4409. 				<h4 class="method-subtitle">See Also</h4>
    4410. 

  4410. 				<ul>
    4411. 

  4411. 					
    4412. 

  4412. 					<li><code><p><a href="#//api/name/hasDateFormatter">- hasDateFormatter</a></p></code></li>
    4413. 

  4413. 					
    4414. 

  4414. 					<li><code><p><a href="#//api/name/setDateFormat:">- setDateFormat:</a></p></code></li>
    4415. 

  4415. 					
    4416. 

  4416. 					<li><code><p><a href="#//api/name/dateFromString:">- dateFromString:</a></p></code></li>
    4417. 

  4417. 					
    4418. 

  4418. 					<li><code><p><a href="#//api/name/stringFromDate:">- stringFromDate:</a></p></code></li>
    4419. 

  4419. 					
    4420. 

  4420. 					<li><code><p><a href="#//api/name/storeableDateFormat:">+ storeableDateFormat:</a></p></code></li>
    4421. 

  4421. 					
    4422. 

  4422. 				</ul>
    4423. 

  4423. 			</div>
    4424. 

  4424. 			
    4425. 

  4425. 

  4426. 			
    4427. 

  4427. 			<div class="method-subsection declared-in-section">
    4428. 

  4428. 				<h4 class="method-subtitle">Declared In</h4>
    4429. 

  4429. 				<p><code class="declared-in-ref">FMDatabase.h</code></p>
    4430. 

  4430. 			</div>
    4431. 

  4431. 			
    4432. 

  4432. 			
    4433. 

  4433. 		</div>
    4434. 

  4434. 	</div>
    4435. 

  4435. </div>
    4436. 

  4436. 						</div>
    4437. 

  4437. 						
    4438. 

  4438. 					</div>
    4439. 

  4439. 					
    4440. 

  4440. 					
    4441. 

  4441. 

  4442.                     
    4443. 

  4443. 				</main>
    4444. 

  4444. 

  4445. 				<footer>
    4446. 

  4446. 					<div class="footer-copyright">
    4447. 

  4447. 						
    4448. 

  4448. 						<p class="copyright">Copyright &copy; 2015 ccgus. All rights reserved. Updated: 2015-01-25</p>
    4449. 

  4449. 						
    4450. 

  4450. 						
    4451. 

  4451. 						<p class="generator">Generated by <a href="http://appledoc.gentlebytes.com">appledoc 2.2.1 (build 1333)</a>.</p>
    4452. 

  4452. 						
    4453. 

  4453. 					</div>
    4454. 

  4454. 				</footer>
    4455. 

  4455. 			</div>
    4456. 

  4456. 		</div>
    4457. 

  4457. 	</article>
    4458. 

  4458. 

  4459. 	<script src="../js/script.js"></script>
    4460. 

  4460. </body>
    4461. 

  4461. </html>
    4462.