Эхлэл Бүгдийг харах Тусламж
Нэвтрэх
mirror
/
fmdb
2
0
Салаа 0
Файлууд Асуудлууд 0 Хуулах хүсэлтүүд 0 Мэдлэгийн сан
Мод: a47ed5789b
Салаанууд Тагууд
fmdb
/
html
/
Classes
/
FMDatabase.html

FMDatabase.html 129 KB
Түүх Анхны өгөгдөл

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312231323142315231623172318231923202321232223232324232523262327232823292330233123322333233423352336233723382339234023412342234323442345234623472348234923502351235223532354235523562357235823592360236123622363236423652366236723682369237023712372237323742375237623772378237923802381238223832384238523862387238823892390239123922393239423952396239723982399240024012402240324042405240624072408240924102411241224132414241524162417241824192420242124222423242424252426242724282429243024312432243324342435243624372438243924402441244224432444244524462447244824492450245124522453245424552456245724582459246024612462246324642465246624672468246924702471247224732474247524762477247824792480248124822483248424852486248724882489249024912492249324942495249624972498249925002501250225032504250525062507250825092510251125122513251425152516251725182519252025212522252325242525252625272528252925302531253225332534253525362537253825392540254125422543254425452546254725482549255025512552255325542555255625572558255925602561256225632564256525662567256825692570257125722573257425752576257725782579258025812582258325842585258625872588258925902591259225932594259525962597259825992600260126022603260426052606260726082609261026112612261326142615261626172618261926202621262226232624262526262627262826292630263126322633263426352636263726382639264026412642264326442645264626472648264926502651265226532654265526562657265826592660266126622663266426652666266726682669267026712672267326742675267626772678267926802681268226832684268526862687268826892690269126922693269426952696269726982699270027012702270327042705270627072708270927102711271227132714271527162717271827192720272127222723272427252726272727282729273027312732273327342735273627372738273927402741274227432744274527462747274827492750275127522753275427552756275727582759276027612762276327642765276627672768276927702771277227732774277527762777277827792780278127822783278427852786278727882789279027912792279327942795279627972798279928002801280228032804280528062807280828092810281128122813281428152816281728182819282028212822282328242825282628272828282928302831283228332834283528362837283828392840284128422843284428452846284728482849285028512852285328542855285628572858285928602861286228632864286528662867286828692870287128722873287428752876287728782879288028812882288328842885288628872888288928902891289228932894289528962897289828992900290129022903290429052906290729082909291029112912291329142915291629172918291929202921292229232924292529262927292829292930293129322933293429352936293729382939294029412942294329442945294629472948294929502951295229532954295529562957295829592960296129622963296429652966296729682969297029712972297329742975297629772978297929802981298229832984298529862987298829892990299129922993299429952996299729982999300030013002300330043005300630073008300930103011301230133014301530163017301830193020302130223023302430253026302730283029303030313032303330343035303630373038303930403041304230433044304530463047304830493050305130523053305430553056305730583059306030613062306330643065306630673068306930703071307230733074307530763077307830793080308130823083308430853086308730883089309030913092309330943095309630973098309931003101310231033104310531063107310831093110311131123113311431153116311731183119312031213122312331243125312631273128312931303131313231333134313531363137313831393140314131423143314431453146314731483149315031513152315331543155315631573158315931603161316231633164316531663167316831693170317131723173317431753176317731783179318031813182318331843185318631873188318931903191319231933194319531963197319831993200320132023203320432053206320732083209321032113212321332143215321632173218321932203221322232233224322532263227322832293230323132323233323432353236323732383239324032413242324332443245324632473248324932503251325232533254325532563257325832593260326132623263326432653266326732683269327032713272327332743275327632773278327932803281328232833284328532863287328832893290329132923293329432953296329732983299330033013302330333043305330633073308330933103311331233133314331533163317331833193320332133223323332433253326332733283329333033313332333333343335333633373338333933403341334233433344334533463347334833493350335133523353335433553356335733583359336033613362336333643365336633673368336933703371337233733374337533763377337833793380338133823383338433853386338733883389339033913392339333943395339633973398339934003401340234033404340534063407340834093410341134123413341434153416341734183419342034213422342334243425342634273428342934303431343234333434343534363437343834393440344134423443344434453446344734483449345034513452345334543455345634573458345934603461346234633464346534663467346834693470347134723473347434753476347734783479348034813482348334843485348634873488348934903491349234933494349534963497349834993500350135023503350435053506350735083509351035113512351335143515351635173518351935203521352235233524352535263527352835293530353135323533353435353536353735383539354035413542354335443545354635473548354935503551355235533554355535563557355835593560356135623563356435653566356735683569357035713572357335743575357635773578357935803581358235833584358535863587358835893590359135923593359435953596359735983599360036013602360336043605360636073608360936103611361236133614361536163617361836193620362136223623362436253626362736283629363036313632363336343635363636373638363936403641364236433644364536463647364836493650365136523653365436553656365736583659366036613662366336643665366636673668366936703671367236733674367536763677367836793680368136823683368436853686368736883689369036913692369336943695369636973698369937003701370237033704370537063707370837093710371137123713371437153716371737183719372037213722372337243725372637273728372937303731373237333734373537363737373837393740374137423743374437453746374737483749375037513752375337543755375637573758375937603761376237633764376537663767376837693770377137723773377437753776377737783779378037813782378337843785378637873788378937903791379237933794379537963797379837993800380138023803380438053806380738083809381038113812381338143815381638173818381938203821382238233824382538263827382838293830383138323833383438353836383738383839384038413842384338443845384638473848384938503851385238533854385538563857385838593860386138623863386438653866386738683869387038713872387338743875387638773878387938803881388238833884388538863887388838893890389138923893389438953896389738983899390039013902390339043905390639073908390939103911391239133914391539163917391839193920392139223923392439253926392739283929393039313932393339343935393639373938393939403941394239433944394539463947394839493950395139523953395439553956395739583959396039613962396339643965396639673968396939703971397239733974397539763977397839793980398139823983398439853986398739883989399039913992399339943995399639973998399940004001400240034004400540064007400840094010401140124013401440154016401740184019402040214022402340244025402640274028402940304031403240334034403540364037403840394040404140424043404440454046404740484049405040514052405340544055405640574058405940604061406240634064406540664067406840694070407140724073407440754076407740784079408040814082408340844085408640874088408940904091409240934094409540964097409840994100410141024103410441054106410741084109411041114112411341144115411641174118411941204121412241234124412541264127412841294130413141324133413441354136413741384139414041414142414341444145414641474148414941504151415241534154415541564157415841594160416141624163416441654166416741684169417041714172417341744175417641774178417941804181418241834184418541864187418841894190419141924193419441954196419741984199420042014202420342044205420642074208420942104211421242134214421542164217421842194220422142224223422442254226422742284229423042314232423342344235423642374238423942404241424242434244424542464247424842494250425142524253425442554256425742584259426042614262426342644265426642674268426942704271427242734274427542764277427842794280428142824283428442854286428742884289429042914292429342944295429642974298429943004301430243034304 
  1. <!DOCTYPE HTML>
    2. 

  2. <html>
    3. 

  3. 	<head>
    4. 

  4. 		<meta http-equiv="Content-Type" content="html/html; charset=utf-8" />
    5. 

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

  6. 		<meta id="xcode-display" name="xcode-display" content="render"/>
    7. 

  7. 		<meta name="viewport" content="width=550" />
    8. 

  8. 		<link rel="stylesheet" type="text/css" href="../css/styles.css" media="all" />
    9. 

  9. 		<link rel="stylesheet" type="text/css" media="print" href="../css/stylesPrint.css" />
    10. 

  10. 		<meta name="generator" content="appledoc 2.1 (build 858)" />
    11. 

  11. 	</head>
    12. 

  12. 	<body>
    13. 

  13. 		<header id="top_header">
    14. 

  14. 			<div id="library" class="hideInXcode">
    15. 

  15. 				<h1><a id="libraryTitle" href="../index.html">FMDB </a></h1>
    16. 

  16. 				<a id="developerHome" href="../index.html">ccgus</a>
    17. 

  17. 			</div>
    18. 

  18. 			
    19. 

  19. 			<div id="title" role="banner">
    20. 

  20. 				<h1 class="hideInXcode">FMDatabase Class Reference</h1>
    21. 

  21. 			</div>
    22. 

  22. 			<ul id="headerButtons" role="toolbar">
    23. 

  23. 				<li id="toc_button">
    24. 

  24. 					<button aria-label="Show Table of Contents" role="checkbox" class="open" id="table_of_contents"><span class="disclosure"></span>Table of Contents</button>
    25. 

  25. 				</li>
    26. 

  26. 				<li id="jumpto_button" role="navigation">
    27. 

  27. 					<select id="jumpTo">
    28. 

  28. 	<option value="top">Jump To&#133;</option>
    29. 

  29. 	
    30. 

  30. 	<option value="overview">Overview</option>
    31. 

  31. 	
    32. 

  32. 	
    33. 

  33. 	
    34. 

  34. 	
    35. 

  35. 	<option value="tasks">Tasks</option>
    36. 

  36. 	
    37. 

  37. 	
    38. 

  38. 	
    39. 

  39. 	
    40. 

  40. 	
    41. 

  41. 	<option value="properties">Properties</option>
    42. 

  42. 	
    43. 

  43. 	<option value="//api/name/busyRetryTimeout">&nbsp;&nbsp;&nbsp;&nbsp;busyRetryTimeout</option>
    44. 

  44. 	
    45. 

  45. 	<option value="//api/name/cachedStatements">&nbsp;&nbsp;&nbsp;&nbsp;cachedStatements</option>
    46. 

  46. 	
    47. 

  47. 	<option value="//api/name/checkedOut">&nbsp;&nbsp;&nbsp;&nbsp;checkedOut</option>
    48. 

  48. 	
    49. 

  49. 	<option value="//api/name/crashOnErrors">&nbsp;&nbsp;&nbsp;&nbsp;crashOnErrors</option>
    50. 

  50. 	
    51. 

  51. 	<option value="//api/name/logsErrors">&nbsp;&nbsp;&nbsp;&nbsp;logsErrors</option>
    52. 

  52. 	
    53. 

  53. 	<option value="//api/name/traceExecution">&nbsp;&nbsp;&nbsp;&nbsp;traceExecution</option>
    54. 

  54. 	
    55. 

  55. 	
    56. 

  56. 	
    57. 

  57. 	
    58. 

  58. 	<option value="class_methods">Class Methods</option>
    59. 

  59. 	
    60. 

  60. 	<option value="//api/name/databaseWithPath:">&nbsp;&nbsp;&nbsp;&nbsp;+ databaseWithPath:</option>
    61. 

  61. 	
    62. 

  62. 	<option value="//api/name/isSQLiteThreadSafe">&nbsp;&nbsp;&nbsp;&nbsp;+ isSQLiteThreadSafe</option>
    63. 

  63. 	
    64. 

  64. 	<option value="//api/name/sqliteLibVersion">&nbsp;&nbsp;&nbsp;&nbsp;+ sqliteLibVersion</option>
    65. 

  65. 	
    66. 

  66. 	<option value="//api/name/storeableDateFormat:">&nbsp;&nbsp;&nbsp;&nbsp;+ storeableDateFormat:</option>
    67. 

  67. 	
    68. 

  68. 	
    69. 

  69. 	
    70. 

  70. 	
    71. 

  71. 	<option value="instance_methods">Instance Methods</option>
    72. 

  72. 	
    73. 

  73. 	<option value="//api/name/beginDeferredTransaction">&nbsp;&nbsp;&nbsp;&nbsp;- beginDeferredTransaction</option>
    74. 

  74. 	
    75. 

  75. 	<option value="//api/name/beginTransaction">&nbsp;&nbsp;&nbsp;&nbsp;- beginTransaction</option>
    76. 

  76. 	
    77. 

  77. 	<option value="//api/name/changes">&nbsp;&nbsp;&nbsp;&nbsp;- changes</option>
    78. 

  78. 	
    79. 

  79. 	<option value="//api/name/clearCachedStatements">&nbsp;&nbsp;&nbsp;&nbsp;- clearCachedStatements</option>
    80. 

  80. 	
    81. 

  81. 	<option value="//api/name/close">&nbsp;&nbsp;&nbsp;&nbsp;- close</option>
    82. 

  82. 	
    83. 

  83. 	<option value="//api/name/closeOpenResultSets">&nbsp;&nbsp;&nbsp;&nbsp;- closeOpenResultSets</option>
    84. 

  84. 	
    85. 

  85. 	<option value="//api/name/commit">&nbsp;&nbsp;&nbsp;&nbsp;- commit</option>
    86. 

  86. 	
    87. 

  87. 	<option value="//api/name/databasePath">&nbsp;&nbsp;&nbsp;&nbsp;- databasePath</option>
    88. 

  88. 	
    89. 

  89. 	<option value="//api/name/dateFromString:">&nbsp;&nbsp;&nbsp;&nbsp;- dateFromString:</option>
    90. 

  90. 	
    91. 

  91. 	<option value="//api/name/executeQuery:">&nbsp;&nbsp;&nbsp;&nbsp;- executeQuery:</option>
    92. 

  92. 	
    93. 

  93. 	<option value="//api/name/executeQuery:withArgumentsInArray:">&nbsp;&nbsp;&nbsp;&nbsp;- executeQuery:withArgumentsInArray:</option>
    94. 

  94. 	
    95. 

  95. 	<option value="//api/name/executeQuery:withParameterDictionary:">&nbsp;&nbsp;&nbsp;&nbsp;- executeQuery:withParameterDictionary:</option>
    96. 

  96. 	
    97. 

  97. 	<option value="//api/name/executeQueryWithFormat:">&nbsp;&nbsp;&nbsp;&nbsp;- executeQueryWithFormat:</option>
    98. 

  98. 	
    99. 

  99. 	<option value="//api/name/executeUpdate:">&nbsp;&nbsp;&nbsp;&nbsp;- executeUpdate:</option>
    100. 

  100. 	
    101. 

  101. 	<option value="//api/name/executeUpdate:withArgumentsInArray:">&nbsp;&nbsp;&nbsp;&nbsp;- executeUpdate:withArgumentsInArray:</option>
    102. 

  102. 	
    103. 

  103. 	<option value="//api/name/executeUpdate:withParameterDictionary:">&nbsp;&nbsp;&nbsp;&nbsp;- executeUpdate:withParameterDictionary:</option>
    104. 

  104. 	
    105. 

  105. 	<option value="//api/name/executeUpdateWithFormat:">&nbsp;&nbsp;&nbsp;&nbsp;- executeUpdateWithFormat:</option>
    106. 

  106. 	
    107. 

  107. 	<option value="//api/name/goodConnection">&nbsp;&nbsp;&nbsp;&nbsp;- goodConnection</option>
    108. 

  108. 	
    109. 

  109. 	<option value="//api/name/hadError">&nbsp;&nbsp;&nbsp;&nbsp;- hadError</option>
    110. 

  110. 	
    111. 

  111. 	<option value="//api/name/hasDateFormatter">&nbsp;&nbsp;&nbsp;&nbsp;- hasDateFormatter</option>
    112. 

  112. 	
    113. 

  113. 	<option value="//api/name/hasOpenResultSets">&nbsp;&nbsp;&nbsp;&nbsp;- hasOpenResultSets</option>
    114. 

  114. 	
    115. 

  115. 	<option value="//api/name/inSavePoint:">&nbsp;&nbsp;&nbsp;&nbsp;- inSavePoint:</option>
    116. 

  116. 	
    117. 

  117. 	<option value="//api/name/inTransaction">&nbsp;&nbsp;&nbsp;&nbsp;- inTransaction</option>
    118. 

  118. 	
    119. 

  119. 	<option value="//api/name/initWithPath:">&nbsp;&nbsp;&nbsp;&nbsp;- initWithPath:</option>
    120. 

  120. 	
    121. 

  121. 	<option value="//api/name/lastError">&nbsp;&nbsp;&nbsp;&nbsp;- lastError</option>
    122. 

  122. 	
    123. 

  123. 	<option value="//api/name/lastErrorCode">&nbsp;&nbsp;&nbsp;&nbsp;- lastErrorCode</option>
    124. 

  124. 	
    125. 

  125. 	<option value="//api/name/lastErrorMessage">&nbsp;&nbsp;&nbsp;&nbsp;- lastErrorMessage</option>
    126. 

  126. 	
    127. 

  127. 	<option value="//api/name/lastInsertRowId">&nbsp;&nbsp;&nbsp;&nbsp;- lastInsertRowId</option>
    128. 

  128. 	
    129. 

  129. 	<option value="//api/name/makeFunctionNamed:maximumArguments:withBlock:">&nbsp;&nbsp;&nbsp;&nbsp;- makeFunctionNamed:maximumArguments:withBlock:</option>
    130. 

  130. 	
    131. 

  131. 	<option value="//api/name/open">&nbsp;&nbsp;&nbsp;&nbsp;- open</option>
    132. 

  132. 	
    133. 

  133. 	<option value="//api/name/openWithFlags:">&nbsp;&nbsp;&nbsp;&nbsp;- openWithFlags:</option>
    134. 

  134. 	
    135. 

  135. 	<option value="//api/name/rekey:">&nbsp;&nbsp;&nbsp;&nbsp;- rekey:</option>
    136. 

  136. 	
    137. 

  137. 	<option value="//api/name/rekeyWithData:">&nbsp;&nbsp;&nbsp;&nbsp;- rekeyWithData:</option>
    138. 

  138. 	
    139. 

  139. 	<option value="//api/name/releaseSavePointWithName:error:">&nbsp;&nbsp;&nbsp;&nbsp;- releaseSavePointWithName:error:</option>
    140. 

  140. 	
    141. 

  141. 	<option value="//api/name/rollback">&nbsp;&nbsp;&nbsp;&nbsp;- rollback</option>
    142. 

  142. 	
    143. 

  143. 	<option value="//api/name/rollbackToSavePointWithName:error:">&nbsp;&nbsp;&nbsp;&nbsp;- rollbackToSavePointWithName:error:</option>
    144. 

  144. 	
    145. 

  145. 	<option value="//api/name/setDateFormat:">&nbsp;&nbsp;&nbsp;&nbsp;- setDateFormat:</option>
    146. 

  146. 	
    147. 

  147. 	<option value="//api/name/setKey:">&nbsp;&nbsp;&nbsp;&nbsp;- setKey:</option>
    148. 

  148. 	
    149. 

  149. 	<option value="//api/name/setKeyWithData:">&nbsp;&nbsp;&nbsp;&nbsp;- setKeyWithData:</option>
    150. 

  150. 	
    151. 

  151. 	<option value="//api/name/setShouldCacheStatements:">&nbsp;&nbsp;&nbsp;&nbsp;- setShouldCacheStatements:</option>
    152. 

  152. 	
    153. 

  153. 	<option value="//api/name/shouldCacheStatements">&nbsp;&nbsp;&nbsp;&nbsp;- shouldCacheStatements</option>
    154. 

  154. 	
    155. 

  155. 	<option value="//api/name/sqliteHandle">&nbsp;&nbsp;&nbsp;&nbsp;- sqliteHandle</option>
    156. 

  156. 	
    157. 

  157. 	<option value="//api/name/startSavePointWithName:error:">&nbsp;&nbsp;&nbsp;&nbsp;- startSavePointWithName:error:</option>
    158. 

  158. 	
    159. 

  159. 	<option value="//api/name/stringFromDate:">&nbsp;&nbsp;&nbsp;&nbsp;- stringFromDate:</option>
    160. 

  160. 	
    161. 

  161. 	<option value="//api/name/update:withErrorAndBindings:">&nbsp;&nbsp;&nbsp;&nbsp;- update:withErrorAndBindings:</option>
    162. 

  162. 	
    163. 

  163. 	
    164. 

  164. 	
    165. 

  165. </select>
    166. 

  166. 				</li>
    167. 

  167. 			</ul>
    168. 

  168. 		</header>
    169. 

  169. 		<nav id="tocContainer" class="isShowingTOC">
    170. 

  170. 			<ul id="toc" role="tree">
    171. 

  171. 				
    172. 

  172. <li role="treeitem"><span class="nodisclosure"></span><span class="sectionName"><a href="#overview">Overview</a></span></li>
    173. 

  173. 

  174. 

  175. 

  176. 

  177. <li role="treeitem" id="task_treeitem"><span class="nodisclosure"></span><span class="sectionName"><a href="#tasks">Tasks</a></span><ul>
    178. 

  178. 	
    179. 

  179. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#task_Properties">Properties</a></span></li>
    180. 

  180. 	
    181. 

  181. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#task_Initialization">Initialization</a></span></li>
    182. 

  182. 	
    183. 

  183. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#task_Opening and closing database">Opening and closing database</a></span></li>
    184. 

  184. 	
    185. 

  185. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#task_Perform updates">Perform updates</a></span></li>
    186. 

  186. 	
    187. 

  187. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#task_Retrieving results">Retrieving results</a></span></li>
    188. 

  188. 	
    189. 

  189. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#task_Transactions">Transactions</a></span></li>
    190. 

  190. 	
    191. 

  191. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#task_Cached statements and result sets">Cached statements and result sets</a></span></li>
    192. 

  192. 	
    193. 

  193. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#task_Encryption methods">Encryption methods</a></span></li>
    194. 

  194. 	
    195. 

  195. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#task_General inquiry methods">General inquiry methods</a></span></li>
    196. 

  196. 	
    197. 

  197. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#task_Retrieving error codes">Retrieving error codes</a></span></li>
    198. 

  198. 	
    199. 

  199. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#task_Save points">Save points</a></span></li>
    200. 

  200. 	
    201. 

  201. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#task_SQLite library status">SQLite library status</a></span></li>
    202. 

  202. 	
    203. 

  203. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#task_Make SQL function">Make SQL function</a></span></li>
    204. 

  204. 	
    205. 

  205. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#task_Date formatter">Date formatter</a></span></li>
    206. 

  206. 	
    207. 

  207. </ul></li>
    208. 

  208. 

  209. 

  210. 

  211. 

  212. 

  213. <li role="treeitem" class="children"><span class="disclosure"></span><span class="sectionName"><a href="#properties">Properties</a></span><ul>
    214. 

  214. 	
    215. 

  215. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/busyRetryTimeout">busyRetryTimeout</a></span></li>
    216. 

  216. 	
    217. 

  217. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/cachedStatements">cachedStatements</a></span></li>
    218. 

  218. 	
    219. 

  219. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/checkedOut">checkedOut</a></span></li>
    220. 

  220. 	
    221. 

  221. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/crashOnErrors">crashOnErrors</a></span></li>
    222. 

  222. 	
    223. 

  223. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/logsErrors">logsErrors</a></span></li>
    224. 

  224. 	
    225. 

  225. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/traceExecution">traceExecution</a></span></li>
    226. 

  226. 	
    227. 

  227. </ul></li>
    228. 

  228. 

  229. 

  230. 

  231. <li role="treeitem" class="children"><span class="disclosure"></span><span class="sectionName"><a href="#class_methods">Class Methods</a></span><ul>
    232. 

  232. 	
    233. 

  233. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/databaseWithPath:">databaseWithPath:</a></span></li>
    234. 

  234. 	
    235. 

  235. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/isSQLiteThreadSafe">isSQLiteThreadSafe</a></span></li>
    236. 

  236. 	
    237. 

  237. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/sqliteLibVersion">sqliteLibVersion</a></span></li>
    238. 

  238. 	
    239. 

  239. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/storeableDateFormat:">storeableDateFormat:</a></span></li>
    240. 

  240. 	
    241. 

  241. </ul></li>
    242. 

  242. 

  243. 

  244. 

  245. <li role="treeitem" class="children"><span class="disclosure"></span><span class="sectionName"><a href="#instance_methods">Instance Methods</a></span><ul>
    246. 

  246. 	
    247. 

  247. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/beginDeferredTransaction">beginDeferredTransaction</a></span></li>
    248. 

  248. 	
    249. 

  249. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/beginTransaction">beginTransaction</a></span></li>
    250. 

  250. 	
    251. 

  251. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/changes">changes</a></span></li>
    252. 

  252. 	
    253. 

  253. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/clearCachedStatements">clearCachedStatements</a></span></li>
    254. 

  254. 	
    255. 

  255. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/close">close</a></span></li>
    256. 

  256. 	
    257. 

  257. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/closeOpenResultSets">closeOpenResultSets</a></span></li>
    258. 

  258. 	
    259. 

  259. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/commit">commit</a></span></li>
    260. 

  260. 	
    261. 

  261. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/databasePath">databasePath</a></span></li>
    262. 

  262. 	
    263. 

  263. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/dateFromString:">dateFromString:</a></span></li>
    264. 

  264. 	
    265. 

  265. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/executeQuery:">executeQuery:</a></span></li>
    266. 

  266. 	
    267. 

  267. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/executeQuery:withArgumentsInArray:">executeQuery:withArgumentsInArray:</a></span></li>
    268. 

  268. 	
    269. 

  269. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/executeQuery:withParameterDictionary:">executeQuery:withParameterDictionary:</a></span></li>
    270. 

  270. 	
    271. 

  271. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/executeQueryWithFormat:">executeQueryWithFormat:</a></span></li>
    272. 

  272. 	
    273. 

  273. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/executeUpdate:">executeUpdate:</a></span></li>
    274. 

  274. 	
    275. 

  275. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/executeUpdate:withArgumentsInArray:">executeUpdate:withArgumentsInArray:</a></span></li>
    276. 

  276. 	
    277. 

  277. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/executeUpdate:withParameterDictionary:">executeUpdate:withParameterDictionary:</a></span></li>
    278. 

  278. 	
    279. 

  279. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/executeUpdateWithFormat:">executeUpdateWithFormat:</a></span></li>
    280. 

  280. 	
    281. 

  281. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/goodConnection">goodConnection</a></span></li>
    282. 

  282. 	
    283. 

  283. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/hadError">hadError</a></span></li>
    284. 

  284. 	
    285. 

  285. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/hasDateFormatter">hasDateFormatter</a></span></li>
    286. 

  286. 	
    287. 

  287. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/hasOpenResultSets">hasOpenResultSets</a></span></li>
    288. 

  288. 	
    289. 

  289. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/inSavePoint:">inSavePoint:</a></span></li>
    290. 

  290. 	
    291. 

  291. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/inTransaction">inTransaction</a></span></li>
    292. 

  292. 	
    293. 

  293. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/initWithPath:">initWithPath:</a></span></li>
    294. 

  294. 	
    295. 

  295. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/lastError">lastError</a></span></li>
    296. 

  296. 	
    297. 

  297. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/lastErrorCode">lastErrorCode</a></span></li>
    298. 

  298. 	
    299. 

  299. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/lastErrorMessage">lastErrorMessage</a></span></li>
    300. 

  300. 	
    301. 

  301. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/lastInsertRowId">lastInsertRowId</a></span></li>
    302. 

  302. 	
    303. 

  303. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/makeFunctionNamed:maximumArguments:withBlock:">makeFunctionNamed:maximumArguments:withBlock:</a></span></li>
    304. 

  304. 	
    305. 

  305. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/open">open</a></span></li>
    306. 

  306. 	
    307. 

  307. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/openWithFlags:">openWithFlags:</a></span></li>
    308. 

  308. 	
    309. 

  309. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/rekey:">rekey:</a></span></li>
    310. 

  310. 	
    311. 

  311. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/rekeyWithData:">rekeyWithData:</a></span></li>
    312. 

  312. 	
    313. 

  313. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/releaseSavePointWithName:error:">releaseSavePointWithName:error:</a></span></li>
    314. 

  314. 	
    315. 

  315. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/rollback">rollback</a></span></li>
    316. 

  316. 	
    317. 

  317. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/rollbackToSavePointWithName:error:">rollbackToSavePointWithName:error:</a></span></li>
    318. 

  318. 	
    319. 

  319. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/setDateFormat:">setDateFormat:</a></span></li>
    320. 

  320. 	
    321. 

  321. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/setKey:">setKey:</a></span></li>
    322. 

  322. 	
    323. 

  323. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/setKeyWithData:">setKeyWithData:</a></span></li>
    324. 

  324. 	
    325. 

  325. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/setShouldCacheStatements:">setShouldCacheStatements:</a></span></li>
    326. 

  326. 	
    327. 

  327. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/shouldCacheStatements">shouldCacheStatements</a></span></li>
    328. 

  328. 	
    329. 

  329. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/sqliteHandle">sqliteHandle</a></span></li>
    330. 

  330. 	
    331. 

  331. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/startSavePointWithName:error:">startSavePointWithName:error:</a></span></li>
    332. 

  332. 	
    333. 

  333. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/stringFromDate:">stringFromDate:</a></span></li>
    334. 

  334. 	
    335. 

  335. 	<li><span class="nodisclosure"></span><span class="sectionName"><a href="#//api/name/update:withErrorAndBindings:">update:withErrorAndBindings:</a></span></li>
    336. 

  336. 	
    337. 

  337. </ul></li>
    338. 

  338. 

  339. 

  340. 			</ul>
    341. 

  341. 		</nav>
    342. 

  342. 		<article>
    343. 

  343. 			<div id="contents" class="isShowingTOC" role="main">
    344. 

  344. 				<a title="FMDatabase Class Reference" name="top"></a>
    345. 

  345. 				<div class="main-navigation navigation-top">
    346. 

  346. 					<ul>
    347. 

  347. 	<li><a href="../index.html">Index</a></li>
    348. 

  348. 	<li><a href="../hierarchy.html">Hierarchy</a></li>
    349. 

  349. </ul>
    350. 

  350. 				</div>
    351. 

  351. 				<div id="header">
    352. 

  352. 					<div class="section-header">
    353. 

  353. 						<h1 class="title title-header">FMDatabase Class Reference</h1>
    354. 

  354. 					</div>		
    355. 

  355. 				</div>
    356. 

  356. 				<div id="container">	
    357. 

  357. 					
    358. 

  358. 					<div class="section section-specification"><table cellspacing="0"><tbody>
    359. 

  359. 						<tr>
    360. 

  360. 	<td class="specification-title">Inherits from</td>
    361. 

  361. 	<td class="specification-value">NSObject</td>
    362. 

  362. </tr><tr>
    363. 

  363. 	<td class="specification-title">Declared in</td>
    364. 

  364. 	<td class="specification-value">FMDatabase.h<br />FMDatabase.m</td>
    365. 

  365. </tr>
    366. 

  366. 						</tbody></table></div>
    367. 

  367. 					
    368. 

  368. 					
    369. 

  369. 					
    370. 

  370. 					
    371. 

  371. 					<div class="section section-overview">
    372. 

  372. 						<a title="Overview" name="overview"></a>
    373. 

  373. 						<h2 class="subtitle subtitle-overview">Overview</h2>
    374. 

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

  375. 

  376. <h3>Usage</h3>
    377. 

  377. 

  378. <p>The three main classes in FMDB are:</p>
    379. 

  379. 

  380. <ul>
    381. 

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

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

  383. <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>
    384. 

  384. </ul>
    385. 

  385. 

  386. 

  387. <h3>See also</h3>
    388. 

  388. 

  389. <ul>
    390. 

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

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

  392. </ul>
    393. 

  393. 

  394. 

  395. <h3>External links</h3>
    396. 

  396. 

  397. <ul>
    398. 

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

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

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

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

  402. </ul>
    403. 

  403. <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>
    404. 

  404. 					</div>
    405. 

  405. 					
    406. 

  406. 					
    407. 

  407. 					
    408. 

  408. 					
    409. 

  409. 					
    410. 

  410. 					<div class="section section-tasks">
    411. 

  411. 						<a title="Tasks" name="tasks"></a>
    412. 

  412. 						<h2 class="subtitle subtitle-tasks">Tasks</h2>
    413. 

  413. 						
    414. 

  414. 						
    415. 

  415. 						<a title="Properties" name="task_Properties"></a>
    416. 

  416. 						<h3 class="subsubtitle task-title">Properties</h3>
    417. 

  417. 

  418. 						<ul class="task-list">
    419. 

  419. 							<li>
    420. 

  420. 	<span class="tooltip">
    421. 

  421. 		<code><a href="#//api/name/traceExecution">&nbsp;&nbsp;traceExecution</a></code>
    422. 

  422. 		<span class="tooltip"><p>Whether should trace execution</p></span>
    423. 

  423. 	</span>
    424. 

  424. 	<span class="task-item-suffix">property</span>
    425. 

  425. 	
    426. 

  426. </li><li>
    427. 

  427. 	<span class="tooltip">
    428. 

  428. 		<code><a href="#//api/name/checkedOut">&nbsp;&nbsp;checkedOut</a></code>
    429. 

  429. 		<span class="tooltip"><p>Whether checked out or not</p></span>
    430. 

  430. 	</span>
    431. 

  431. 	<span class="task-item-suffix">property</span>
    432. 

  432. 	
    433. 

  433. </li><li>
    434. 

  434. 	<span class="tooltip">
    435. 

  435. 		<code><a href="#//api/name/busyRetryTimeout">&nbsp;&nbsp;busyRetryTimeout</a></code>
    436. 

  436. 		<span class="tooltip"><p>Busy retry timeout</p></span>
    437. 

  437. 	</span>
    438. 

  438. 	<span class="task-item-suffix">property</span>
    439. 

  439. 	
    440. 

  440. </li><li>
    441. 

  441. 	<span class="tooltip">
    442. 

  442. 		<code><a href="#//api/name/crashOnErrors">&nbsp;&nbsp;crashOnErrors</a></code>
    443. 

  443. 		<span class="tooltip"><p>Crash on errors</p></span>
    444. 

  444. 	</span>
    445. 

  445. 	<span class="task-item-suffix">property</span>
    446. 

  446. 	
    447. 

  447. </li><li>
    448. 

  448. 	<span class="tooltip">
    449. 

  449. 		<code><a href="#//api/name/logsErrors">&nbsp;&nbsp;logsErrors</a></code>
    450. 

  450. 		<span class="tooltip"><p>Logs errors</p></span>
    451. 

  451. 	</span>
    452. 

  452. 	<span class="task-item-suffix">property</span>
    453. 

  453. 	
    454. 

  454. </li><li>
    455. 

  455. 	<span class="tooltip">
    456. 

  456. 		<code><a href="#//api/name/cachedStatements">&nbsp;&nbsp;cachedStatements</a></code>
    457. 

  457. 		<span class="tooltip"><p>Dictionary of cached statements</p></span>
    458. 

  458. 	</span>
    459. 

  459. 	<span class="task-item-suffix">property</span>
    460. 

  460. 	
    461. 

  461. </li>
    462. 

  462. 						</ul>
    463. 

  463. 						
    464. 

  464. 						
    465. 

  465. 						<a title="Initialization" name="task_Initialization"></a>
    466. 

  466. 						<h3 class="subsubtitle task-title">Initialization</h3>
    467. 

  467. 

  468. 						<ul class="task-list">
    469. 

  469. 							<li>
    470. 

  470. 	<span class="tooltip">
    471. 

  471. 		<code><a href="#//api/name/databaseWithPath:">+&nbsp;databaseWithPath:</a></code>
    472. 

  472. 		<span class="tooltip"><p>Create a <code>FMDatabase</code> object.</p></span>
    473. 

  473. 	</span>
    474. 

  474. 	
    475. 

  475. 	
    476. 

  476. </li><li>
    477. 

  477. 	<span class="tooltip">
    478. 

  478. 		<code><a href="#//api/name/initWithPath:">&ndash;&nbsp;initWithPath:</a></code>
    479. 

  479. 		<span class="tooltip"><p>Initialize a <code>FMDatabase</code> object.</p></span>
    480. 

  480. 	</span>
    481. 

  481. 	
    482. 

  482. 	
    483. 

  483. </li>
    484. 

  484. 						</ul>
    485. 

  485. 						
    486. 

  486. 						
    487. 

  487. 						<a title="Opening and closing database" name="task_Opening and closing database"></a>
    488. 

  488. 						<h3 class="subsubtitle task-title">Opening and closing database</h3>
    489. 

  489. 

  490. 						<ul class="task-list">
    491. 

  491. 							<li>
    492. 

  492. 	<span class="tooltip">
    493. 

  493. 		<code><a href="#//api/name/open">&ndash;&nbsp;open</a></code>
    494. 

  494. 		<span class="tooltip"><p>Opening a new database connection</p></span>
    495. 

  495. 	</span>
    496. 

  496. 	
    497. 

  497. 	
    498. 

  498. </li><li>
    499. 

  499. 	<span class="tooltip">
    500. 

  500. 		<code><a href="#//api/name/openWithFlags:">&ndash;&nbsp;openWithFlags:</a></code>
    501. 

  501. 		<span class="tooltip"><p>Opening a new database connection with flags</p></span>
    502. 

  502. 	</span>
    503. 

  503. 	
    504. 

  504. 	
    505. 

  505. </li><li>
    506. 

  506. 	<span class="tooltip">
    507. 

  507. 		<code><a href="#//api/name/close">&ndash;&nbsp;close</a></code>
    508. 

  508. 		<span class="tooltip"><p>Closing a database connection</p></span>
    509. 

  509. 	</span>
    510. 

  510. 	
    511. 

  511. 	
    512. 

  512. </li><li>
    513. 

  513. 	<span class="tooltip">
    514. 

  514. 		<code><a href="#//api/name/goodConnection">&ndash;&nbsp;goodConnection</a></code>
    515. 

  515. 		<span class="tooltip"><p>Test to see if we have a good connection to the database.</p></span>
    516. 

  516. 	</span>
    517. 

  517. 	
    518. 

  518. 	
    519. 

  519. </li>
    520. 

  520. 						</ul>
    521. 

  521. 						
    522. 

  522. 						
    523. 

  523. 						<a title="Perform updates" name="task_Perform updates"></a>
    524. 

  524. 						<h3 class="subsubtitle task-title">Perform updates</h3>
    525. 

  525. 

  526. 						<ul class="task-list">
    527. 

  527. 							<li>
    528. 

  528. 	<span class="tooltip">
    529. 

  529. 		<code><a href="#//api/name/update:withErrorAndBindings:">&ndash;&nbsp;update:withErrorAndBindings:</a></code>
    530. 

  530. 		<span class="tooltip"><p>Execute update statement</p></span>
    531. 

  531. 	</span>
    532. 

  532. 	
    533. 

  533. 	
    534. 

  534. </li><li>
    535. 

  535. 	<span class="tooltip">
    536. 

  536. 		<code><a href="#//api/name/executeUpdate:">&ndash;&nbsp;executeUpdate:</a></code>
    537. 

  537. 		<span class="tooltip"><p>Execute update statement</p></span>
    538. 

  538. 	</span>
    539. 

  539. 	
    540. 

  540. 	
    541. 

  541. </li><li>
    542. 

  542. 	<span class="tooltip">
    543. 

  543. 		<code><a href="#//api/name/executeUpdateWithFormat:">&ndash;&nbsp;executeUpdateWithFormat:</a></code>
    544. 

  544. 		<span class="tooltip"><p>Execute update statement</p></span>
    545. 

  545. 	</span>
    546. 

  546. 	
    547. 

  547. 	
    548. 

  548. </li><li>
    549. 

  549. 	<span class="tooltip">
    550. 

  550. 		<code><a href="#//api/name/executeUpdate:withArgumentsInArray:">&ndash;&nbsp;executeUpdate:withArgumentsInArray:</a></code>
    551. 

  551. 		<span class="tooltip"><p>Execute update statement</p></span>
    552. 

  552. 	</span>
    553. 

  553. 	
    554. 

  554. 	
    555. 

  555. </li><li>
    556. 

  556. 	<span class="tooltip">
    557. 

  557. 		<code><a href="#//api/name/executeUpdate:withParameterDictionary:">&ndash;&nbsp;executeUpdate:withParameterDictionary:</a></code>
    558. 

  558. 		<span class="tooltip"><p>Execute update statement</p></span>
    559. 

  559. 	</span>
    560. 

  560. 	
    561. 

  561. 	
    562. 

  562. </li><li>
    563. 

  563. 	<span class="tooltip">
    564. 

  564. 		<code><a href="#//api/name/lastInsertRowId">&ndash;&nbsp;lastInsertRowId</a></code>
    565. 

  565. 		<span class="tooltip"><p>Last insert rowid</p></span>
    566. 

  566. 	</span>
    567. 

  567. 	
    568. 

  568. 	
    569. 

  569. </li><li>
    570. 

  570. 	<span class="tooltip">
    571. 

  571. 		<code><a href="#//api/name/changes">&ndash;&nbsp;changes</a></code>
    572. 

  572. 		<span class="tooltip"><p>The number of rows changed by prior SQL statement.</p></span>
    573. 

  573. 	</span>
    574. 

  574. 	
    575. 

  575. 	
    576. 

  576. </li>
    577. 

  577. 						</ul>
    578. 

  578. 						
    579. 

  579. 						
    580. 

  580. 						<a title="Retrieving results" name="task_Retrieving results"></a>
    581. 

  581. 						<h3 class="subsubtitle task-title">Retrieving results</h3>
    582. 

  582. 

  583. 						<ul class="task-list">
    584. 

  584. 							<li>
    585. 

  585. 	<span class="tooltip">
    586. 

  586. 		<code><a href="#//api/name/executeQuery:">&ndash;&nbsp;executeQuery:</a></code>
    587. 

  587. 		<span class="tooltip"><p>Execute select statement</p></span>
    588. 

  588. 	</span>
    589. 

  589. 	
    590. 

  590. 	
    591. 

  591. </li><li>
    592. 

  592. 	<span class="tooltip">
    593. 

  593. 		<code><a href="#//api/name/executeQueryWithFormat:">&ndash;&nbsp;executeQueryWithFormat:</a></code>
    594. 

  594. 		<span class="tooltip"><p>Execute select statement</p></span>
    595. 

  595. 	</span>
    596. 

  596. 	
    597. 

  597. 	
    598. 

  598. </li><li>
    599. 

  599. 	<span class="tooltip">
    600. 

  600. 		<code><a href="#//api/name/executeQuery:withArgumentsInArray:">&ndash;&nbsp;executeQuery:withArgumentsInArray:</a></code>
    601. 

  601. 		<span class="tooltip"><p>Execute select statement</p></span>
    602. 

  602. 	</span>
    603. 

  603. 	
    604. 

  604. 	
    605. 

  605. </li><li>
    606. 

  606. 	<span class="tooltip">
    607. 

  607. 		<code><a href="#//api/name/executeQuery:withParameterDictionary:">&ndash;&nbsp;executeQuery:withParameterDictionary:</a></code>
    608. 

  608. 		<span class="tooltip"><p>Execute select statement</p></span>
    609. 

  609. 	</span>
    610. 

  610. 	
    611. 

  611. 	
    612. 

  612. </li>
    613. 

  613. 						</ul>
    614. 

  614. 						
    615. 

  615. 						
    616. 

  616. 						<a title="Transactions" name="task_Transactions"></a>
    617. 

  617. 						<h3 class="subsubtitle task-title">Transactions</h3>
    618. 

  618. 

  619. 						<ul class="task-list">
    620. 

  620. 							<li>
    621. 

  621. 	<span class="tooltip">
    622. 

  622. 		<code><a href="#//api/name/beginTransaction">&ndash;&nbsp;beginTransaction</a></code>
    623. 

  623. 		<span class="tooltip"><p>Begin a transaction</p></span>
    624. 

  624. 	</span>
    625. 

  625. 	
    626. 

  626. 	
    627. 

  627. </li><li>
    628. 

  628. 	<span class="tooltip">
    629. 

  629. 		<code><a href="#//api/name/beginDeferredTransaction">&ndash;&nbsp;beginDeferredTransaction</a></code>
    630. 

  630. 		<span class="tooltip"><p>Begin a deferred transaction</p></span>
    631. 

  631. 	</span>
    632. 

  632. 	
    633. 

  633. 	
    634. 

  634. </li><li>
    635. 

  635. 	<span class="tooltip">
    636. 

  636. 		<code><a href="#//api/name/commit">&ndash;&nbsp;commit</a></code>
    637. 

  637. 		<span class="tooltip"><p>Commit a transaction</p></span>
    638. 

  638. 	</span>
    639. 

  639. 	
    640. 

  640. 	
    641. 

  641. </li><li>
    642. 

  642. 	<span class="tooltip">
    643. 

  643. 		<code><a href="#//api/name/rollback">&ndash;&nbsp;rollback</a></code>
    644. 

  644. 		<span class="tooltip"><p>Rollback a transaction</p></span>
    645. 

  645. 	</span>
    646. 

  646. 	
    647. 

  647. 	
    648. 

  648. </li><li>
    649. 

  649. 	<span class="tooltip">
    650. 

  650. 		<code><a href="#//api/name/inTransaction">&ndash;&nbsp;inTransaction</a></code>
    651. 

  651. 		<span class="tooltip"><p>Identify whether currently in a transaction or not</p></span>
    652. 

  652. 	</span>
    653. 

  653. 	
    654. 

  654. 	
    655. 

  655. </li>
    656. 

  656. 						</ul>
    657. 

  657. 						
    658. 

  658. 						
    659. 

  659. 						<a title="Cached statements and result sets" name="task_Cached statements and result sets"></a>
    660. 

  660. 						<h3 class="subsubtitle task-title">Cached statements and result sets</h3>
    661. 

  661. 

  662. 						<ul class="task-list">
    663. 

  663. 							<li>
    664. 

  664. 	<span class="tooltip">
    665. 

  665. 		<code><a href="#//api/name/clearCachedStatements">&ndash;&nbsp;clearCachedStatements</a></code>
    666. 

  666. 		<span class="tooltip"><p>Clear cached statements</p></span>
    667. 

  667. 	</span>
    668. 

  668. 	
    669. 

  669. 	
    670. 

  670. </li><li>
    671. 

  671. 	<span class="tooltip">
    672. 

  672. 		<code><a href="#//api/name/closeOpenResultSets">&ndash;&nbsp;closeOpenResultSets</a></code>
    673. 

  673. 		<span class="tooltip"><p>Close all open result sets</p></span>
    674. 

  674. 	</span>
    675. 

  675. 	
    676. 

  676. 	
    677. 

  677. </li><li>
    678. 

  678. 	<span class="tooltip">
    679. 

  679. 		<code><a href="#//api/name/hasOpenResultSets">&ndash;&nbsp;hasOpenResultSets</a></code>
    680. 

  680. 		<span class="tooltip"><p>Whether database has any open result sets</p></span>
    681. 

  681. 	</span>
    682. 

  682. 	
    683. 

  683. 	
    684. 

  684. </li><li>
    685. 

  685. 	<span class="tooltip">
    686. 

  686. 		<code><a href="#//api/name/shouldCacheStatements">&ndash;&nbsp;shouldCacheStatements</a></code>
    687. 

  687. 		<span class="tooltip"><p>Return whether should cache statements or not</p></span>
    688. 

  688. 	</span>
    689. 

  689. 	
    690. 

  690. 	
    691. 

  691. </li><li>
    692. 

  692. 	<span class="tooltip">
    693. 

  693. 		<code><a href="#//api/name/setShouldCacheStatements:">&ndash;&nbsp;setShouldCacheStatements:</a></code>
    694. 

  694. 		<span class="tooltip"><p>Set whether should cache statements or not</p></span>
    695. 

  695. 	</span>
    696. 

  696. 	
    697. 

  697. 	
    698. 

  698. </li>
    699. 

  699. 						</ul>
    700. 

  700. 						
    701. 

  701. 						
    702. 

  702. 						<a title="Encryption methods" name="task_Encryption methods"></a>
    703. 

  703. 						<h3 class="subsubtitle task-title">Encryption methods</h3>
    704. 

  704. 

  705. 						<ul class="task-list">
    706. 

  706. 							<li>
    707. 

  707. 	<span class="tooltip">
    708. 

  708. 		<code><a href="#//api/name/setKey:">&ndash;&nbsp;setKey:</a></code>
    709. 

  709. 		<span class="tooltip"><p>Set encryption key.</p></span>
    710. 

  710. 	</span>
    711. 

  711. 	
    712. 

  712. 	
    713. 

  713. </li><li>
    714. 

  714. 	<span class="tooltip">
    715. 

  715. 		<code><a href="#//api/name/rekey:">&ndash;&nbsp;rekey:</a></code>
    716. 

  716. 		<span class="tooltip"><p>Reset encryption key</p></span>
    717. 

  717. 	</span>
    718. 

  718. 	
    719. 

  719. 	
    720. 

  720. </li><li>
    721. 

  721. 	<span class="tooltip">
    722. 

  722. 		<code><a href="#//api/name/setKeyWithData:">&ndash;&nbsp;setKeyWithData:</a></code>
    723. 

  723. 		<span class="tooltip"><p>Set encryption key using <code>keyData</code>.</p></span>
    724. 

  724. 	</span>
    725. 

  725. 	
    726. 

  726. 	
    727. 

  727. </li><li>
    728. 

  728. 	<span class="tooltip">
    729. 

  729. 		<code><a href="#//api/name/rekeyWithData:">&ndash;&nbsp;rekeyWithData:</a></code>
    730. 

  730. 		<span class="tooltip"><p>Reset encryption key using <code>keyData</code>.</p></span>
    731. 

  731. 	</span>
    732. 

  732. 	
    733. 

  733. 	
    734. 

  734. </li>
    735. 

  735. 						</ul>
    736. 

  736. 						
    737. 

  737. 						
    738. 

  738. 						<a title="General inquiry methods" name="task_General inquiry methods"></a>
    739. 

  739. 						<h3 class="subsubtitle task-title">General inquiry methods</h3>
    740. 

  740. 

  741. 						<ul class="task-list">
    742. 

  742. 							<li>
    743. 

  743. 	<span class="tooltip">
    744. 

  744. 		<code><a href="#//api/name/databasePath">&ndash;&nbsp;databasePath</a></code>
    745. 

  745. 		<span class="tooltip"><p>The path of the database file</p></span>
    746. 

  746. 	</span>
    747. 

  747. 	
    748. 

  748. 	
    749. 

  749. </li><li>
    750. 

  750. 	<span class="tooltip">
    751. 

  751. 		<code><a href="#//api/name/sqliteHandle">&ndash;&nbsp;sqliteHandle</a></code>
    752. 

  752. 		<span class="tooltip"><p>The underlying SQLite handle</p></span>
    753. 

  753. 	</span>
    754. 

  754. 	
    755. 

  755. 	
    756. 

  756. </li>
    757. 

  757. 						</ul>
    758. 

  758. 						
    759. 

  759. 						
    760. 

  760. 						<a title="Retrieving error codes" name="task_Retrieving error codes"></a>
    761. 

  761. 						<h3 class="subsubtitle task-title">Retrieving error codes</h3>
    762. 

  762. 

  763. 						<ul class="task-list">
    764. 

  764. 							<li>
    765. 

  765. 	<span class="tooltip">
    766. 

  766. 		<code><a href="#//api/name/lastErrorMessage">&ndash;&nbsp;lastErrorMessage</a></code>
    767. 

  767. 		<span class="tooltip"><p>Last error message</p></span>
    768. 

  768. 	</span>
    769. 

  769. 	
    770. 

  770. 	
    771. 

  771. </li><li>
    772. 

  772. 	<span class="tooltip">
    773. 

  773. 		<code><a href="#//api/name/lastErrorCode">&ndash;&nbsp;lastErrorCode</a></code>
    774. 

  774. 		<span class="tooltip"><p>Last error code</p></span>
    775. 

  775. 	</span>
    776. 

  776. 	
    777. 

  777. 	
    778. 

  778. </li><li>
    779. 

  779. 	<span class="tooltip">
    780. 

  780. 		<code><a href="#//api/name/hadError">&ndash;&nbsp;hadError</a></code>
    781. 

  781. 		<span class="tooltip"><p>Had error</p></span>
    782. 

  782. 	</span>
    783. 

  783. 	
    784. 

  784. 	
    785. 

  785. </li><li>
    786. 

  786. 	<span class="tooltip">
    787. 

  787. 		<code><a href="#//api/name/lastError">&ndash;&nbsp;lastError</a></code>
    788. 

  788. 		<span class="tooltip"><p>Last error</p></span>
    789. 

  789. 	</span>
    790. 

  790. 	
    791. 

  791. 	
    792. 

  792. </li>
    793. 

  793. 						</ul>
    794. 

  794. 						
    795. 

  795. 						
    796. 

  796. 						<a title="Save points" name="task_Save points"></a>
    797. 

  797. 						<h3 class="subsubtitle task-title">Save points</h3>
    798. 

  798. 

  799. 						<ul class="task-list">
    800. 

  800. 							<li>
    801. 

  801. 	<span class="tooltip">
    802. 

  802. 		<code><a href="#//api/name/startSavePointWithName:error:">&ndash;&nbsp;startSavePointWithName:error:</a></code>
    803. 

  803. 		<span class="tooltip"><p>Start save point</p></span>
    804. 

  804. 	</span>
    805. 

  805. 	
    806. 

  806. 	
    807. 

  807. </li><li>
    808. 

  808. 	<span class="tooltip">
    809. 

  809. 		<code><a href="#//api/name/releaseSavePointWithName:error:">&ndash;&nbsp;releaseSavePointWithName:error:</a></code>
    810. 

  810. 		<span class="tooltip"><p>Release save point</p></span>
    811. 

  811. 	</span>
    812. 

  812. 	
    813. 

  813. 	
    814. 

  814. </li><li>
    815. 

  815. 	<span class="tooltip">
    816. 

  816. 		<code><a href="#//api/name/rollbackToSavePointWithName:error:">&ndash;&nbsp;rollbackToSavePointWithName:error:</a></code>
    817. 

  817. 		<span class="tooltip"><p>Roll back to save point</p></span>
    818. 

  818. 	</span>
    819. 

  819. 	
    820. 

  820. 	
    821. 

  821. </li><li>
    822. 

  822. 	<span class="tooltip">
    823. 

  823. 		<code><a href="#//api/name/inSavePoint:">&ndash;&nbsp;inSavePoint:</a></code>
    824. 

  824. 		<span class="tooltip"><p>Start save point</p></span>
    825. 

  825. 	</span>
    826. 

  826. 	
    827. 

  827. 	
    828. 

  828. </li>
    829. 

  829. 						</ul>
    830. 

  830. 						
    831. 

  831. 						
    832. 

  832. 						<a title="SQLite library status" name="task_SQLite library status"></a>
    833. 

  833. 						<h3 class="subsubtitle task-title">SQLite library status</h3>
    834. 

  834. 

  835. 						<ul class="task-list">
    836. 

  836. 							<li>
    837. 

  837. 	<span class="tooltip">
    838. 

  838. 		<code><a href="#//api/name/isSQLiteThreadSafe">+&nbsp;isSQLiteThreadSafe</a></code>
    839. 

  839. 		<span class="tooltip"><p>Test to see if the library is threadsafe</p></span>
    840. 

  840. 	</span>
    841. 

  841. 	
    842. 

  842. 	
    843. 

  843. </li><li>
    844. 

  844. 	<span class="tooltip">
    845. 

  845. 		<code><a href="#//api/name/sqliteLibVersion">+&nbsp;sqliteLibVersion</a></code>
    846. 

  846. 		<span class="tooltip"><p>Run-time library version numbers</p></span>
    847. 

  847. 	</span>
    848. 

  848. 	
    849. 

  849. 	
    850. 

  850. </li>
    851. 

  851. 						</ul>
    852. 

  852. 						
    853. 

  853. 						
    854. 

  854. 						<a title="Make SQL function" name="task_Make SQL function"></a>
    855. 

  855. 						<h3 class="subsubtitle task-title">Make SQL function</h3>
    856. 

  856. 

  857. 						<ul class="task-list">
    858. 

  858. 							<li>
    859. 

  859. 	<span class="tooltip">
    860. 

  860. 		<code><a href="#//api/name/makeFunctionNamed:maximumArguments:withBlock:">&ndash;&nbsp;makeFunctionNamed:maximumArguments:withBlock:</a></code>
    861. 

  861. 		<span class="tooltip"><p>Adds SQL functions or aggregates or to redefine the behavior of existing SQL functions or aggregates.</p></span>
    862. 

  862. 	</span>
    863. 

  863. 	
    864. 

  864. 	
    865. 

  865. </li>
    866. 

  866. 						</ul>
    867. 

  867. 						
    868. 

  868. 						
    869. 

  869. 						<a title="Date formatter" name="task_Date formatter"></a>
    870. 

  870. 						<h3 class="subsubtitle task-title">Date formatter</h3>
    871. 

  871. 

  872. 						<ul class="task-list">
    873. 

  873. 							<li>
    874. 

  874. 	<span class="tooltip">
    875. 

  875. 		<code><a href="#//api/name/storeableDateFormat:">+&nbsp;storeableDateFormat:</a></code>
    876. 

  876. 		<span class="tooltip"><p>Generate an <code>NSDateFormatter</code> that won&rsquo;t be broken by permutations of timezones or locales.</p></span>
    877. 

  877. 	</span>
    878. 

  878. 	
    879. 

  879. 	
    880. 

  880. </li><li>
    881. 

  881. 	<span class="tooltip">
    882. 

  882. 		<code><a href="#//api/name/hasDateFormatter">&ndash;&nbsp;hasDateFormatter</a></code>
    883. 

  883. 		<span class="tooltip"><p>Test whether the database has a date formatter assigned.</p></span>
    884. 

  884. 	</span>
    885. 

  885. 	
    886. 

  886. 	
    887. 

  887. </li><li>
    888. 

  888. 	<span class="tooltip">
    889. 

  889. 		<code><a href="#//api/name/setDateFormat:">&ndash;&nbsp;setDateFormat:</a></code>
    890. 

  890. 		<span class="tooltip"><p>Set to a date formatter to use string dates with sqlite instead of the default UNIX timestamps.</p></span>
    891. 

  891. 	</span>
    892. 

  892. 	
    893. 

  893. 	
    894. 

  894. </li><li>
    895. 

  895. 	<span class="tooltip">
    896. 

  896. 		<code><a href="#//api/name/dateFromString:">&ndash;&nbsp;dateFromString:</a></code>
    897. 

  897. 		<span class="tooltip"><p>Convert the supplied NSString to NSDate, using the current database formatter.</p></span>
    898. 

  898. 	</span>
    899. 

  899. 	
    900. 

  900. 	
    901. 

  901. </li><li>
    902. 

  902. 	<span class="tooltip">
    903. 

  903. 		<code><a href="#//api/name/stringFromDate:">&ndash;&nbsp;stringFromDate:</a></code>
    904. 

  904. 		<span class="tooltip"><p>Convert the supplied NSDate to NSString, using the current database formatter.</p></span>
    905. 

  905. 	</span>
    906. 

  906. 	
    907. 

  907. 	
    908. 

  908. </li>
    909. 

  909. 						</ul>
    910. 

  910. 						
    911. 

  911. 					</div>
    912. 

  912. 					
    913. 

  913. 					
    914. 

  914. 					
    915. 

  915. 					
    916. 

  916. 					
    917. 

  917. 					<div class="section section-methods">
    918. 

  918. 						<a title="Properties" name="properties"></a>
    919. 

  919. 						<h2 class="subtitle subtitle-methods">Properties</h2>
    920. 

  920. 						
    921. 

  921. 						<div class="section-method">
    922. 

  922. 	<a name="//api/name/busyRetryTimeout" title="busyRetryTimeout"></a>
    923. 

  923. 	<h3 class="subsubtitle method-title">busyRetryTimeout</h3>
    924. 

  924. 	
    925. 

  925. 	
    926. 

  926. 	
    927. 

  927. 	<div class="method-subsection brief-description">
    928. 

  928. 		<p>Busy retry timeout</p>
    929. 

  929. 	</div>		
    930. 

  930. 	
    931. 

  931.     
    932. 

  932. 

  933. 	<div class="method-subsection method-declaration"><code>@property (atomic, assign) int busyRetryTimeout</code></div>
    934. 

  934. 

  935.     
    936. 

  936. 	
    937. 

  937. 	
    938. 

  938. 	
    939. 

  939. 	
    940. 

  940. 	
    941. 

  941. 	
    942. 

  942. 	
    943. 

  943. 	
    944. 

  944. 	
    945. 

  945. 	
    946. 

  946. 	
    947. 

  947. 	
    948. 

  948. 	
    949. 

  949. 	<div class="method-subsection declared-in-section">
    950. 

  950. 		<h4 class="method-subtitle">Declared In</h4>
    951. 

  951. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    952. 

  952. 	</div>				
    953. 

  953. 	
    954. 

  954. 	
    955. 

  955. </div>
    956. 

  956. 						
    957. 

  957. 						<div class="section-method">
    958. 

  958. 	<a name="//api/name/cachedStatements" title="cachedStatements"></a>
    959. 

  959. 	<h3 class="subsubtitle method-title">cachedStatements</h3>
    960. 

  960. 	
    961. 

  961. 	
    962. 

  962. 	
    963. 

  963. 	<div class="method-subsection brief-description">
    964. 

  964. 		<p>Dictionary of cached statements</p>
    965. 

  965. 	</div>		
    966. 

  966. 	
    967. 

  967.     
    968. 

  968. 

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

  970. 

  971.     
    972. 

  972. 	
    973. 

  973. 	
    974. 

  974. 	
    975. 

  975. 	
    976. 

  976. 	
    977. 

  977. 	
    978. 

  978. 	
    979. 

  979. 	
    980. 

  980. 	
    981. 

  981. 	
    982. 

  982. 	
    983. 

  983. 	
    984. 

  984. 	
    985. 

  985. 	<div class="method-subsection declared-in-section">
    986. 

  986. 		<h4 class="method-subtitle">Declared In</h4>
    987. 

  987. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    988. 

  988. 	</div>				
    989. 

  989. 	
    990. 

  990. 	
    991. 

  991. </div>
    992. 

  992. 						
    993. 

  993. 						<div class="section-method">
    994. 

  994. 	<a name="//api/name/checkedOut" title="checkedOut"></a>
    995. 

  995. 	<h3 class="subsubtitle method-title">checkedOut</h3>
    996. 

  996. 	
    997. 

  997. 	
    998. 

  998. 	
    999. 

  999. 	<div class="method-subsection brief-description">
    1000. 

  1000. 		<p>Whether checked out or not</p>
    1001. 

  1001. 	</div>		
    1002. 

  1002. 	
    1003. 

  1003.     
    1004. 

  1004. 

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

  1006. 

  1007.     
    1008. 

  1008. 	
    1009. 

  1009. 	
    1010. 

  1010. 	
    1011. 

  1011. 	
    1012. 

  1012. 	
    1013. 

  1013. 	
    1014. 

  1014. 	
    1015. 

  1015. 	
    1016. 

  1016. 	
    1017. 

  1017. 	
    1018. 

  1018. 	
    1019. 

  1019. 	
    1020. 

  1020. 	
    1021. 

  1021. 	<div class="method-subsection declared-in-section">
    1022. 

  1022. 		<h4 class="method-subtitle">Declared In</h4>
    1023. 

  1023. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    1024. 

  1024. 	</div>				
    1025. 

  1025. 	
    1026. 

  1026. 	
    1027. 

  1027. </div>
    1028. 

  1028. 						
    1029. 

  1029. 						<div class="section-method">
    1030. 

  1030. 	<a name="//api/name/crashOnErrors" title="crashOnErrors"></a>
    1031. 

  1031. 	<h3 class="subsubtitle method-title">crashOnErrors</h3>
    1032. 

  1032. 	
    1033. 

  1033. 	
    1034. 

  1034. 	
    1035. 

  1035. 	<div class="method-subsection brief-description">
    1036. 

  1036. 		<p>Crash on errors</p>
    1037. 

  1037. 	</div>		
    1038. 

  1038. 	
    1039. 

  1039.     
    1040. 

  1040. 

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

  1042. 

  1043.     
    1044. 

  1044. 	
    1045. 

  1045. 	
    1046. 

  1046. 	
    1047. 

  1047. 	
    1048. 

  1048. 	
    1049. 

  1049. 	
    1050. 

  1050. 	
    1051. 

  1051. 	
    1052. 

  1052. 	
    1053. 

  1053. 	
    1054. 

  1054. 	
    1055. 

  1055. 	
    1056. 

  1056. 	
    1057. 

  1057. 	<div class="method-subsection declared-in-section">
    1058. 

  1058. 		<h4 class="method-subtitle">Declared In</h4>
    1059. 

  1059. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    1060. 

  1060. 	</div>				
    1061. 

  1061. 	
    1062. 

  1062. 	
    1063. 

  1063. </div>
    1064. 

  1064. 						
    1065. 

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

  1066. 	<a name="//api/name/logsErrors" title="logsErrors"></a>
    1067. 

  1067. 	<h3 class="subsubtitle method-title">logsErrors</h3>
    1068. 

  1068. 	
    1069. 

  1069. 	
    1070. 

  1070. 	
    1071. 

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

  1072. 		<p>Logs errors</p>
    1073. 

  1073. 	</div>		
    1074. 

  1074. 	
    1075. 

  1075.     
    1076. 

  1076. 

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

  1078. 

  1079.     
    1080. 

  1080. 	
    1081. 

  1081. 	
    1082. 

  1082. 	
    1083. 

  1083. 	
    1084. 

  1084. 	
    1085. 

  1085. 	
    1086. 

  1086. 	
    1087. 

  1087. 	
    1088. 

  1088. 	
    1089. 

  1089. 	
    1090. 

  1090. 	
    1091. 

  1091. 	
    1092. 

  1092. 	
    1093. 

  1093. 	<div class="method-subsection declared-in-section">
    1094. 

  1094. 		<h4 class="method-subtitle">Declared In</h4>
    1095. 

  1095. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    1096. 

  1096. 	</div>				
    1097. 

  1097. 	
    1098. 

  1098. 	
    1099. 

  1099. </div>
    1100. 

  1100. 						
    1101. 

  1101. 						<div class="section-method">
    1102. 

  1102. 	<a name="//api/name/traceExecution" title="traceExecution"></a>
    1103. 

  1103. 	<h3 class="subsubtitle method-title">traceExecution</h3>
    1104. 

  1104. 	
    1105. 

  1105. 	
    1106. 

  1106. 	
    1107. 

  1107. 	<div class="method-subsection brief-description">
    1108. 

  1108. 		<p>Whether should trace execution</p>
    1109. 

  1109. 	</div>		
    1110. 

  1110. 	
    1111. 

  1111.     
    1112. 

  1112. 

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

  1114. 

  1115.     
    1116. 

  1116. 	
    1117. 

  1117. 	
    1118. 

  1118. 	
    1119. 

  1119. 	
    1120. 

  1120. 	
    1121. 

  1121. 	
    1122. 

  1122. 	
    1123. 

  1123. 	
    1124. 

  1124. 	
    1125. 

  1125. 	
    1126. 

  1126. 	
    1127. 

  1127. 	
    1128. 

  1128. 	
    1129. 

  1129. 	<div class="method-subsection declared-in-section">
    1130. 

  1130. 		<h4 class="method-subtitle">Declared In</h4>
    1131. 

  1131. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    1132. 

  1132. 	</div>				
    1133. 

  1133. 	
    1134. 

  1134. 	
    1135. 

  1135. </div>
    1136. 

  1136. 						
    1137. 

  1137. 					</div>
    1138. 

  1138. 					
    1139. 

  1139. 					
    1140. 

  1140. 					
    1141. 

  1141. 					<div class="section section-methods">
    1142. 

  1142. 						<a title="Class Methods" name="class_methods"></a>
    1143. 

  1143. 						<h2 class="subtitle subtitle-methods">Class Methods</h2>
    1144. 

  1144. 						
    1145. 

  1145. 						<div class="section-method">
    1146. 

  1146. 	<a name="//api/name/databaseWithPath:" title="databaseWithPath:"></a>
    1147. 

  1147. 	<h3 class="subsubtitle method-title">databaseWithPath:</h3>
    1148. 

  1148. 	
    1149. 

  1149. 	
    1150. 

  1150. 	
    1151. 

  1151. 	<div class="method-subsection brief-description">
    1152. 

  1152. 		<p>Create a <code>FMDatabase</code> object.</p>
    1153. 

  1153. 	</div>		
    1154. 

  1154. 	
    1155. 

  1155.     
    1156. 

  1156. 

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

  1158. 

  1159.     
    1160. 

  1160. 	
    1161. 

  1161. 	<div class="method-subsection arguments-section parameters">
    1162. 

  1162. 		<h4 class="method-subtitle parameter-title">Parameters</h4>
    1163. 

  1163. 		
    1164. 

  1164. 		<dl class="argument-def parameter-def">
    1165. 

  1165. 			<dt><em>inPath</em></dt>
    1166. 

  1166. 			<dd><p>Path of database file</p></dd>
    1167. 

  1167. 		</dl>
    1168. 

  1168. 		
    1169. 

  1169. 	</div>
    1170. 

  1170. 	
    1171. 

  1171. 	
    1172. 

  1172. 	
    1173. 

  1173. 	<div class="method-subsection return">
    1174. 

  1174. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    1175. 

  1175. 		<p><code>FMDatabase</code> object if successful; <code>nil</code> if failure.</p>
    1176. 

  1176. 	</div>
    1177. 

  1177. 	
    1178. 

  1178. 	
    1179. 

  1179. 	
    1180. 

  1180. 	
    1181. 

  1181. 	
    1182. 

  1182. 	<div class="method-subsection discussion-section">
    1183. 

  1183. 		<h4 class="method-subtitle">Discussion</h4>
    1184. 

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

  1185. 

  1186. <ol>
    1187. 

  1187. <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>
    1188. 

  1188. <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>
    1189. 

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

  1190. </ol>
    1191. 

  1191. 

  1192. 

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

  1194. 

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

  1196. </code></pre>
    1197. 

  1197. 

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

  1199. 

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

  1201. NSString *dbPath   = [docsPath stringByAppendingPathComponent:@"test.db"];
    1202. 

  1202. FMDatabase *db     = [FMDatabase databaseWithPath:dbPath];
    1203. 

  1203. </code></pre>
    1204. 

  1204. 

  1205. <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>
    1206. 

  1206. 	</div>
    1207. 

  1207. 	
    1208. 

  1208. 	
    1209. 

  1209. 	
    1210. 

  1210. 	
    1211. 

  1211. 	
    1212. 

  1212. 	
    1213. 

  1213. 	
    1214. 

  1214. 	<div class="method-subsection declared-in-section">
    1215. 

  1215. 		<h4 class="method-subtitle">Declared In</h4>
    1216. 

  1216. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    1217. 

  1217. 	</div>				
    1218. 

  1218. 	
    1219. 

  1219. 	
    1220. 

  1220. </div>
    1221. 

  1221. 						
    1222. 

  1222. 						<div class="section-method">
    1223. 

  1223. 	<a name="//api/name/isSQLiteThreadSafe" title="isSQLiteThreadSafe"></a>
    1224. 

  1224. 	<h3 class="subsubtitle method-title">isSQLiteThreadSafe</h3>
    1225. 

  1225. 	
    1226. 

  1226. 	
    1227. 

  1227. 	
    1228. 

  1228. 	<div class="method-subsection brief-description">
    1229. 

  1229. 		<p>Test to see if the library is threadsafe</p>
    1230. 

  1230. 	</div>		
    1231. 

  1231. 	
    1232. 

  1232.     
    1233. 

  1233. 

  1234. 	<div class="method-subsection method-declaration"><code>+ (BOOL)isSQLiteThreadSafe</code></div>
    1235. 

  1235. 

  1236.     
    1237. 

  1237. 	
    1238. 

  1238. 	
    1239. 

  1239. 	
    1240. 

  1240. 	<div class="method-subsection return">
    1241. 

  1241. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    1242. 

  1242. 		<p>Zero if and only if SQLite was compiled with mutexing code omitted due to the SQLITE_THREADSAFE compile-time option being set to 0.</p>
    1243. 

  1243. 	</div>
    1244. 

  1244. 	
    1245. 

  1245. 	
    1246. 

  1246. 	
    1247. 

  1247. 	
    1248. 

  1248. 	
    1249. 

  1249. 	
    1250. 

  1250. 	
    1251. 

  1251. 	
    1252. 

  1252. 	
    1253. 

  1253. 	<div class="method-subsection see-also-section">
    1254. 

  1254. 		<h4 class="method-subtitle">See Also</h4>
    1255. 

  1255. 		<ul>
    1256. 

  1256. 			
    1257. 

  1257. 			<li><code><p><a href="http://sqlite.org/c3ref/threadsafe.html">sqlite3_threadsafe()</a></p></code></li>
    1258. 

  1258. 			
    1259. 

  1259. 		</ul>
    1260. 

  1260. 	</div>
    1261. 

  1261. 	
    1262. 

  1262. 	
    1263. 

  1263. 	
    1264. 

  1264. 	<div class="method-subsection declared-in-section">
    1265. 

  1265. 		<h4 class="method-subtitle">Declared In</h4>
    1266. 

  1266. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    1267. 

  1267. 	</div>				
    1268. 

  1268. 	
    1269. 

  1269. 	
    1270. 

  1270. </div>
    1271. 

  1271. 						
    1272. 

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

  1273. 	<a name="//api/name/sqliteLibVersion" title="sqliteLibVersion"></a>
    1274. 

  1274. 	<h3 class="subsubtitle method-title">sqliteLibVersion</h3>
    1275. 

  1275. 	
    1276. 

  1276. 	
    1277. 

  1277. 	
    1278. 

  1278. 	<div class="method-subsection brief-description">
    1279. 

  1279. 		<p>Run-time library version numbers</p>
    1280. 

  1280. 	</div>		
    1281. 

  1281. 	
    1282. 

  1282.     
    1283. 

  1283. 

  1284. 	<div class="method-subsection method-declaration"><code>+ (NSString *)sqliteLibVersion</code></div>
    1285. 

  1285. 

  1286.     
    1287. 

  1287. 	
    1288. 

  1288. 	
    1289. 

  1289. 	
    1290. 

  1290. 	
    1291. 

  1291. 	
    1292. 

  1292. 	
    1293. 

  1293. 	
    1294. 

  1294. 	
    1295. 

  1295. 	
    1296. 

  1296. 	
    1297. 

  1297. 	
    1298. 

  1298. 	<div class="method-subsection see-also-section">
    1299. 

  1299. 		<h4 class="method-subtitle">See Also</h4>
    1300. 

  1300. 		<ul>
    1301. 

  1301. 			
    1302. 

  1302. 			<li><code><p><a href="http://sqlite.org/c3ref/libversion.html">sqlite3_libversion()</a></p></code></li>
    1303. 

  1303. 			
    1304. 

  1304. 		</ul>
    1305. 

  1305. 	</div>
    1306. 

  1306. 	
    1307. 

  1307. 	
    1308. 

  1308. 	
    1309. 

  1309. 	<div class="method-subsection declared-in-section">
    1310. 

  1310. 		<h4 class="method-subtitle">Declared In</h4>
    1311. 

  1311. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    1312. 

  1312. 	</div>				
    1313. 

  1313. 	
    1314. 

  1314. 	
    1315. 

  1315. </div>
    1316. 

  1316. 						
    1317. 

  1317. 						<div class="section-method">
    1318. 

  1318. 	<a name="//api/name/storeableDateFormat:" title="storeableDateFormat:"></a>
    1319. 

  1319. 	<h3 class="subsubtitle method-title">storeableDateFormat:</h3>
    1320. 

  1320. 	
    1321. 

  1321. 	
    1322. 

  1322. 	
    1323. 

  1323. 	<div class="method-subsection brief-description">
    1324. 

  1324. 		<p>Generate an <code>NSDateFormatter</code> that won&rsquo;t be broken by permutations of timezones or locales.</p>
    1325. 

  1325. 	</div>		
    1326. 

  1326. 	
    1327. 

  1327.     
    1328. 

  1328. 

  1329. 	<div class="method-subsection method-declaration"><code>+ (NSDateFormatter *)storeableDateFormat:(NSString *)<em>format</em></code></div>
    1330. 

  1330. 

  1331.     
    1332. 

  1332. 	
    1333. 

  1333. 	<div class="method-subsection arguments-section parameters">
    1334. 

  1334. 		<h4 class="method-subtitle parameter-title">Parameters</h4>
    1335. 

  1335. 		
    1336. 

  1336. 		<dl class="argument-def parameter-def">
    1337. 

  1337. 			<dt><em>format</em></dt>
    1338. 

  1338. 			<dd><p>A valid NSDateFormatter format string.</p></dd>
    1339. 

  1339. 		</dl>
    1340. 

  1340. 		
    1341. 

  1341. 	</div>
    1342. 

  1342. 	
    1343. 

  1343. 	
    1344. 

  1344. 	
    1345. 

  1345. 	<div class="method-subsection return">
    1346. 

  1346. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    1347. 

  1347. 		<p>A <code>NSDateFormatter</code> that can be used for converting dates to strings and vice versa.</p>
    1348. 

  1348. 	</div>
    1349. 

  1349. 	
    1350. 

  1350. 	
    1351. 

  1351. 	
    1352. 

  1352. 	
    1353. 

  1353. 	
    1354. 

  1354. 	<div class="method-subsection discussion-section">
    1355. 

  1355. 		<h4 class="method-subtitle">Discussion</h4>
    1356. 

  1356. 		<p>Use this method to generate values to set the dateFormat property.</p>
    1357. 

  1357. 

  1358. <p>Example:</p>
    1359. 

  1359. 

  1360. <pre><code>myDB.dateFormat = [FMDatabase storeableDateFormat:@"yyyy-MM-dd HH:mm:ss"];
    1361. 

  1361. </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>
    1362. 

  1362. 	</div>
    1363. 

  1363. 	
    1364. 

  1364. 	
    1365. 

  1365. 	
    1366. 

  1366. 	
    1367. 

  1367. 	
    1368. 

  1368. 	<div class="method-subsection see-also-section">
    1369. 

  1369. 		<h4 class="method-subtitle">See Also</h4>
    1370. 

  1370. 		<ul>
    1371. 

  1371. 			
    1372. 

  1372. 			<li><code><p><a href="#//api/name/hasDateFormatter">- hasDateFormatter</a></p></code></li>
    1373. 

  1373. 			
    1374. 

  1374. 			<li><code><p><a href="#//api/name/setDateFormat:">- setDateFormat:</a></p></code></li>
    1375. 

  1375. 			
    1376. 

  1376. 			<li><code><p><a href="#//api/name/dateFromString:">- dateFromString:</a></p></code></li>
    1377. 

  1377. 			
    1378. 

  1378. 			<li><code><p><a href="#//api/name/stringFromDate:">- stringFromDate:</a></p></code></li>
    1379. 

  1379. 			
    1380. 

  1380. 			<li><code><p><a href="#//api/name/storeableDateFormat:">+ storeableDateFormat:</a></p></code></li>
    1381. 

  1381. 			
    1382. 

  1382. 		</ul>
    1383. 

  1383. 	</div>
    1384. 

  1384. 	
    1385. 

  1385. 	
    1386. 

  1386. 	
    1387. 

  1387. 	<div class="method-subsection declared-in-section">
    1388. 

  1388. 		<h4 class="method-subtitle">Declared In</h4>
    1389. 

  1389. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    1390. 

  1390. 	</div>				
    1391. 

  1391. 	
    1392. 

  1392. 	
    1393. 

  1393. </div>
    1394. 

  1394. 						
    1395. 

  1395. 					</div>
    1396. 

  1396. 					
    1397. 

  1397. 					
    1398. 

  1398. 					
    1399. 

  1399. 					<div class="section section-methods">
    1400. 

  1400. 						<a title="Instance Methods" name="instance_methods"></a>
    1401. 

  1401. 						<h2 class="subtitle subtitle-methods">Instance Methods</h2>
    1402. 

  1402. 						
    1403. 

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

  1404. 	<a name="//api/name/beginDeferredTransaction" title="beginDeferredTransaction"></a>
    1405. 

  1405. 	<h3 class="subsubtitle method-title">beginDeferredTransaction</h3>
    1406. 

  1406. 	
    1407. 

  1407. 	
    1408. 

  1408. 	
    1409. 

  1409. 	<div class="method-subsection brief-description">
    1410. 

  1410. 		<p>Begin a deferred transaction</p>
    1411. 

  1411. 	</div>		
    1412. 

  1412. 	
    1413. 

  1413.     
    1414. 

  1414. 

  1415. 	<div class="method-subsection method-declaration"><code>- (BOOL)beginDeferredTransaction</code></div>
    1416. 

  1416. 

  1417.     
    1418. 

  1418. 	
    1419. 

  1419. 	
    1420. 

  1420. 	
    1421. 

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

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

  1423. 		<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>
    1424. 

  1424. 	</div>
    1425. 

  1425. 	
    1426. 

  1426. 	
    1427. 

  1427. 	
    1428. 

  1428. 	
    1429. 

  1429. 	
    1430. 

  1430. 	
    1431. 

  1431. 	
    1432. 

  1432. 	
    1433. 

  1433. 	
    1434. 

  1434. 	<div class="method-subsection see-also-section">
    1435. 

  1435. 		<h4 class="method-subtitle">See Also</h4>
    1436. 

  1436. 		<ul>
    1437. 

  1437. 			
    1438. 

  1438. 			<li><code><p><a href="#//api/name/commit">- commit</a></p></code></li>
    1439. 

  1439. 			
    1440. 

  1440. 			<li><code><p><a href="#//api/name/rollback">- rollback</a></p></code></li>
    1441. 

  1441. 			
    1442. 

  1442. 			<li><code><p><a href="#//api/name/beginTransaction">- beginTransaction</a></p></code></li>
    1443. 

  1443. 			
    1444. 

  1444. 			<li><code><p><a href="#//api/name/inTransaction">- inTransaction</a></p></code></li>
    1445. 

  1445. 			
    1446. 

  1446. 		</ul>
    1447. 

  1447. 	</div>
    1448. 

  1448. 	
    1449. 

  1449. 	
    1450. 

  1450. 	
    1451. 

  1451. 	<div class="method-subsection declared-in-section">
    1452. 

  1452. 		<h4 class="method-subtitle">Declared In</h4>
    1453. 

  1453. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    1454. 

  1454. 	</div>				
    1455. 

  1455. 	
    1456. 

  1456. 	
    1457. 

  1457. </div>
    1458. 

  1458. 						
    1459. 

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

  1460. 	<a name="//api/name/beginTransaction" title="beginTransaction"></a>
    1461. 

  1461. 	<h3 class="subsubtitle method-title">beginTransaction</h3>
    1462. 

  1462. 	
    1463. 

  1463. 	
    1464. 

  1464. 	
    1465. 

  1465. 	<div class="method-subsection brief-description">
    1466. 

  1466. 		<p>Begin a transaction</p>
    1467. 

  1467. 	</div>		
    1468. 

  1468. 	
    1469. 

  1469.     
    1470. 

  1470. 

  1471. 	<div class="method-subsection method-declaration"><code>- (BOOL)beginTransaction</code></div>
    1472. 

  1472. 

  1473.     
    1474. 

  1474. 	
    1475. 

  1475. 	
    1476. 

  1476. 	
    1477. 

  1477. 	<div class="method-subsection return">
    1478. 

  1478. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    1479. 

  1479. 		<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>
    1480. 

  1480. 	</div>
    1481. 

  1481. 	
    1482. 

  1482. 	
    1483. 

  1483. 	
    1484. 

  1484. 	
    1485. 

  1485. 	
    1486. 

  1486. 	
    1487. 

  1487. 	
    1488. 

  1488. 	
    1489. 

  1489. 	
    1490. 

  1490. 	<div class="method-subsection see-also-section">
    1491. 

  1491. 		<h4 class="method-subtitle">See Also</h4>
    1492. 

  1492. 		<ul>
    1493. 

  1493. 			
    1494. 

  1494. 			<li><code><p><a href="#//api/name/commit">- commit</a></p></code></li>
    1495. 

  1495. 			
    1496. 

  1496. 			<li><code><p><a href="#//api/name/rollback">- rollback</a></p></code></li>
    1497. 

  1497. 			
    1498. 

  1498. 			<li><code><p><a href="#//api/name/beginDeferredTransaction">- beginDeferredTransaction</a></p></code></li>
    1499. 

  1499. 			
    1500. 

  1500. 			<li><code><p><a href="#//api/name/inTransaction">- inTransaction</a></p></code></li>
    1501. 

  1501. 			
    1502. 

  1502. 		</ul>
    1503. 

  1503. 	</div>
    1504. 

  1504. 	
    1505. 

  1505. 	
    1506. 

  1506. 	
    1507. 

  1507. 	<div class="method-subsection declared-in-section">
    1508. 

  1508. 		<h4 class="method-subtitle">Declared In</h4>
    1509. 

  1509. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    1510. 

  1510. 	</div>				
    1511. 

  1511. 	
    1512. 

  1512. 	
    1513. 

  1513. </div>
    1514. 

  1514. 						
    1515. 

  1515. 						<div class="section-method">
    1516. 

  1516. 	<a name="//api/name/changes" title="changes"></a>
    1517. 

  1517. 	<h3 class="subsubtitle method-title">changes</h3>
    1518. 

  1518. 	
    1519. 

  1519. 	
    1520. 

  1520. 	
    1521. 

  1521. 	<div class="method-subsection brief-description">
    1522. 

  1522. 		<p>The number of rows changed by prior SQL statement.</p>
    1523. 

  1523. 	</div>		
    1524. 

  1524. 	
    1525. 

  1525.     
    1526. 

  1526. 

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

  1528. 

  1529.     
    1530. 

  1530. 	
    1531. 

  1531. 	
    1532. 

  1532. 	
    1533. 

  1533. 	
    1534. 

  1534. 	
    1535. 

  1535. 	
    1536. 

  1536. 	
    1537. 

  1537. 	<div class="method-subsection discussion-section">
    1538. 

  1538. 		<h4 class="method-subtitle">Discussion</h4>
    1539. 

  1539. 		<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>
    1540. 

  1540. 	</div>
    1541. 

  1541. 	
    1542. 

  1542. 	
    1543. 

  1543. 	
    1544. 

  1544. 	
    1545. 

  1545. 	
    1546. 

  1546. 	<div class="method-subsection see-also-section">
    1547. 

  1547. 		<h4 class="method-subtitle">See Also</h4>
    1548. 

  1548. 		<ul>
    1549. 

  1549. 			
    1550. 

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

  1551. 			
    1552. 

  1552. 		</ul>
    1553. 

  1553. 	</div>
    1554. 

  1554. 	
    1555. 

  1555. 	
    1556. 

  1556. 	
    1557. 

  1557. 	<div class="method-subsection declared-in-section">
    1558. 

  1558. 		<h4 class="method-subtitle">Declared In</h4>
    1559. 

  1559. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    1560. 

  1560. 	</div>				
    1561. 

  1561. 	
    1562. 

  1562. 	
    1563. 

  1563. </div>
    1564. 

  1564. 						
    1565. 

  1565. 						<div class="section-method">
    1566. 

  1566. 	<a name="//api/name/clearCachedStatements" title="clearCachedStatements"></a>
    1567. 

  1567. 	<h3 class="subsubtitle method-title">clearCachedStatements</h3>
    1568. 

  1568. 	
    1569. 

  1569. 	
    1570. 

  1570. 	
    1571. 

  1571. 	<div class="method-subsection brief-description">
    1572. 

  1572. 		<p>Clear cached statements</p>
    1573. 

  1573. 	</div>		
    1574. 

  1574. 	
    1575. 

  1575.     
    1576. 

  1576. 

  1577. 	<div class="method-subsection method-declaration"><code>- (void)clearCachedStatements</code></div>
    1578. 

  1578. 

  1579.     
    1580. 

  1580. 	
    1581. 

  1581. 	
    1582. 

  1582. 	
    1583. 

  1583. 	
    1584. 

  1584. 	
    1585. 

  1585. 	
    1586. 

  1586. 	
    1587. 

  1587. 	
    1588. 

  1588. 	
    1589. 

  1589. 	
    1590. 

  1590. 	
    1591. 

  1591. 	
    1592. 

  1592. 	
    1593. 

  1593. 	<div class="method-subsection declared-in-section">
    1594. 

  1594. 		<h4 class="method-subtitle">Declared In</h4>
    1595. 

  1595. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    1596. 

  1596. 	</div>				
    1597. 

  1597. 	
    1598. 

  1598. 	
    1599. 

  1599. </div>
    1600. 

  1600. 						
    1601. 

  1601. 						<div class="section-method">
    1602. 

  1602. 	<a name="//api/name/close" title="close"></a>
    1603. 

  1603. 	<h3 class="subsubtitle method-title">close</h3>
    1604. 

  1604. 	
    1605. 

  1605. 	
    1606. 

  1606. 	
    1607. 

  1607. 	<div class="method-subsection brief-description">
    1608. 

  1608. 		<p>Closing a database connection</p>
    1609. 

  1609. 	</div>		
    1610. 

  1610. 	
    1611. 

  1611.     
    1612. 

  1612. 

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

  1614. 

  1615.     
    1616. 

  1616. 	
    1617. 

  1617. 	
    1618. 

  1618. 	
    1619. 

  1619. 	<div class="method-subsection return">
    1620. 

  1620. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    1621. 

  1621. 		<p><code>YES</code> if success, <code>NO</code> on error.</p>
    1622. 

  1622. 	</div>
    1623. 

  1623. 	
    1624. 

  1624. 	
    1625. 

  1625. 	
    1626. 

  1626. 	
    1627. 

  1627. 	
    1628. 

  1628. 	
    1629. 

  1629. 	
    1630. 

  1630. 	
    1631. 

  1631. 	
    1632. 

  1632. 	<div class="method-subsection see-also-section">
    1633. 

  1633. 		<h4 class="method-subtitle">See Also</h4>
    1634. 

  1634. 		<ul>
    1635. 

  1635. 			
    1636. 

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

  1637. 			
    1638. 

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

  1639. 			
    1640. 

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

  1641. 			
    1642. 

  1642. 		</ul>
    1643. 

  1643. 	</div>
    1644. 

  1644. 	
    1645. 

  1645. 	
    1646. 

  1646. 	
    1647. 

  1647. 	<div class="method-subsection declared-in-section">
    1648. 

  1648. 		<h4 class="method-subtitle">Declared In</h4>
    1649. 

  1649. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    1650. 

  1650. 	</div>				
    1651. 

  1651. 	
    1652. 

  1652. 	
    1653. 

  1653. </div>
    1654. 

  1654. 						
    1655. 

  1655. 						<div class="section-method">
    1656. 

  1656. 	<a name="//api/name/closeOpenResultSets" title="closeOpenResultSets"></a>
    1657. 

  1657. 	<h3 class="subsubtitle method-title">closeOpenResultSets</h3>
    1658. 

  1658. 	
    1659. 

  1659. 	
    1660. 

  1660. 	
    1661. 

  1661. 	<div class="method-subsection brief-description">
    1662. 

  1662. 		<p>Close all open result sets</p>
    1663. 

  1663. 	</div>		
    1664. 

  1664. 	
    1665. 

  1665.     
    1666. 

  1666. 

  1667. 	<div class="method-subsection method-declaration"><code>- (void)closeOpenResultSets</code></div>
    1668. 

  1668. 

  1669.     
    1670. 

  1670. 	
    1671. 

  1671. 	
    1672. 

  1672. 	
    1673. 

  1673. 	
    1674. 

  1674. 	
    1675. 

  1675. 	
    1676. 

  1676. 	
    1677. 

  1677. 	
    1678. 

  1678. 	
    1679. 

  1679. 	
    1680. 

  1680. 	
    1681. 

  1681. 	
    1682. 

  1682. 	
    1683. 

  1683. 	<div class="method-subsection declared-in-section">
    1684. 

  1684. 		<h4 class="method-subtitle">Declared In</h4>
    1685. 

  1685. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    1686. 

  1686. 	</div>				
    1687. 

  1687. 	
    1688. 

  1688. 	
    1689. 

  1689. </div>
    1690. 

  1690. 						
    1691. 

  1691. 						<div class="section-method">
    1692. 

  1692. 	<a name="//api/name/commit" title="commit"></a>
    1693. 

  1693. 	<h3 class="subsubtitle method-title">commit</h3>
    1694. 

  1694. 	
    1695. 

  1695. 	
    1696. 

  1696. 	
    1697. 

  1697. 	<div class="method-subsection brief-description">
    1698. 

  1698. 		<p>Commit a transaction</p>
    1699. 

  1699. 	</div>		
    1700. 

  1700. 	
    1701. 

  1701.     
    1702. 

  1702. 

  1703. 	<div class="method-subsection method-declaration"><code>- (BOOL)commit</code></div>
    1704. 

  1704. 

  1705.     
    1706. 

  1706. 	
    1707. 

  1707. 	
    1708. 

  1708. 	
    1709. 

  1709. 	<div class="method-subsection return">
    1710. 

  1710. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    1711. 

  1711. 		<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>
    1712. 

  1712. 	</div>
    1713. 

  1713. 	
    1714. 

  1714. 	
    1715. 

  1715. 	
    1716. 

  1716. 	
    1717. 

  1717. 	
    1718. 

  1718. 	<div class="method-subsection discussion-section">
    1719. 

  1719. 		<h4 class="method-subtitle">Discussion</h4>
    1720. 

  1720. 		<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>
    1721. 

  1721. 	</div>
    1722. 

  1722. 	
    1723. 

  1723. 	
    1724. 

  1724. 	
    1725. 

  1725. 	
    1726. 

  1726. 	
    1727. 

  1727. 	<div class="method-subsection see-also-section">
    1728. 

  1728. 		<h4 class="method-subtitle">See Also</h4>
    1729. 

  1729. 		<ul>
    1730. 

  1730. 			
    1731. 

  1731. 			<li><code><p><a href="#//api/name/beginTransaction">- beginTransaction</a></p></code></li>
    1732. 

  1732. 			
    1733. 

  1733. 			<li><code><p><a href="#//api/name/beginDeferredTransaction">- beginDeferredTransaction</a></p></code></li>
    1734. 

  1734. 			
    1735. 

  1735. 			<li><code><p><a href="#//api/name/rollback">- rollback</a></p></code></li>
    1736. 

  1736. 			
    1737. 

  1737. 			<li><code><p><a href="#//api/name/inTransaction">- inTransaction</a></p></code></li>
    1738. 

  1738. 			
    1739. 

  1739. 		</ul>
    1740. 

  1740. 	</div>
    1741. 

  1741. 	
    1742. 

  1742. 	
    1743. 

  1743. 	
    1744. 

  1744. 	<div class="method-subsection declared-in-section">
    1745. 

  1745. 		<h4 class="method-subtitle">Declared In</h4>
    1746. 

  1746. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    1747. 

  1747. 	</div>				
    1748. 

  1748. 	
    1749. 

  1749. 	
    1750. 

  1750. </div>
    1751. 

  1751. 						
    1752. 

  1752. 						<div class="section-method">
    1753. 

  1753. 	<a name="//api/name/databasePath" title="databasePath"></a>
    1754. 

  1754. 	<h3 class="subsubtitle method-title">databasePath</h3>
    1755. 

  1755. 	
    1756. 

  1756. 	
    1757. 

  1757. 	
    1758. 

  1758. 	<div class="method-subsection brief-description">
    1759. 

  1759. 		<p>The path of the database file</p>
    1760. 

  1760. 	</div>		
    1761. 

  1761. 	
    1762. 

  1762.     
    1763. 

  1763. 

  1764. 	<div class="method-subsection method-declaration"><code>- (NSString *)databasePath</code></div>
    1765. 

  1765. 

  1766.     
    1767. 

  1767. 	
    1768. 

  1768. 	
    1769. 

  1769. 	
    1770. 

  1770. 	<div class="method-subsection return">
    1771. 

  1771. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    1772. 

  1772. 		<p>path of database.</p>
    1773. 

  1773. 	</div>
    1774. 

  1774. 	
    1775. 

  1775. 	
    1776. 

  1776. 	
    1777. 

  1777. 	
    1778. 

  1778. 	
    1779. 

  1779. 	
    1780. 

  1780. 	
    1781. 

  1781. 	
    1782. 

  1782. 	
    1783. 

  1783. 	
    1784. 

  1784. 	
    1785. 

  1785. 	<div class="method-subsection declared-in-section">
    1786. 

  1786. 		<h4 class="method-subtitle">Declared In</h4>
    1787. 

  1787. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    1788. 

  1788. 	</div>				
    1789. 

  1789. 	
    1790. 

  1790. 	
    1791. 

  1791. </div>
    1792. 

  1792. 						
    1793. 

  1793. 						<div class="section-method">
    1794. 

  1794. 	<a name="//api/name/dateFromString:" title="dateFromString:"></a>
    1795. 

  1795. 	<h3 class="subsubtitle method-title">dateFromString:</h3>
    1796. 

  1796. 	
    1797. 

  1797. 	
    1798. 

  1798. 	
    1799. 

  1799. 	<div class="method-subsection brief-description">
    1800. 

  1800. 		<p>Convert the supplied NSString to NSDate, using the current database formatter.</p>
    1801. 

  1801. 	</div>		
    1802. 

  1802. 	
    1803. 

  1803.     
    1804. 

  1804. 

  1805. 	<div class="method-subsection method-declaration"><code>- (NSDate *)dateFromString:(NSString *)<em>s</em></code></div>
    1806. 

  1806. 

  1807.     
    1808. 

  1808. 	
    1809. 

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

  1810. 		<h4 class="method-subtitle parameter-title">Parameters</h4>
    1811. 

  1811. 		
    1812. 

  1812. 		<dl class="argument-def parameter-def">
    1813. 

  1813. 			<dt><em>s</em></dt>
    1814. 

  1814. 			<dd><p><code>NSString</code> to convert to <code>NSDate</code>.</p></dd>
    1815. 

  1815. 		</dl>
    1816. 

  1816. 		
    1817. 

  1817. 	</div>
    1818. 

  1818. 	
    1819. 

  1819. 	
    1820. 

  1820. 	
    1821. 

  1821. 	<div class="method-subsection return">
    1822. 

  1822. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    1823. 

  1823. 		<p><code>nil</code> if no formatter is set.</p>
    1824. 

  1824. 	</div>
    1825. 

  1825. 	
    1826. 

  1826. 	
    1827. 

  1827. 	
    1828. 

  1828. 	
    1829. 

  1829. 	
    1830. 

  1830. 	
    1831. 

  1831. 	
    1832. 

  1832. 	
    1833. 

  1833. 	
    1834. 

  1834. 	<div class="method-subsection see-also-section">
    1835. 

  1835. 		<h4 class="method-subtitle">See Also</h4>
    1836. 

  1836. 		<ul>
    1837. 

  1837. 			
    1838. 

  1838. 			<li><code><p><a href="#//api/name/hasDateFormatter">- hasDateFormatter</a></p></code></li>
    1839. 

  1839. 			
    1840. 

  1840. 			<li><code><p><a href="#//api/name/setDateFormat:">- setDateFormat:</a></p></code></li>
    1841. 

  1841. 			
    1842. 

  1842. 			<li><code><p><a href="#//api/name/dateFromString:">- dateFromString:</a></p></code></li>
    1843. 

  1843. 			
    1844. 

  1844. 			<li><code><p><a href="#//api/name/stringFromDate:">- stringFromDate:</a></p></code></li>
    1845. 

  1845. 			
    1846. 

  1846. 			<li><code><p><a href="#//api/name/storeableDateFormat:">+ storeableDateFormat:</a></p></code></li>
    1847. 

  1847. 			
    1848. 

  1848. 		</ul>
    1849. 

  1849. 	</div>
    1850. 

  1850. 	
    1851. 

  1851. 	
    1852. 

  1852. 	
    1853. 

  1853. 	<div class="method-subsection declared-in-section">
    1854. 

  1854. 		<h4 class="method-subtitle">Declared In</h4>
    1855. 

  1855. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    1856. 

  1856. 	</div>				
    1857. 

  1857. 	
    1858. 

  1858. 	
    1859. 

  1859. </div>
    1860. 

  1860. 						
    1861. 

  1861. 						<div class="section-method">
    1862. 

  1862. 	<a name="//api/name/executeQuery:" title="executeQuery:"></a>
    1863. 

  1863. 	<h3 class="subsubtitle method-title">executeQuery:</h3>
    1864. 

  1864. 	
    1865. 

  1865. 	
    1866. 

  1866. 	
    1867. 

  1867. 	<div class="method-subsection brief-description">
    1868. 

  1868. 		<p>Execute select statement</p>
    1869. 

  1869. 	</div>		
    1870. 

  1870. 	
    1871. 

  1871.     
    1872. 

  1872. 

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

  1874. 

  1875.     
    1876. 

  1876. 	
    1877. 

  1877. 	<div class="method-subsection arguments-section parameters">
    1878. 

  1878. 		<h4 class="method-subtitle parameter-title">Parameters</h4>
    1879. 

  1879. 		
    1880. 

  1880. 		<dl class="argument-def parameter-def">
    1881. 

  1881. 			<dt><em>sql</em></dt>
    1882. 

  1882. 			<dd><p>The SELECT statement to be performed, with optional <code>?</code> placeholders.</p></dd>
    1883. 

  1883. 		</dl>
    1884. 

  1884. 		
    1885. 

  1885. 		<dl class="argument-def parameter-def">
    1886. 

  1886. 			<dt><em>...</em></dt>
    1887. 

  1887. 			<dd><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></dd>
    1888. 

  1888. 		</dl>
    1889. 

  1889. 		
    1890. 

  1890. 	</div>
    1891. 

  1891. 	
    1892. 

  1892. 	
    1893. 

  1893. 	
    1894. 

  1894. 	<div class="method-subsection return">
    1895. 

  1895. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    1896. 

  1896. 		<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>
    1897. 

  1897. 	</div>
    1898. 

  1898. 	
    1899. 

  1899. 	
    1900. 

  1900. 	
    1901. 

  1901. 	
    1902. 

  1902. 	
    1903. 

  1903. 	<div class="method-subsection discussion-section">
    1904. 

  1904. 		<h4 class="method-subtitle">Discussion</h4>
    1905. 

  1905. 		<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>
    1906. 

  1906. 

  1907. <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>
    1908. 

  1908. 

  1909. <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>
    1910. 

  1910. 	</div>
    1911. 

  1911. 	
    1912. 

  1912. 	
    1913. 

  1913. 	
    1914. 

  1914. 	
    1915. 

  1915. 	
    1916. 

  1916. 	<div class="method-subsection see-also-section">
    1917. 

  1917. 		<h4 class="method-subtitle">See Also</h4>
    1918. 

  1918. 		<ul>
    1919. 

  1919. 			
    1920. 

  1920. 			<li><code><p><a href="../Classes/FMResultSet.html">FMResultSet</a></p></code></li>
    1921. 

  1921. 			
    1922. 

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

  1923. 			
    1924. 

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

  1925. 			
    1926. 

  1926. 		</ul>
    1927. 

  1927. 	</div>
    1928. 

  1928. 	
    1929. 

  1929. 	
    1930. 

  1930. 	
    1931. 

  1931. 	<div class="method-subsection declared-in-section">
    1932. 

  1932. 		<h4 class="method-subtitle">Declared In</h4>
    1933. 

  1933. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    1934. 

  1934. 	</div>				
    1935. 

  1935. 	
    1936. 

  1936. 	
    1937. 

  1937. </div>
    1938. 

  1938. 						
    1939. 

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

  1940. 	<a name="//api/name/executeQuery:withArgumentsInArray:" title="executeQuery:withArgumentsInArray:"></a>
    1941. 

  1941. 	<h3 class="subsubtitle method-title">executeQuery:withArgumentsInArray:</h3>
    1942. 

  1942. 	
    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 *)executeQuery:(NSString *)<em>sql</em> withArgumentsInArray:(NSArray *)<em>arguments</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. 		
    1958. 

  1958. 		<dl class="argument-def parameter-def">
    1959. 

  1959. 			<dt><em>sql</em></dt>
    1960. 

  1960. 			<dd><p>The SELECT statement to be performed, with optional <code>?</code> placeholders.</p></dd>
    1961. 

  1961. 		</dl>
    1962. 

  1962. 		
    1963. 

  1963. 		<dl class="argument-def parameter-def">
    1964. 

  1964. 			<dt><em>arguments</em></dt>
    1965. 

  1965. 			<dd><p>A <code>NSArray</code> of objects to be used when binding values to the <code>?</code> placeholders in the SQL statement.</p></dd>
    1966. 

  1966. 		</dl>
    1967. 

  1967. 		
    1968. 

  1968. 	</div>
    1969. 

  1969. 	
    1970. 

  1970. 	
    1971. 

  1971. 	
    1972. 

  1972. 	<div class="method-subsection return">
    1973. 

  1973. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    1974. 

  1974. 		<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>
    1975. 

  1975. 	</div>
    1976. 

  1976. 	
    1977. 

  1977. 	
    1978. 

  1978. 	
    1979. 

  1979. 	
    1980. 

  1980. 	
    1981. 

  1981. 	<div class="method-subsection discussion-section">
    1982. 

  1982. 		<h4 class="method-subtitle">Discussion</h4>
    1983. 

  1983. 		<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>
    1984. 

  1984. 

  1985. <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>
    1986. 

  1986. 	</div>
    1987. 

  1987. 	
    1988. 

  1988. 	
    1989. 

  1989. 	
    1990. 

  1990. 	
    1991. 

  1991. 	
    1992. 

  1992. 	<div class="method-subsection see-also-section">
    1993. 

  1993. 		<h4 class="method-subtitle">See Also</h4>
    1994. 

  1994. 		<ul>
    1995. 

  1995. 			
    1996. 

  1996. 			<li><code><p><a href="../Classes/FMResultSet.html">FMResultSet</a></p></code></li>
    1997. 

  1997. 			
    1998. 

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

  1999. 			
    2000. 

  2000. 		</ul>
    2001. 

  2001. 	</div>
    2002. 

  2002. 	
    2003. 

  2003. 	
    2004. 

  2004. 	
    2005. 

  2005. 	<div class="method-subsection declared-in-section">
    2006. 

  2006. 		<h4 class="method-subtitle">Declared In</h4>
    2007. 

  2007. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    2008. 

  2008. 	</div>				
    2009. 

  2009. 	
    2010. 

  2010. 	
    2011. 

  2011. </div>
    2012. 

  2012. 						
    2013. 

  2013. 						<div class="section-method">
    2014. 

  2014. 	<a name="//api/name/executeQuery:withParameterDictionary:" title="executeQuery:withParameterDictionary:"></a>
    2015. 

  2015. 	<h3 class="subsubtitle method-title">executeQuery:withParameterDictionary:</h3>
    2016. 

  2016. 	
    2017. 

  2017. 	
    2018. 

  2018. 	
    2019. 

  2019. 	<div class="method-subsection brief-description">
    2020. 

  2020. 		<p>Execute select statement</p>
    2021. 

  2021. 	</div>		
    2022. 

  2022. 	
    2023. 

  2023.     
    2024. 

  2024. 

  2025. 	<div class="method-subsection method-declaration"><code>- (FMResultSet *)executeQuery:(NSString *)<em>sql</em> withParameterDictionary:(NSDictionary *)<em>arguments</em></code></div>
    2026. 

  2026. 

  2027.     
    2028. 

  2028. 	
    2029. 

  2029. 	<div class="method-subsection arguments-section parameters">
    2030. 

  2030. 		<h4 class="method-subtitle parameter-title">Parameters</h4>
    2031. 

  2031. 		
    2032. 

  2032. 		<dl class="argument-def parameter-def">
    2033. 

  2033. 			<dt><em>sql</em></dt>
    2034. 

  2034. 			<dd><p>The SELECT statement to be performed, with optional <code>?</code> placeholders.</p></dd>
    2035. 

  2035. 		</dl>
    2036. 

  2036. 		
    2037. 

  2037. 		<dl class="argument-def parameter-def">
    2038. 

  2038. 			<dt><em>arguments</em></dt>
    2039. 

  2039. 			<dd><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></dd>
    2040. 

  2040. 		</dl>
    2041. 

  2041. 		
    2042. 

  2042. 	</div>
    2043. 

  2043. 	
    2044. 

  2044. 	
    2045. 

  2045. 	
    2046. 

  2046. 	<div class="method-subsection return">
    2047. 

  2047. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    2048. 

  2048. 		<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>
    2049. 

  2049. 	</div>
    2050. 

  2050. 	
    2051. 

  2051. 	
    2052. 

  2052. 	
    2053. 

  2053. 	
    2054. 

  2054. 	
    2055. 

  2055. 	<div class="method-subsection discussion-section">
    2056. 

  2056. 		<h4 class="method-subtitle">Discussion</h4>
    2057. 

  2057. 		<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>
    2058. 

  2058. 

  2059. <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>
    2060. 

  2060. 	</div>
    2061. 

  2061. 	
    2062. 

  2062. 	
    2063. 

  2063. 	
    2064. 

  2064. 	
    2065. 

  2065. 	
    2066. 

  2066. 	<div class="method-subsection see-also-section">
    2067. 

  2067. 		<h4 class="method-subtitle">See Also</h4>
    2068. 

  2068. 		<ul>
    2069. 

  2069. 			
    2070. 

  2070. 			<li><code><p><a href="../Classes/FMResultSet.html">FMResultSet</a></p></code></li>
    2071. 

  2071. 			
    2072. 

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

  2073. 			
    2074. 

  2074. 		</ul>
    2075. 

  2075. 	</div>
    2076. 

  2076. 	
    2077. 

  2077. 	
    2078. 

  2078. 	
    2079. 

  2079. 	<div class="method-subsection declared-in-section">
    2080. 

  2080. 		<h4 class="method-subtitle">Declared In</h4>
    2081. 

  2081. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    2082. 

  2082. 	</div>				
    2083. 

  2083. 	
    2084. 

  2084. 	
    2085. 

  2085. </div>
    2086. 

  2086. 						
    2087. 

  2087. 						<div class="section-method">
    2088. 

  2088. 	<a name="//api/name/executeQueryWithFormat:" title="executeQueryWithFormat:"></a>
    2089. 

  2089. 	<h3 class="subsubtitle method-title">executeQueryWithFormat:</h3>
    2090. 

  2090. 	
    2091. 

  2091. 	
    2092. 

  2092. 	
    2093. 

  2093. 	<div class="method-subsection brief-description">
    2094. 

  2094. 		<p>Execute select statement</p>
    2095. 

  2095. 	</div>		
    2096. 

  2096. 	
    2097. 

  2097.     
    2098. 

  2098. 

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

  2100. 

  2101.     
    2102. 

  2102. 	
    2103. 

  2103. 	<div class="method-subsection arguments-section parameters">
    2104. 

  2104. 		<h4 class="method-subtitle parameter-title">Parameters</h4>
    2105. 

  2105. 		
    2106. 

  2106. 		<dl class="argument-def parameter-def">
    2107. 

  2107. 			<dt><em>format</em></dt>
    2108. 

  2108. 			<dd><p>The SQL to be performed, with <code>printf</code>-style escape sequences.</p></dd>
    2109. 

  2109. 		</dl>
    2110. 

  2110. 		
    2111. 

  2111. 		<dl class="argument-def parameter-def">
    2112. 

  2112. 			<dt><em>...</em></dt>
    2113. 

  2113. 			<dd><p>Optional parameters to bind to use in conjunction with the <code>printf</code>-style escape sequences in the SQL statement.</p></dd>
    2114. 

  2114. 		</dl>
    2115. 

  2115. 		
    2116. 

  2116. 	</div>
    2117. 

  2117. 	
    2118. 

  2118. 	
    2119. 

  2119. 	
    2120. 

  2120. 	<div class="method-subsection return">
    2121. 

  2121. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    2122. 

  2122. 		<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>
    2123. 

  2123. 	</div>
    2124. 

  2124. 	
    2125. 

  2125. 	
    2126. 

  2126. 	
    2127. 

  2127. 	
    2128. 

  2128. 	
    2129. 

  2129. 	<div class="method-subsection discussion-section">
    2130. 

  2130. 		<h4 class="method-subtitle">Discussion</h4>
    2131. 

  2131. 		<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>
    2132. 

  2132. 

  2133. <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="warning"><p><strong>Warning:</strong> This should be used with great care. Generally, instead of this method, you should use <a href="#//api/name/executeQuery:"><code>executeQuery:</code></a> (with <code>?</code> placeholders in the SQL), which properly escapes quotation marks encountered inside the values (minimizing errors and protecting against SQL injection attack) and handles a wider variety of data types. See <a href="#//api/name/executeQuery:"><code>executeQuery:</code></a> for more information.</p></div>
    2134. 

  2134. 	</div>
    2135. 

  2135. 	
    2136. 

  2136. 	
    2137. 

  2137. 	
    2138. 

  2138. 	
    2139. 

  2139. 	
    2140. 

  2140. 	<div class="method-subsection see-also-section">
    2141. 

  2141. 		<h4 class="method-subtitle">See Also</h4>
    2142. 

  2142. 		<ul>
    2143. 

  2143. 			
    2144. 

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

  2145. 			
    2146. 

  2146. 			<li><code><p><a href="../Classes/FMResultSet.html">FMResultSet</a></p></code></li>
    2147. 

  2147. 			
    2148. 

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

  2149. 			
    2150. 

  2150. 		</ul>
    2151. 

  2151. 	</div>
    2152. 

  2152. 	
    2153. 

  2153. 	
    2154. 

  2154. 	
    2155. 

  2155. 	<div class="method-subsection declared-in-section">
    2156. 

  2156. 		<h4 class="method-subtitle">Declared In</h4>
    2157. 

  2157. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    2158. 

  2158. 	</div>				
    2159. 

  2159. 	
    2160. 

  2160. 	
    2161. 

  2161. </div>
    2162. 

  2162. 						
    2163. 

  2163. 						<div class="section-method">
    2164. 

  2164. 	<a name="//api/name/executeUpdate:" title="executeUpdate:"></a>
    2165. 

  2165. 	<h3 class="subsubtitle method-title">executeUpdate:</h3>
    2166. 

  2166. 	
    2167. 

  2167. 	
    2168. 

  2168. 	
    2169. 

  2169. 	<div class="method-subsection brief-description">
    2170. 

  2170. 		<p>Execute update statement</p>
    2171. 

  2171. 	</div>		
    2172. 

  2172. 	
    2173. 

  2173.     
    2174. 

  2174. 

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

  2176. 

  2177.     
    2178. 

  2178. 	
    2179. 

  2179. 	<div class="method-subsection arguments-section parameters">
    2180. 

  2180. 		<h4 class="method-subtitle parameter-title">Parameters</h4>
    2181. 

  2181. 		
    2182. 

  2182. 		<dl class="argument-def parameter-def">
    2183. 

  2183. 			<dt><em>sql</em></dt>
    2184. 

  2184. 			<dd><p>The SQL to be performed, with optional <code>?</code> placeholders.</p></dd>
    2185. 

  2185. 		</dl>
    2186. 

  2186. 		
    2187. 

  2187. 		<dl class="argument-def parameter-def">
    2188. 

  2188. 			<dt><em>...</em></dt>
    2189. 

  2189. 			<dd><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></dd>
    2190. 

  2190. 		</dl>
    2191. 

  2191. 		
    2192. 

  2192. 	</div>
    2193. 

  2193. 	
    2194. 

  2194. 	
    2195. 

  2195. 	
    2196. 

  2196. 	<div class="method-subsection return">
    2197. 

  2197. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    2198. 

  2198. 		<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>
    2199. 

  2199. 	</div>
    2200. 

  2200. 	
    2201. 

  2201. 	
    2202. 

  2202. 	
    2203. 

  2203. 	
    2204. 

  2204. 	
    2205. 

  2205. 	<div class="method-subsection discussion-section">
    2206. 

  2206. 		<h4 class="method-subtitle">Discussion</h4>
    2207. 

  2207. 		<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>
    2208. 

  2208. 	</div>
    2209. 

  2209. 	
    2210. 

  2210. 	
    2211. 

  2211. 	
    2212. 

  2212. 	
    2213. 

  2213. 	
    2214. 

  2214. 	<div class="method-subsection see-also-section">
    2215. 

  2215. 		<h4 class="method-subtitle">See Also</h4>
    2216. 

  2216. 		<ul>
    2217. 

  2217. 			
    2218. 

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

  2219. 			
    2220. 

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

  2221. 			
    2222. 

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

  2223. 			
    2224. 

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

  2225. 			
    2226. 

  2226. 		</ul>
    2227. 

  2227. 	</div>
    2228. 

  2228. 	
    2229. 

  2229. 	
    2230. 

  2230. 	
    2231. 

  2231. 	<div class="method-subsection declared-in-section">
    2232. 

  2232. 		<h4 class="method-subtitle">Declared In</h4>
    2233. 

  2233. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    2234. 

  2234. 	</div>				
    2235. 

  2235. 	
    2236. 

  2236. 	
    2237. 

  2237. </div>
    2238. 

  2238. 						
    2239. 

  2239. 						<div class="section-method">
    2240. 

  2240. 	<a name="//api/name/executeUpdate:withArgumentsInArray:" title="executeUpdate:withArgumentsInArray:"></a>
    2241. 

  2241. 	<h3 class="subsubtitle method-title">executeUpdate:withArgumentsInArray:</h3>
    2242. 

  2242. 	
    2243. 

  2243. 	
    2244. 

  2244. 	
    2245. 

  2245. 	<div class="method-subsection brief-description">
    2246. 

  2246. 		<p>Execute update statement</p>
    2247. 

  2247. 	</div>		
    2248. 

  2248. 	
    2249. 

  2249.     
    2250. 

  2250. 

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

  2252. 

  2253.     
    2254. 

  2254. 	
    2255. 

  2255. 	<div class="method-subsection arguments-section parameters">
    2256. 

  2256. 		<h4 class="method-subtitle parameter-title">Parameters</h4>
    2257. 

  2257. 		
    2258. 

  2258. 		<dl class="argument-def parameter-def">
    2259. 

  2259. 			<dt><em>sql</em></dt>
    2260. 

  2260. 			<dd><p>The SQL to be performed, with optional <code>?</code> placeholders.</p></dd>
    2261. 

  2261. 		</dl>
    2262. 

  2262. 		
    2263. 

  2263. 		<dl class="argument-def parameter-def">
    2264. 

  2264. 			<dt><em>arguments</em></dt>
    2265. 

  2265. 			<dd><p>A <code>NSArray</code> of objects to be used when binding values to the <code>?</code> placeholders in the SQL statement.</p></dd>
    2266. 

  2266. 		</dl>
    2267. 

  2267. 		
    2268. 

  2268. 	</div>
    2269. 

  2269. 	
    2270. 

  2270. 	
    2271. 

  2271. 	
    2272. 

  2272. 	<div class="method-subsection return">
    2273. 

  2273. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    2274. 

  2274. 		<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>
    2275. 

  2275. 	</div>
    2276. 

  2276. 	
    2277. 

  2277. 	
    2278. 

  2278. 	
    2279. 

  2279. 	
    2280. 

  2280. 	
    2281. 

  2281. 	<div class="method-subsection discussion-section">
    2282. 

  2282. 		<h4 class="method-subtitle">Discussion</h4>
    2283. 

  2283. 		<p>Any sort of SQL statement which is not a <code>SELECT</code> statement qualifies as an update.  This includes <code>CREATE</code>, <code>UPDATE</code>, <code>INSERT</code>, <code>ALTER</code>, <code>COMMIT</code>, <code>BEGIN</code>, <code>DETACH</code>, <code>DELETE</code>, <code>DROP</code>, <code>END</code>, <code>EXPLAIN</code>, <code>VACUUM</code>, and <code>REPLACE</code> statements (plus many more).  Basically, if your SQL statement does not begin with <code>SELECT</code>, it is an update statement.</p>
    2284. 

  2284. 	</div>
    2285. 

  2285. 	
    2286. 

  2286. 	
    2287. 

  2287. 	
    2288. 

  2288. 	
    2289. 

  2289. 	
    2290. 

  2290. 	<div class="method-subsection see-also-section">
    2291. 

  2291. 		<h4 class="method-subtitle">See Also</h4>
    2292. 

  2292. 		<ul>
    2293. 

  2293. 			
    2294. 

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

  2295. 			
    2296. 

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

  2297. 			
    2298. 

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

  2299. 			
    2300. 

  2300. 		</ul>
    2301. 

  2301. 	</div>
    2302. 

  2302. 	
    2303. 

  2303. 	
    2304. 

  2304. 	
    2305. 

  2305. 	<div class="method-subsection declared-in-section">
    2306. 

  2306. 		<h4 class="method-subtitle">Declared In</h4>
    2307. 

  2307. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    2308. 

  2308. 	</div>				
    2309. 

  2309. 	
    2310. 

  2310. 	
    2311. 

  2311. </div>
    2312. 

  2312. 						
    2313. 

  2313. 						<div class="section-method">
    2314. 

  2314. 	<a name="//api/name/executeUpdate:withParameterDictionary:" title="executeUpdate:withParameterDictionary:"></a>
    2315. 

  2315. 	<h3 class="subsubtitle method-title">executeUpdate:withParameterDictionary:</h3>
    2316. 

  2316. 	
    2317. 

  2317. 	
    2318. 

  2318. 	
    2319. 

  2319. 	<div class="method-subsection brief-description">
    2320. 

  2320. 		<p>Execute update statement</p>
    2321. 

  2321. 	</div>		
    2322. 

  2322. 	
    2323. 

  2323.     
    2324. 

  2324. 

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

  2326. 

  2327.     
    2328. 

  2328. 	
    2329. 

  2329. 	<div class="method-subsection arguments-section parameters">
    2330. 

  2330. 		<h4 class="method-subtitle parameter-title">Parameters</h4>
    2331. 

  2331. 		
    2332. 

  2332. 		<dl class="argument-def parameter-def">
    2333. 

  2333. 			<dt><em>sql</em></dt>
    2334. 

  2334. 			<dd><p>The SQL to be performed, with optional <code>?</code> placeholders.</p></dd>
    2335. 

  2335. 		</dl>
    2336. 

  2336. 		
    2337. 

  2337. 		<dl class="argument-def parameter-def">
    2338. 

  2338. 			<dt><em>arguments</em></dt>
    2339. 

  2339. 			<dd><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></dd>
    2340. 

  2340. 		</dl>
    2341. 

  2341. 		
    2342. 

  2342. 	</div>
    2343. 

  2343. 	
    2344. 

  2344. 	
    2345. 

  2345. 	
    2346. 

  2346. 	<div class="method-subsection return">
    2347. 

  2347. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    2348. 

  2348. 		<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>
    2349. 

  2349. 	</div>
    2350. 

  2350. 	
    2351. 

  2351. 	
    2352. 

  2352. 	
    2353. 

  2353. 	
    2354. 

  2354. 	
    2355. 

  2355. 	<div class="method-subsection discussion-section">
    2356. 

  2356. 		<h4 class="method-subtitle">Discussion</h4>
    2357. 

  2357. 		<p>Any sort of SQL statement which is not a <code>SELECT</code> statement qualifies as an update.  This includes <code>CREATE</code>, <code>UPDATE</code>, <code>INSERT</code>, <code>ALTER</code>, <code>COMMIT</code>, <code>BEGIN</code>, <code>DETACH</code>, <code>DELETE</code>, <code>DROP</code>, <code>END</code>, <code>EXPLAIN</code>, <code>VACUUM</code>, and <code>REPLACE</code> statements (plus many more).  Basically, if your SQL statement does not begin with <code>SELECT</code>, it is an update statement.</p>
    2358. 

  2358. 	</div>
    2359. 

  2359. 	
    2360. 

  2360. 	
    2361. 

  2361. 	
    2362. 

  2362. 	
    2363. 

  2363. 	
    2364. 

  2364. 	<div class="method-subsection see-also-section">
    2365. 

  2365. 		<h4 class="method-subtitle">See Also</h4>
    2366. 

  2366. 		<ul>
    2367. 

  2367. 			
    2368. 

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

  2369. 			
    2370. 

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

  2371. 			
    2372. 

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

  2373. 			
    2374. 

  2374. 		</ul>
    2375. 

  2375. 	</div>
    2376. 

  2376. 	
    2377. 

  2377. 	
    2378. 

  2378. 	
    2379. 

  2379. 	<div class="method-subsection declared-in-section">
    2380. 

  2380. 		<h4 class="method-subtitle">Declared In</h4>
    2381. 

  2381. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    2382. 

  2382. 	</div>				
    2383. 

  2383. 	
    2384. 

  2384. 	
    2385. 

  2385. </div>
    2386. 

  2386. 						
    2387. 

  2387. 						<div class="section-method">
    2388. 

  2388. 	<a name="//api/name/executeUpdateWithFormat:" title="executeUpdateWithFormat:"></a>
    2389. 

  2389. 	<h3 class="subsubtitle method-title">executeUpdateWithFormat:</h3>
    2390. 

  2390. 	
    2391. 

  2391. 	
    2392. 

  2392. 	
    2393. 

  2393. 	<div class="method-subsection brief-description">
    2394. 

  2394. 		<p>Execute update statement</p>
    2395. 

  2395. 	</div>		
    2396. 

  2396. 	
    2397. 

  2397.     
    2398. 

  2398. 

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

  2400. 

  2401.     
    2402. 

  2402. 	
    2403. 

  2403. 	<div class="method-subsection arguments-section parameters">
    2404. 

  2404. 		<h4 class="method-subtitle parameter-title">Parameters</h4>
    2405. 

  2405. 		
    2406. 

  2406. 		<dl class="argument-def parameter-def">
    2407. 

  2407. 			<dt><em>format</em></dt>
    2408. 

  2408. 			<dd><p>The SQL to be performed, with <code>printf</code>-style escape sequences.</p></dd>
    2409. 

  2409. 		</dl>
    2410. 

  2410. 		
    2411. 

  2411. 		<dl class="argument-def parameter-def">
    2412. 

  2412. 			<dt><em>...</em></dt>
    2413. 

  2413. 			<dd><p>Optional parameters to bind to use in conjunction with the <code>printf</code>-style escape sequences in the SQL statement.</p></dd>
    2414. 

  2414. 		</dl>
    2415. 

  2415. 		
    2416. 

  2416. 	</div>
    2417. 

  2417. 	
    2418. 

  2418. 	
    2419. 

  2419. 	
    2420. 

  2420. 	<div class="method-subsection return">
    2421. 

  2421. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    2422. 

  2422. 		<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>
    2423. 

  2423. 	</div>
    2424. 

  2424. 	
    2425. 

  2425. 	
    2426. 

  2426. 	
    2427. 

  2427. 	
    2428. 

  2428. 	
    2429. 

  2429. 	<div class="method-subsection discussion-section">
    2430. 

  2430. 		<h4 class="method-subtitle">Discussion</h4>
    2431. 

  2431. 		<p>Any sort of SQL statement which is not a <code>SELECT</code> statement qualifies as an update.  This includes <code>CREATE</code>, <code>UPDATE</code>, <code>INSERT</code>, <code>ALTER</code>, <code>COMMIT</code>, <code>BEGIN</code>, <code>DETACH</code>, <code>DELETE</code>, <code>DROP</code>, <code>END</code>, <code>EXPLAIN</code>, <code>VACUUM</code>, and <code>REPLACE</code> statements (plus many more).  Basically, if your SQL statement does not begin with <code>SELECT</code>, it is an update statement.</p><div class="warning"><p><strong>Warning:</strong> This should be used with great care. Generally, instead of this method, you should use <a href="#//api/name/executeUpdate:"><code>executeUpdate:</code></a> (with <code>?</code> placeholders in the SQL), which properly escapes quotation marks encountered inside the values (minimizing errors and protecting against SQL injection attack) and handles a wider variety of data types. See <a href="#//api/name/executeUpdate:"><code>executeUpdate:</code></a> for more information.</p></div>
    2432. 

  2432. 	</div>
    2433. 

  2433. 	
    2434. 

  2434. 	
    2435. 

  2435. 	
    2436. 

  2436. 	
    2437. 

  2437. 	
    2438. 

  2438. 	<div class="method-subsection see-also-section">
    2439. 

  2439. 		<h4 class="method-subtitle">See Also</h4>
    2440. 

  2440. 		<ul>
    2441. 

  2441. 			
    2442. 

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

  2443. 			
    2444. 

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

  2445. 			
    2446. 

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

  2447. 			
    2448. 

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

  2449. 			
    2450. 

  2450. 		</ul>
    2451. 

  2451. 	</div>
    2452. 

  2452. 	
    2453. 

  2453. 	
    2454. 

  2454. 	
    2455. 

  2455. 	<div class="method-subsection declared-in-section">
    2456. 

  2456. 		<h4 class="method-subtitle">Declared In</h4>
    2457. 

  2457. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    2458. 

  2458. 	</div>				
    2459. 

  2459. 	
    2460. 

  2460. 	
    2461. 

  2461. </div>
    2462. 

  2462. 						
    2463. 

  2463. 						<div class="section-method">
    2464. 

  2464. 	<a name="//api/name/goodConnection" title="goodConnection"></a>
    2465. 

  2465. 	<h3 class="subsubtitle method-title">goodConnection</h3>
    2466. 

  2466. 	
    2467. 

  2467. 	
    2468. 

  2468. 	
    2469. 

  2469. 	<div class="method-subsection brief-description">
    2470. 

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

  2471. 	</div>		
    2472. 

  2472. 	
    2473. 

  2473.     
    2474. 

  2474. 

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

  2476. 

  2477.     
    2478. 

  2478. 	
    2479. 

  2479. 	
    2480. 

  2480. 	
    2481. 

  2481. 	<div class="method-subsection return">
    2482. 

  2482. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    2483. 

  2483. 		<p><code>YES</code> if everything succeeds, <code>NO</code> on failure.</p>
    2484. 

  2484. 	</div>
    2485. 

  2485. 	
    2486. 

  2486. 	
    2487. 

  2487. 	
    2488. 

  2488. 	
    2489. 

  2489. 	
    2490. 

  2490. 	<div class="method-subsection discussion-section">
    2491. 

  2491. 		<h4 class="method-subtitle">Discussion</h4>
    2492. 

  2492. 		<p>This will confirm whether:</p>
    2493. 

  2493. 

  2494. <ul>
    2495. 

  2495. <li>is database open</li>
    2496. 

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

  2497. </ul>
    2498. 

  2498. 

  2499. 	</div>
    2500. 

  2500. 	
    2501. 

  2501. 	
    2502. 

  2502. 	
    2503. 

  2503. 	
    2504. 

  2504. 	
    2505. 

  2505. 	
    2506. 

  2506. 	
    2507. 

  2507. 	<div class="method-subsection declared-in-section">
    2508. 

  2508. 		<h4 class="method-subtitle">Declared In</h4>
    2509. 

  2509. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    2510. 

  2510. 	</div>				
    2511. 

  2511. 	
    2512. 

  2512. 	
    2513. 

  2513. </div>
    2514. 

  2514. 						
    2515. 

  2515. 						<div class="section-method">
    2516. 

  2516. 	<a name="//api/name/hadError" title="hadError"></a>
    2517. 

  2517. 	<h3 class="subsubtitle method-title">hadError</h3>
    2518. 

  2518. 	
    2519. 

  2519. 	
    2520. 

  2520. 	
    2521. 

  2521. 	<div class="method-subsection brief-description">
    2522. 

  2522. 		<p>Had error</p>
    2523. 

  2523. 	</div>		
    2524. 

  2524. 	
    2525. 

  2525.     
    2526. 

  2526. 

  2527. 	<div class="method-subsection method-declaration"><code>- (BOOL)hadError</code></div>
    2528. 

  2528. 

  2529.     
    2530. 

  2530. 	
    2531. 

  2531. 	
    2532. 

  2532. 	
    2533. 

  2533. 	<div class="method-subsection return">
    2534. 

  2534. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    2535. 

  2535. 		<p><code>YES</code> if there was an error, <code>NO</code> if no error.</p>
    2536. 

  2536. 	</div>
    2537. 

  2537. 	
    2538. 

  2538. 	
    2539. 

  2539. 	
    2540. 

  2540. 	
    2541. 

  2541. 	
    2542. 

  2542. 	
    2543. 

  2543. 	
    2544. 

  2544. 	
    2545. 

  2545. 	
    2546. 

  2546. 	<div class="method-subsection see-also-section">
    2547. 

  2547. 		<h4 class="method-subtitle">See Also</h4>
    2548. 

  2548. 		<ul>
    2549. 

  2549. 			
    2550. 

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

  2551. 			
    2552. 

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

  2553. 			
    2554. 

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

  2555. 			
    2556. 

  2556. 		</ul>
    2557. 

  2557. 	</div>
    2558. 

  2558. 	
    2559. 

  2559. 	
    2560. 

  2560. 	
    2561. 

  2561. 	<div class="method-subsection declared-in-section">
    2562. 

  2562. 		<h4 class="method-subtitle">Declared In</h4>
    2563. 

  2563. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    2564. 

  2564. 	</div>				
    2565. 

  2565. 	
    2566. 

  2566. 	
    2567. 

  2567. </div>
    2568. 

  2568. 						
    2569. 

  2569. 						<div class="section-method">
    2570. 

  2570. 	<a name="//api/name/hasDateFormatter" title="hasDateFormatter"></a>
    2571. 

  2571. 	<h3 class="subsubtitle method-title">hasDateFormatter</h3>
    2572. 

  2572. 	
    2573. 

  2573. 	
    2574. 

  2574. 	
    2575. 

  2575. 	<div class="method-subsection brief-description">
    2576. 

  2576. 		<p>Test whether the database has a date formatter assigned.</p>
    2577. 

  2577. 	</div>		
    2578. 

  2578. 	
    2579. 

  2579.     
    2580. 

  2580. 

  2581. 	<div class="method-subsection method-declaration"><code>- (BOOL)hasDateFormatter</code></div>
    2582. 

  2582. 

  2583.     
    2584. 

  2584. 	
    2585. 

  2585. 	
    2586. 

  2586. 	
    2587. 

  2587. 	<div class="method-subsection return">
    2588. 

  2588. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    2589. 

  2589. 		<p><code>YES</code> if there is a date formatter; <code>NO</code> if not.</p>
    2590. 

  2590. 	</div>
    2591. 

  2591. 	
    2592. 

  2592. 	
    2593. 

  2593. 	
    2594. 

  2594. 	
    2595. 

  2595. 	
    2596. 

  2596. 	
    2597. 

  2597. 	
    2598. 

  2598. 	
    2599. 

  2599. 	
    2600. 

  2600. 	<div class="method-subsection see-also-section">
    2601. 

  2601. 		<h4 class="method-subtitle">See Also</h4>
    2602. 

  2602. 		<ul>
    2603. 

  2603. 			
    2604. 

  2604. 			<li><code><p><a href="#//api/name/hasDateFormatter">- hasDateFormatter</a></p></code></li>
    2605. 

  2605. 			
    2606. 

  2606. 			<li><code><p><a href="#//api/name/setDateFormat:">- setDateFormat:</a></p></code></li>
    2607. 

  2607. 			
    2608. 

  2608. 			<li><code><p><a href="#//api/name/dateFromString:">- dateFromString:</a></p></code></li>
    2609. 

  2609. 			
    2610. 

  2610. 			<li><code><p><a href="#//api/name/stringFromDate:">- stringFromDate:</a></p></code></li>
    2611. 

  2611. 			
    2612. 

  2612. 			<li><code><p><a href="#//api/name/storeableDateFormat:">+ storeableDateFormat:</a></p></code></li>
    2613. 

  2613. 			
    2614. 

  2614. 		</ul>
    2615. 

  2615. 	</div>
    2616. 

  2616. 	
    2617. 

  2617. 	
    2618. 

  2618. 	
    2619. 

  2619. 	<div class="method-subsection declared-in-section">
    2620. 

  2620. 		<h4 class="method-subtitle">Declared In</h4>
    2621. 

  2621. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    2622. 

  2622. 	</div>				
    2623. 

  2623. 	
    2624. 

  2624. 	
    2625. 

  2625. </div>
    2626. 

  2626. 						
    2627. 

  2627. 						<div class="section-method">
    2628. 

  2628. 	<a name="//api/name/hasOpenResultSets" title="hasOpenResultSets"></a>
    2629. 

  2629. 	<h3 class="subsubtitle method-title">hasOpenResultSets</h3>
    2630. 

  2630. 	
    2631. 

  2631. 	
    2632. 

  2632. 	
    2633. 

  2633. 	<div class="method-subsection brief-description">
    2634. 

  2634. 		<p>Whether database has any open result sets</p>
    2635. 

  2635. 	</div>		
    2636. 

  2636. 	
    2637. 

  2637.     
    2638. 

  2638. 

  2639. 	<div class="method-subsection method-declaration"><code>- (BOOL)hasOpenResultSets</code></div>
    2640. 

  2640. 

  2641.     
    2642. 

  2642. 	
    2643. 

  2643. 	
    2644. 

  2644. 	
    2645. 

  2645. 	<div class="method-subsection return">
    2646. 

  2646. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    2647. 

  2647. 		<p><code>YES</code> if there are open result sets; <code>NO</code> if not.</p>
    2648. 

  2648. 	</div>
    2649. 

  2649. 	
    2650. 

  2650. 	
    2651. 

  2651. 	
    2652. 

  2652. 	
    2653. 

  2653. 	
    2654. 

  2654. 	
    2655. 

  2655. 	
    2656. 

  2656. 	
    2657. 

  2657. 	
    2658. 

  2658. 	
    2659. 

  2659. 	
    2660. 

  2660. 	<div class="method-subsection declared-in-section">
    2661. 

  2661. 		<h4 class="method-subtitle">Declared In</h4>
    2662. 

  2662. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    2663. 

  2663. 	</div>				
    2664. 

  2664. 	
    2665. 

  2665. 	
    2666. 

  2666. </div>
    2667. 

  2667. 						
    2668. 

  2668. 						<div class="section-method">
    2669. 

  2669. 	<a name="//api/name/inSavePoint:" title="inSavePoint:"></a>
    2670. 

  2670. 	<h3 class="subsubtitle method-title">inSavePoint:</h3>
    2671. 

  2671. 	
    2672. 

  2672. 	
    2673. 

  2673. 	
    2674. 

  2674. 	<div class="method-subsection brief-description">
    2675. 

  2675. 		<p>Start save point</p>
    2676. 

  2676. 	</div>		
    2677. 

  2677. 	
    2678. 

  2678.     
    2679. 

  2679. 

  2680. 	<div class="method-subsection method-declaration"><code>- (NSError *)inSavePoint:(void ( ^ ) ( BOOL *rollback ))<em>block</em></code></div>
    2681. 

  2681. 

  2682.     
    2683. 

  2683. 	
    2684. 

  2684. 	<div class="method-subsection arguments-section parameters">
    2685. 

  2685. 		<h4 class="method-subtitle parameter-title">Parameters</h4>
    2686. 

  2686. 		
    2687. 

  2687. 		<dl class="argument-def parameter-def">
    2688. 

  2688. 			<dt><em>block</em></dt>
    2689. 

  2689. 			<dd><p>Block of code to perform from within save point.</p></dd>
    2690. 

  2690. 		</dl>
    2691. 

  2691. 		
    2692. 

  2692. 	</div>
    2693. 

  2693. 	
    2694. 

  2694. 	
    2695. 

  2695. 	
    2696. 

  2696. 	<div class="method-subsection return">
    2697. 

  2697. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    2698. 

  2698. 		<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>
    2699. 

  2699. 	</div>
    2700. 

  2700. 	
    2701. 

  2701. 	
    2702. 

  2702. 	
    2703. 

  2703. 	
    2704. 

  2704. 	
    2705. 

  2705. 	
    2706. 

  2706. 	
    2707. 

  2707. 	
    2708. 

  2708. 	
    2709. 

  2709. 	<div class="method-subsection see-also-section">
    2710. 

  2710. 		<h4 class="method-subtitle">See Also</h4>
    2711. 

  2711. 		<ul>
    2712. 

  2712. 			
    2713. 

  2713. 			<li><code><p><a href="#//api/name/startSavePointWithName:error:">- startSavePointWithName:error:</a></p></code></li>
    2714. 

  2714. 			
    2715. 

  2715. 			<li><code><p><a href="#//api/name/releaseSavePointWithName:error:">- releaseSavePointWithName:error:</a></p></code></li>
    2716. 

  2716. 			
    2717. 

  2717. 			<li><code><p><a href="#//api/name/rollbackToSavePointWithName:error:">- rollbackToSavePointWithName:error:</a></p></code></li>
    2718. 

  2718. 			
    2719. 

  2719. 		</ul>
    2720. 

  2720. 	</div>
    2721. 

  2721. 	
    2722. 

  2722. 	
    2723. 

  2723. 	
    2724. 

  2724. 	<div class="method-subsection declared-in-section">
    2725. 

  2725. 		<h4 class="method-subtitle">Declared In</h4>
    2726. 

  2726. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    2727. 

  2727. 	</div>				
    2728. 

  2728. 	
    2729. 

  2729. 	
    2730. 

  2730. </div>
    2731. 

  2731. 						
    2732. 

  2732. 						<div class="section-method">
    2733. 

  2733. 	<a name="//api/name/inTransaction" title="inTransaction"></a>
    2734. 

  2734. 	<h3 class="subsubtitle method-title">inTransaction</h3>
    2735. 

  2735. 	
    2736. 

  2736. 	
    2737. 

  2737. 	
    2738. 

  2738. 	<div class="method-subsection brief-description">
    2739. 

  2739. 		<p>Identify whether currently in a transaction or not</p>
    2740. 

  2740. 	</div>		
    2741. 

  2741. 	
    2742. 

  2742.     
    2743. 

  2743. 

  2744. 	<div class="method-subsection method-declaration"><code>- (BOOL)inTransaction</code></div>
    2745. 

  2745. 

  2746.     
    2747. 

  2747. 	
    2748. 

  2748. 	
    2749. 

  2749. 	
    2750. 

  2750. 	<div class="method-subsection return">
    2751. 

  2751. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    2752. 

  2752. 		<p><code>YES</code> if currently within transaction; <code>NO</code> if not.</p>
    2753. 

  2753. 	</div>
    2754. 

  2754. 	
    2755. 

  2755. 	
    2756. 

  2756. 	
    2757. 

  2757. 	
    2758. 

  2758. 	
    2759. 

  2759. 	
    2760. 

  2760. 	
    2761. 

  2761. 	
    2762. 

  2762. 	
    2763. 

  2763. 	<div class="method-subsection see-also-section">
    2764. 

  2764. 		<h4 class="method-subtitle">See Also</h4>
    2765. 

  2765. 		<ul>
    2766. 

  2766. 			
    2767. 

  2767. 			<li><code><p><a href="#//api/name/beginTransaction">- beginTransaction</a></p></code></li>
    2768. 

  2768. 			
    2769. 

  2769. 			<li><code><p><a href="#//api/name/beginDeferredTransaction">- beginDeferredTransaction</a></p></code></li>
    2770. 

  2770. 			
    2771. 

  2771. 			<li><code><p><a href="#//api/name/commit">- commit</a></p></code></li>
    2772. 

  2772. 			
    2773. 

  2773. 			<li><code><p><a href="#//api/name/rollback">- rollback</a></p></code></li>
    2774. 

  2774. 			
    2775. 

  2775. 		</ul>
    2776. 

  2776. 	</div>
    2777. 

  2777. 	
    2778. 

  2778. 	
    2779. 

  2779. 	
    2780. 

  2780. 	<div class="method-subsection declared-in-section">
    2781. 

  2781. 		<h4 class="method-subtitle">Declared In</h4>
    2782. 

  2782. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    2783. 

  2783. 	</div>				
    2784. 

  2784. 	
    2785. 

  2785. 	
    2786. 

  2786. </div>
    2787. 

  2787. 						
    2788. 

  2788. 						<div class="section-method">
    2789. 

  2789. 	<a name="//api/name/initWithPath:" title="initWithPath:"></a>
    2790. 

  2790. 	<h3 class="subsubtitle method-title">initWithPath:</h3>
    2791. 

  2791. 	
    2792. 

  2792. 	
    2793. 

  2793. 	
    2794. 

  2794. 	<div class="method-subsection brief-description">
    2795. 

  2795. 		<p>Initialize a <code>FMDatabase</code> object.</p>
    2796. 

  2796. 	</div>		
    2797. 

  2797. 	
    2798. 

  2798.     
    2799. 

  2799. 

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

  2801. 

  2802.     
    2803. 

  2803. 	
    2804. 

  2804. 	<div class="method-subsection arguments-section parameters">
    2805. 

  2805. 		<h4 class="method-subtitle parameter-title">Parameters</h4>
    2806. 

  2806. 		
    2807. 

  2807. 		<dl class="argument-def parameter-def">
    2808. 

  2808. 			<dt><em>inPath</em></dt>
    2809. 

  2809. 			<dd><p>Path of database file</p></dd>
    2810. 

  2810. 		</dl>
    2811. 

  2811. 		
    2812. 

  2812. 	</div>
    2813. 

  2813. 	
    2814. 

  2814. 	
    2815. 

  2815. 	
    2816. 

  2816. 	<div class="method-subsection return">
    2817. 

  2817. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    2818. 

  2818. 		<p><code>FMDatabase</code> object if successful; <code>nil</code> if failure.</p>
    2819. 

  2819. 	</div>
    2820. 

  2820. 	
    2821. 

  2821. 	
    2822. 

  2822. 	
    2823. 

  2823. 	
    2824. 

  2824. 	
    2825. 

  2825. 	<div class="method-subsection discussion-section">
    2826. 

  2826. 		<h4 class="method-subtitle">Discussion</h4>
    2827. 

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

  2828. 

  2829. <ol>
    2830. 

  2830. <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>
    2831. 

  2831. <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>
    2832. 

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

  2833. </ol>
    2834. 

  2834. 

  2835. 

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

  2837. 

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

  2839. </code></pre>
    2840. 

  2840. 

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

  2842. 

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

  2844. NSString *dbPath   = [docsPath stringByAppendingPathComponent:@"test.db"];
    2845. 

  2845. FMDatabase *db     = [FMDatabase databaseWithPath:dbPath];
    2846. 

  2846. </code></pre>
    2847. 

  2847. 

  2848. <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>
    2849. 

  2849. 	</div>
    2850. 

  2850. 	
    2851. 

  2851. 	
    2852. 

  2852. 	
    2853. 

  2853. 	
    2854. 

  2854. 	
    2855. 

  2855. 	
    2856. 

  2856. 	
    2857. 

  2857. 	<div class="method-subsection declared-in-section">
    2858. 

  2858. 		<h4 class="method-subtitle">Declared In</h4>
    2859. 

  2859. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    2860. 

  2860. 	</div>				
    2861. 

  2861. 	
    2862. 

  2862. 	
    2863. 

  2863. </div>
    2864. 

  2864. 						
    2865. 

  2865. 						<div class="section-method">
    2866. 

  2866. 	<a name="//api/name/lastError" title="lastError"></a>
    2867. 

  2867. 	<h3 class="subsubtitle method-title">lastError</h3>
    2868. 

  2868. 	
    2869. 

  2869. 	
    2870. 

  2870. 	
    2871. 

  2871. 	<div class="method-subsection brief-description">
    2872. 

  2872. 		<p>Last error</p>
    2873. 

  2873. 	</div>		
    2874. 

  2874. 	
    2875. 

  2875.     
    2876. 

  2876. 

  2877. 	<div class="method-subsection method-declaration"><code>- (NSError *)lastError</code></div>
    2878. 

  2878. 

  2879.     
    2880. 

  2880. 	
    2881. 

  2881. 	
    2882. 

  2882. 	
    2883. 

  2883. 	<div class="method-subsection return">
    2884. 

  2884. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    2885. 

  2885. 		<p><code>NSError</code> representing the last error.</p>
    2886. 

  2886. 	</div>
    2887. 

  2887. 	
    2888. 

  2888. 	
    2889. 

  2889. 	
    2890. 

  2890. 	
    2891. 

  2891. 	
    2892. 

  2892. 	
    2893. 

  2893. 	
    2894. 

  2894. 	
    2895. 

  2895. 	
    2896. 

  2896. 	<div class="method-subsection see-also-section">
    2897. 

  2897. 		<h4 class="method-subtitle">See Also</h4>
    2898. 

  2898. 		<ul>
    2899. 

  2899. 			
    2900. 

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

  2901. 			
    2902. 

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

  2903. 			
    2904. 

  2904. 		</ul>
    2905. 

  2905. 	</div>
    2906. 

  2906. 	
    2907. 

  2907. 	
    2908. 

  2908. 	
    2909. 

  2909. 	<div class="method-subsection declared-in-section">
    2910. 

  2910. 		<h4 class="method-subtitle">Declared In</h4>
    2911. 

  2911. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    2912. 

  2912. 	</div>				
    2913. 

  2913. 	
    2914. 

  2914. 	
    2915. 

  2915. </div>
    2916. 

  2916. 						
    2917. 

  2917. 						<div class="section-method">
    2918. 

  2918. 	<a name="//api/name/lastErrorCode" title="lastErrorCode"></a>
    2919. 

  2919. 	<h3 class="subsubtitle method-title">lastErrorCode</h3>
    2920. 

  2920. 	
    2921. 

  2921. 	
    2922. 

  2922. 	
    2923. 

  2923. 	<div class="method-subsection brief-description">
    2924. 

  2924. 		<p>Last error code</p>
    2925. 

  2925. 	</div>		
    2926. 

  2926. 	
    2927. 

  2927.     
    2928. 

  2928. 

  2929. 	<div class="method-subsection method-declaration"><code>- (int)lastErrorCode</code></div>
    2930. 

  2930. 

  2931.     
    2932. 

  2932. 	
    2933. 

  2933. 	
    2934. 

  2934. 	
    2935. 

  2935. 	<div class="method-subsection return">
    2936. 

  2936. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    2937. 

  2937. 		<p>Integer value of the last error code.</p>
    2938. 

  2938. 	</div>
    2939. 

  2939. 	
    2940. 

  2940. 	
    2941. 

  2941. 	
    2942. 

  2942. 	
    2943. 

  2943. 	
    2944. 

  2944. 	<div class="method-subsection discussion-section">
    2945. 

  2945. 		<h4 class="method-subtitle">Discussion</h4>
    2946. 

  2946. 		<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>
    2947. 

  2947. 	</div>
    2948. 

  2948. 	
    2949. 

  2949. 	
    2950. 

  2950. 	
    2951. 

  2951. 	
    2952. 

  2952. 	
    2953. 

  2953. 	<div class="method-subsection see-also-section">
    2954. 

  2954. 		<h4 class="method-subtitle">See Also</h4>
    2955. 

  2955. 		<ul>
    2956. 

  2956. 			
    2957. 

  2957. 			<li><code><p><a href="http://sqlite.org/c3ref/errcode.html">sqlite3_errcode()</a></p></code></li>
    2958. 

  2958. 			
    2959. 

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

  2960. 			
    2961. 

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

  2962. 			
    2963. 

  2963. 		</ul>
    2964. 

  2964. 	</div>
    2965. 

  2965. 	
    2966. 

  2966. 	
    2967. 

  2967. 	
    2968. 

  2968. 	<div class="method-subsection declared-in-section">
    2969. 

  2969. 		<h4 class="method-subtitle">Declared In</h4>
    2970. 

  2970. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    2971. 

  2971. 	</div>				
    2972. 

  2972. 	
    2973. 

  2973. 	
    2974. 

  2974. </div>
    2975. 

  2975. 						
    2976. 

  2976. 						<div class="section-method">
    2977. 

  2977. 	<a name="//api/name/lastErrorMessage" title="lastErrorMessage"></a>
    2978. 

  2978. 	<h3 class="subsubtitle method-title">lastErrorMessage</h3>
    2979. 

  2979. 	
    2980. 

  2980. 	
    2981. 

  2981. 	
    2982. 

  2982. 	<div class="method-subsection brief-description">
    2983. 

  2983. 		<p>Last error message</p>
    2984. 

  2984. 	</div>		
    2985. 

  2985. 	
    2986. 

  2986.     
    2987. 

  2987. 

  2988. 	<div class="method-subsection method-declaration"><code>- (NSString *)lastErrorMessage</code></div>
    2989. 

  2989. 

  2990.     
    2991. 

  2991. 	
    2992. 

  2992. 	
    2993. 

  2993. 	
    2994. 

  2994. 	<div class="method-subsection return">
    2995. 

  2995. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    2996. 

  2996. 		<p><code>NSString</code> of the last error message.</p>
    2997. 

  2997. 	</div>
    2998. 

  2998. 	
    2999. 

  2999. 	
    3000. 

  3000. 	
    3001. 

  3001. 	
    3002. 

  3002. 	
    3003. 

  3003. 	<div class="method-subsection discussion-section">
    3004. 

  3004. 		<h4 class="method-subtitle">Discussion</h4>
    3005. 

  3005. 		<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>
    3006. 

  3006. 	</div>
    3007. 

  3007. 	
    3008. 

  3008. 	
    3009. 

  3009. 	
    3010. 

  3010. 	
    3011. 

  3011. 	
    3012. 

  3012. 	<div class="method-subsection see-also-section">
    3013. 

  3013. 		<h4 class="method-subtitle">See Also</h4>
    3014. 

  3014. 		<ul>
    3015. 

  3015. 			
    3016. 

  3016. 			<li><code><p><a href="http://sqlite.org/c3ref/errcode.html">sqlite3_errmsg()</a></p></code></li>
    3017. 

  3017. 			
    3018. 

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

  3019. 			
    3020. 

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

  3021. 			
    3022. 

  3022. 		</ul>
    3023. 

  3023. 	</div>
    3024. 

  3024. 	
    3025. 

  3025. 	
    3026. 

  3026. 	
    3027. 

  3027. 	<div class="method-subsection declared-in-section">
    3028. 

  3028. 		<h4 class="method-subtitle">Declared In</h4>
    3029. 

  3029. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    3030. 

  3030. 	</div>				
    3031. 

  3031. 	
    3032. 

  3032. 	
    3033. 

  3033. </div>
    3034. 

  3034. 						
    3035. 

  3035. 						<div class="section-method">
    3036. 

  3036. 	<a name="//api/name/lastInsertRowId" title="lastInsertRowId"></a>
    3037. 

  3037. 	<h3 class="subsubtitle method-title">lastInsertRowId</h3>
    3038. 

  3038. 	
    3039. 

  3039. 	
    3040. 

  3040. 	
    3041. 

  3041. 	<div class="method-subsection brief-description">
    3042. 

  3042. 		<p>Last insert rowid</p>
    3043. 

  3043. 	</div>		
    3044. 

  3044. 	
    3045. 

  3045.     
    3046. 

  3046. 

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

  3048. 

  3049.     
    3050. 

  3050. 	
    3051. 

  3051. 	
    3052. 

  3052. 	
    3053. 

  3053. 	
    3054. 

  3054. 	
    3055. 

  3055. 	
    3056. 

  3056. 	
    3057. 

  3057. 	<div class="method-subsection discussion-section">
    3058. 

  3058. 		<h4 class="method-subtitle">Discussion</h4>
    3059. 

  3059. 		<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>
    3060. 

  3060. 

  3061. <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>
    3062. 

  3062. 	</div>
    3063. 

  3063. 	
    3064. 

  3064. 	
    3065. 

  3065. 	
    3066. 

  3066. 	
    3067. 

  3067. 	
    3068. 

  3068. 	<div class="method-subsection see-also-section">
    3069. 

  3069. 		<h4 class="method-subtitle">See Also</h4>
    3070. 

  3070. 		<ul>
    3071. 

  3071. 			
    3072. 

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

  3073. 			
    3074. 

  3074. 		</ul>
    3075. 

  3075. 	</div>
    3076. 

  3076. 	
    3077. 

  3077. 	
    3078. 

  3078. 	
    3079. 

  3079. 	<div class="method-subsection declared-in-section">
    3080. 

  3080. 		<h4 class="method-subtitle">Declared In</h4>
    3081. 

  3081. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    3082. 

  3082. 	</div>				
    3083. 

  3083. 	
    3084. 

  3084. 	
    3085. 

  3085. </div>
    3086. 

  3086. 						
    3087. 

  3087. 						<div class="section-method">
    3088. 

  3088. 	<a name="//api/name/makeFunctionNamed:maximumArguments:withBlock:" title="makeFunctionNamed:maximumArguments:withBlock:"></a>
    3089. 

  3089. 	<h3 class="subsubtitle method-title">makeFunctionNamed:maximumArguments:withBlock:</h3>
    3090. 

  3090. 	
    3091. 

  3091. 	
    3092. 

  3092. 	
    3093. 

  3093. 	<div class="method-subsection brief-description">
    3094. 

  3094. 		<p>Adds SQL functions or aggregates or to redefine the behavior of existing SQL functions or aggregates.</p>
    3095. 

  3095. 	</div>		
    3096. 

  3096. 	
    3097. 

  3097.     
    3098. 

  3098. 

  3099. 	<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>
    3100. 

  3100. 

  3101.     
    3102. 

  3102. 	
    3103. 

  3103. 	<div class="method-subsection arguments-section parameters">
    3104. 

  3104. 		<h4 class="method-subtitle parameter-title">Parameters</h4>
    3105. 

  3105. 		
    3106. 

  3106. 		<dl class="argument-def parameter-def">
    3107. 

  3107. 			<dt><em>name</em></dt>
    3108. 

  3108. 			<dd><p>Name of function</p></dd>
    3109. 

  3109. 		</dl>
    3110. 

  3110. 		
    3111. 

  3111. 		<dl class="argument-def parameter-def">
    3112. 

  3112. 			<dt><em>count</em></dt>
    3113. 

  3113. 			<dd><p>Maximum number of parameters</p></dd>
    3114. 

  3114. 		</dl>
    3115. 

  3115. 		
    3116. 

  3116. 		<dl class="argument-def parameter-def">
    3117. 

  3117. 			<dt><em>block</em></dt>
    3118. 

  3118. 			<dd><p>The block of code for the function</p></dd>
    3119. 

  3119. 		</dl>
    3120. 

  3120. 		
    3121. 

  3121. 	</div>
    3122. 

  3122. 	
    3123. 

  3123. 	
    3124. 

  3124. 	
    3125. 

  3125. 	
    3126. 

  3126. 	
    3127. 

  3127. 	
    3128. 

  3128. 	
    3129. 

  3129. 	<div class="method-subsection discussion-section">
    3130. 

  3130. 		<h4 class="method-subtitle">Discussion</h4>
    3131. 

  3131. 		<p>For example:</p>
    3132. 

  3132. 

  3133. <pre><code>[queue inDatabase:^(FMDatabase *adb) {
    3134. 

  3134. 

  3135.     [adb executeUpdate:@"create table ftest (foo text)"];
    3136. 

  3136.     [adb executeUpdate:@"insert into ftest values ('hello')"];
    3137. 

  3137.     [adb executeUpdate:@"insert into ftest values ('hi')"];
    3138. 

  3138.     [adb executeUpdate:@"insert into ftest values ('not h!')"];
    3139. 

  3139.     [adb executeUpdate:@"insert into ftest values ('definitely not h!')"];
    3140. 

  3140. 

  3141.     [adb makeFunctionNamed:@"StringStartsWithH" maximumArguments:1 withBlock:^(sqlite3_context *context, int aargc, sqlite3_value **aargv) {
    3142. 

  3142.         if (sqlite3_value_type(aargv[0]) == SQLITE_TEXT) {
    3143. 

  3143.             @autoreleasepool {
    3144. 

  3144.                 const char *c = (const char *)sqlite3_value_text(aargv[0]);
    3145. 

  3145.                 NSString *s = [NSString stringWithUTF8String:c];
    3146. 

  3146.                 sqlite3_result_int(context, [s hasPrefix:@"h"]);
    3147. 

  3147.             }
    3148. 

  3148.         }
    3149. 

  3149.         else {
    3150. 

  3150.             NSLog(@"Unknown formart for StringStartsWithH (%d) %s:%d", sqlite3_value_type(aargv[0]), __FUNCTION__, __LINE__);
    3151. 

  3151.             sqlite3_result_null(context);
    3152. 

  3152.         }
    3153. 

  3153.     }];
    3154. 

  3154. 

  3155.     int rowCount = 0;
    3156. 

  3156.     FMResultSet *ars = [adb executeQuery:@"select * from ftest where StringStartsWithH(foo)"];
    3157. 

  3157.     while ([ars next]) {
    3158. 

  3158.         rowCount++;
    3159. 

  3159.         NSLog(@"Does %@ start with 'h'?", [rs stringForColumnIndex:0]);
    3160. 

  3160.     }
    3161. 

  3161.     FMDBQuickCheck(rowCount == 2);
    3162. 

  3162. }];
    3163. 

  3163. </code></pre>
    3164. 

  3164. 	</div>
    3165. 

  3165. 	
    3166. 

  3166. 	
    3167. 

  3167. 	
    3168. 

  3168. 	
    3169. 

  3169. 	
    3170. 

  3170. 	<div class="method-subsection see-also-section">
    3171. 

  3171. 		<h4 class="method-subtitle">See Also</h4>
    3172. 

  3172. 		<ul>
    3173. 

  3173. 			
    3174. 

  3174. 			<li><code><p><a href="http://sqlite.org/c3ref/create_function.html">sqlite3_create_function()</a></p></code></li>
    3175. 

  3175. 			
    3176. 

  3176. 		</ul>
    3177. 

  3177. 	</div>
    3178. 

  3178. 	
    3179. 

  3179. 	
    3180. 

  3180. 	
    3181. 

  3181. 	<div class="method-subsection declared-in-section">
    3182. 

  3182. 		<h4 class="method-subtitle">Declared In</h4>
    3183. 

  3183. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    3184. 

  3184. 	</div>				
    3185. 

  3185. 	
    3186. 

  3186. 	
    3187. 

  3187. </div>
    3188. 

  3188. 						
    3189. 

  3189. 						<div class="section-method">
    3190. 

  3190. 	<a name="//api/name/open" title="open"></a>
    3191. 

  3191. 	<h3 class="subsubtitle method-title">open</h3>
    3192. 

  3192. 	
    3193. 

  3193. 	
    3194. 

  3194. 	
    3195. 

  3195. 	<div class="method-subsection brief-description">
    3196. 

  3196. 		<p>Opening a new database connection</p>
    3197. 

  3197. 	</div>		
    3198. 

  3198. 	
    3199. 

  3199.     
    3200. 

  3200. 

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

  3202. 

  3203.     
    3204. 

  3204. 	
    3205. 

  3205. 	
    3206. 

  3206. 	
    3207. 

  3207. 	<div class="method-subsection return">
    3208. 

  3208. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    3209. 

  3209. 		<p><code>YES</code> if successful, <code>NO</code> on error.</p>
    3210. 

  3210. 	</div>
    3211. 

  3211. 	
    3212. 

  3212. 	
    3213. 

  3213. 	
    3214. 

  3214. 	
    3215. 

  3215. 	
    3216. 

  3216. 	<div class="method-subsection discussion-section">
    3217. 

  3217. 		<h4 class="method-subtitle">Discussion</h4>
    3218. 

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

  3219. 	</div>
    3220. 

  3220. 	
    3221. 

  3221. 	
    3222. 

  3222. 	
    3223. 

  3223. 	
    3224. 

  3224. 	
    3225. 

  3225. 	<div class="method-subsection see-also-section">
    3226. 

  3226. 		<h4 class="method-subtitle">See Also</h4>
    3227. 

  3227. 		<ul>
    3228. 

  3228. 			
    3229. 

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

  3230. 			
    3231. 

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

  3232. 			
    3233. 

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

  3234. 			
    3235. 

  3235. 		</ul>
    3236. 

  3236. 	</div>
    3237. 

  3237. 	
    3238. 

  3238. 	
    3239. 

  3239. 	
    3240. 

  3240. 	<div class="method-subsection declared-in-section">
    3241. 

  3241. 		<h4 class="method-subtitle">Declared In</h4>
    3242. 

  3242. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    3243. 

  3243. 	</div>				
    3244. 

  3244. 	
    3245. 

  3245. 	
    3246. 

  3246. </div>
    3247. 

  3247. 						
    3248. 

  3248. 						<div class="section-method">
    3249. 

  3249. 	<a name="//api/name/openWithFlags:" title="openWithFlags:"></a>
    3250. 

  3250. 	<h3 class="subsubtitle method-title">openWithFlags:</h3>
    3251. 

  3251. 	
    3252. 

  3252. 	
    3253. 

  3253. 	
    3254. 

  3254. 	<div class="method-subsection brief-description">
    3255. 

  3255. 		<p>Opening a new database connection with flags</p>
    3256. 

  3256. 	</div>		
    3257. 

  3257. 	
    3258. 

  3258.     
    3259. 

  3259. 

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

  3261. 

  3262.     
    3263. 

  3263. 	
    3264. 

  3264. 	<div class="method-subsection arguments-section parameters">
    3265. 

  3265. 		<h4 class="method-subtitle parameter-title">Parameters</h4>
    3266. 

  3266. 		
    3267. 

  3267. 		<dl class="argument-def parameter-def">
    3268. 

  3268. 			<dt><em>flags</em></dt>
    3269. 

  3269. 			<dd><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>
    3270. 

  3270. 

  3271. <p><code>SQLITE_OPEN_READONLY</code></p>
    3272. 

  3272. 

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

  3274. 

  3275. <p><code>SQLITE_OPEN_READWRITE</code></p>
    3276. 

  3276. 

  3277. <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>
    3278. 

  3278. 

  3279. <p><code>SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE</code></p>
    3280. 

  3280. 

  3281. <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></dd>
    3282. 

  3282. 		</dl>
    3283. 

  3283. 		
    3284. 

  3284. 	</div>
    3285. 

  3285. 	
    3286. 

  3286. 	
    3287. 

  3287. 	
    3288. 

  3288. 	<div class="method-subsection return">
    3289. 

  3289. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    3290. 

  3290. 		<p><code>YES</code> if successful, <code>NO</code> on error.</p>
    3291. 

  3291. 	</div>
    3292. 

  3292. 	
    3293. 

  3293. 	
    3294. 

  3294. 	
    3295. 

  3295. 	
    3296. 

  3296. 	
    3297. 

  3297. 	
    3298. 

  3298. 	
    3299. 

  3299. 	
    3300. 

  3300. 	
    3301. 

  3301. 	<div class="method-subsection see-also-section">
    3302. 

  3302. 		<h4 class="method-subtitle">See Also</h4>
    3303. 

  3303. 		<ul>
    3304. 

  3304. 			
    3305. 

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

  3306. 			
    3307. 

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

  3308. 			
    3309. 

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

  3310. 			
    3311. 

  3311. 		</ul>
    3312. 

  3312. 	</div>
    3313. 

  3313. 	
    3314. 

  3314. 	
    3315. 

  3315. 	
    3316. 

  3316. 	<div class="method-subsection declared-in-section">
    3317. 

  3317. 		<h4 class="method-subtitle">Declared In</h4>
    3318. 

  3318. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    3319. 

  3319. 	</div>				
    3320. 

  3320. 	
    3321. 

  3321. 	
    3322. 

  3322. </div>
    3323. 

  3323. 						
    3324. 

  3324. 						<div class="section-method">
    3325. 

  3325. 	<a name="//api/name/rekey:" title="rekey:"></a>
    3326. 

  3326. 	<h3 class="subsubtitle method-title">rekey:</h3>
    3327. 

  3327. 	
    3328. 

  3328. 	
    3329. 

  3329. 	
    3330. 

  3330. 	<div class="method-subsection brief-description">
    3331. 

  3331. 		<p>Reset encryption key</p>
    3332. 

  3332. 	</div>		
    3333. 

  3333. 	
    3334. 

  3334.     
    3335. 

  3335. 

  3336. 	<div class="method-subsection method-declaration"><code>- (BOOL)rekey:(NSString *)<em>key</em></code></div>
    3337. 

  3337. 

  3338.     
    3339. 

  3339. 	
    3340. 

  3340. 	<div class="method-subsection arguments-section parameters">
    3341. 

  3341. 		<h4 class="method-subtitle parameter-title">Parameters</h4>
    3342. 

  3342. 		
    3343. 

  3343. 		<dl class="argument-def parameter-def">
    3344. 

  3344. 			<dt><em>key</em></dt>
    3345. 

  3345. 			<dd><p>The key to be used.</p></dd>
    3346. 

  3346. 		</dl>
    3347. 

  3347. 		
    3348. 

  3348. 	</div>
    3349. 

  3349. 	
    3350. 

  3350. 	
    3351. 

  3351. 	
    3352. 

  3352. 	<div class="method-subsection return">
    3353. 

  3353. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    3354. 

  3354. 		<p><code>YES</code> if success, <code>NO</code> on error.</p>
    3355. 

  3355. 	</div>
    3356. 

  3356. 	
    3357. 

  3357. 	
    3358. 

  3358. 	
    3359. 

  3359. 	
    3360. 

  3360. 	
    3361. 

  3361. 	<div class="method-subsection discussion-section">
    3362. 

  3362. 		<h4 class="method-subtitle">Discussion</h4>
    3363. 

  3363. 		<div class="warning"><p><strong>Warning:</strong> You need to have purchased the sqlite encryption extensions for this method to work.</p></div>
    3364. 

  3364. 	</div>
    3365. 

  3365. 	
    3366. 

  3366. 	
    3367. 

  3367. 	
    3368. 

  3368. 	
    3369. 

  3369. 	
    3370. 

  3370. 	<div class="method-subsection see-also-section">
    3371. 

  3371. 		<h4 class="method-subtitle">See Also</h4>
    3372. 

  3372. 		<ul>
    3373. 

  3373. 			
    3374. 

  3374. 			<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>
    3375. 

  3375. 			
    3376. 

  3376. 		</ul>
    3377. 

  3377. 	</div>
    3378. 

  3378. 	
    3379. 

  3379. 	
    3380. 

  3380. 	
    3381. 

  3381. 	<div class="method-subsection declared-in-section">
    3382. 

  3382. 		<h4 class="method-subtitle">Declared In</h4>
    3383. 

  3383. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    3384. 

  3384. 	</div>				
    3385. 

  3385. 	
    3386. 

  3386. 	
    3387. 

  3387. </div>
    3388. 

  3388. 						
    3389. 

  3389. 						<div class="section-method">
    3390. 

  3390. 	<a name="//api/name/rekeyWithData:" title="rekeyWithData:"></a>
    3391. 

  3391. 	<h3 class="subsubtitle method-title">rekeyWithData:</h3>
    3392. 

  3392. 	
    3393. 

  3393. 	
    3394. 

  3394. 	
    3395. 

  3395. 	<div class="method-subsection brief-description">
    3396. 

  3396. 		<p>Reset encryption key using <code>keyData</code>.</p>
    3397. 

  3397. 	</div>		
    3398. 

  3398. 	
    3399. 

  3399.     
    3400. 

  3400. 

  3401. 	<div class="method-subsection method-declaration"><code>- (BOOL)rekeyWithData:(NSData *)<em>keyData</em></code></div>
    3402. 

  3402. 

  3403.     
    3404. 

  3404. 	
    3405. 

  3405. 	<div class="method-subsection arguments-section parameters">
    3406. 

  3406. 		<h4 class="method-subtitle parameter-title">Parameters</h4>
    3407. 

  3407. 		
    3408. 

  3408. 		<dl class="argument-def parameter-def">
    3409. 

  3409. 			<dt><em>keyData</em></dt>
    3410. 

  3410. 			<dd><p>The <code>NSData</code> to be used.</p></dd>
    3411. 

  3411. 		</dl>
    3412. 

  3412. 		
    3413. 

  3413. 	</div>
    3414. 

  3414. 	
    3415. 

  3415. 	
    3416. 

  3416. 	
    3417. 

  3417. 	<div class="method-subsection return">
    3418. 

  3418. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    3419. 

  3419. 		<p><code>YES</code> if success, <code>NO</code> on error.</p>
    3420. 

  3420. 	</div>
    3421. 

  3421. 	
    3422. 

  3422. 	
    3423. 

  3423. 	
    3424. 

  3424. 	
    3425. 

  3425. 	
    3426. 

  3426. 	<div class="method-subsection discussion-section">
    3427. 

  3427. 		<h4 class="method-subtitle">Discussion</h4>
    3428. 

  3428. 		<div class="warning"><p><strong>Warning:</strong> You need to have purchased the sqlite encryption extensions for this method to work.</p></div>
    3429. 

  3429. 	</div>
    3430. 

  3430. 	
    3431. 

  3431. 	
    3432. 

  3432. 	
    3433. 

  3433. 	
    3434. 

  3434. 	
    3435. 

  3435. 	<div class="method-subsection see-also-section">
    3436. 

  3436. 		<h4 class="method-subtitle">See Also</h4>
    3437. 

  3437. 		<ul>
    3438. 

  3438. 			
    3439. 

  3439. 			<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>
    3440. 

  3440. 			
    3441. 

  3441. 		</ul>
    3442. 

  3442. 	</div>
    3443. 

  3443. 	
    3444. 

  3444. 	
    3445. 

  3445. 	
    3446. 

  3446. 	<div class="method-subsection declared-in-section">
    3447. 

  3447. 		<h4 class="method-subtitle">Declared In</h4>
    3448. 

  3448. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    3449. 

  3449. 	</div>				
    3450. 

  3450. 	
    3451. 

  3451. 	
    3452. 

  3452. </div>
    3453. 

  3453. 						
    3454. 

  3454. 						<div class="section-method">
    3455. 

  3455. 	<a name="//api/name/releaseSavePointWithName:error:" title="releaseSavePointWithName:error:"></a>
    3456. 

  3456. 	<h3 class="subsubtitle method-title">releaseSavePointWithName:error:</h3>
    3457. 

  3457. 	
    3458. 

  3458. 	
    3459. 

  3459. 	
    3460. 

  3460. 	<div class="method-subsection brief-description">
    3461. 

  3461. 		<p>Release save point</p>
    3462. 

  3462. 	</div>		
    3463. 

  3463. 	
    3464. 

  3464.     
    3465. 

  3465. 

  3466. 	<div class="method-subsection method-declaration"><code>- (BOOL)releaseSavePointWithName:(NSString *)<em>name</em> error:(NSError **)<em>outErr</em></code></div>
    3467. 

  3467. 

  3468.     
    3469. 

  3469. 	
    3470. 

  3470. 	<div class="method-subsection arguments-section parameters">
    3471. 

  3471. 		<h4 class="method-subtitle parameter-title">Parameters</h4>
    3472. 

  3472. 		
    3473. 

  3473. 		<dl class="argument-def parameter-def">
    3474. 

  3474. 			<dt><em>name</em></dt>
    3475. 

  3475. 			<dd><p>Name of save point.</p></dd>
    3476. 

  3476. 		</dl>
    3477. 

  3477. 		
    3478. 

  3478. 		<dl class="argument-def parameter-def">
    3479. 

  3479. 			<dt><em>outErr</em></dt>
    3480. 

  3480. 			<dd><p>A <code>NSError</code> object to receive any error object (if any).</p></dd>
    3481. 

  3481. 		</dl>
    3482. 

  3482. 		
    3483. 

  3483. 	</div>
    3484. 

  3484. 	
    3485. 

  3485. 	
    3486. 

  3486. 	
    3487. 

  3487. 	<div class="method-subsection return">
    3488. 

  3488. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    3489. 

  3489. 		<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>
    3490. 

  3490. 	</div>
    3491. 

  3491. 	
    3492. 

  3492. 	
    3493. 

  3493. 	
    3494. 

  3494. 	
    3495. 

  3495. 	
    3496. 

  3496. 	
    3497. 

  3497. 	
    3498. 

  3498. 	
    3499. 

  3499. 	
    3500. 

  3500. 	<div class="method-subsection see-also-section">
    3501. 

  3501. 		<h4 class="method-subtitle">See Also</h4>
    3502. 

  3502. 		<ul>
    3503. 

  3503. 			
    3504. 

  3504. 			<li><code><p><a href="#//api/name/startSavePointWithName:error:">- startSavePointWithName:error:</a></p></code></li>
    3505. 

  3505. 			
    3506. 

  3506. 			<li><code><p><a href="#//api/name/rollbackToSavePointWithName:error:">- rollbackToSavePointWithName:error:</a></p></code></li>
    3507. 

  3507. 			
    3508. 

  3508. 		</ul>
    3509. 

  3509. 	</div>
    3510. 

  3510. 	
    3511. 

  3511. 	
    3512. 

  3512. 	
    3513. 

  3513. 	<div class="method-subsection declared-in-section">
    3514. 

  3514. 		<h4 class="method-subtitle">Declared In</h4>
    3515. 

  3515. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    3516. 

  3516. 	</div>				
    3517. 

  3517. 	
    3518. 

  3518. 	
    3519. 

  3519. </div>
    3520. 

  3520. 						
    3521. 

  3521. 						<div class="section-method">
    3522. 

  3522. 	<a name="//api/name/rollback" title="rollback"></a>
    3523. 

  3523. 	<h3 class="subsubtitle method-title">rollback</h3>
    3524. 

  3524. 	
    3525. 

  3525. 	
    3526. 

  3526. 	
    3527. 

  3527. 	<div class="method-subsection brief-description">
    3528. 

  3528. 		<p>Rollback a transaction</p>
    3529. 

  3529. 	</div>		
    3530. 

  3530. 	
    3531. 

  3531.     
    3532. 

  3532. 

  3533. 	<div class="method-subsection method-declaration"><code>- (BOOL)rollback</code></div>
    3534. 

  3534. 

  3535.     
    3536. 

  3536. 	
    3537. 

  3537. 	
    3538. 

  3538. 	
    3539. 

  3539. 	<div class="method-subsection return">
    3540. 

  3540. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    3541. 

  3541. 		<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>
    3542. 

  3542. 	</div>
    3543. 

  3543. 	
    3544. 

  3544. 	
    3545. 

  3545. 	
    3546. 

  3546. 	
    3547. 

  3547. 	
    3548. 

  3548. 	<div class="method-subsection discussion-section">
    3549. 

  3549. 		<h4 class="method-subtitle">Discussion</h4>
    3550. 

  3550. 		<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>
    3551. 

  3551. 	</div>
    3552. 

  3552. 	
    3553. 

  3553. 	
    3554. 

  3554. 	
    3555. 

  3555. 	
    3556. 

  3556. 	
    3557. 

  3557. 	<div class="method-subsection see-also-section">
    3558. 

  3558. 		<h4 class="method-subtitle">See Also</h4>
    3559. 

  3559. 		<ul>
    3560. 

  3560. 			
    3561. 

  3561. 			<li><code><p><a href="#//api/name/beginTransaction">- beginTransaction</a></p></code></li>
    3562. 

  3562. 			
    3563. 

  3563. 			<li><code><p><a href="#//api/name/beginDeferredTransaction">- beginDeferredTransaction</a></p></code></li>
    3564. 

  3564. 			
    3565. 

  3565. 			<li><code><p><a href="#//api/name/commit">- commit</a></p></code></li>
    3566. 

  3566. 			
    3567. 

  3567. 			<li><code><p><a href="#//api/name/inTransaction">- inTransaction</a></p></code></li>
    3568. 

  3568. 			
    3569. 

  3569. 		</ul>
    3570. 

  3570. 	</div>
    3571. 

  3571. 	
    3572. 

  3572. 	
    3573. 

  3573. 	
    3574. 

  3574. 	<div class="method-subsection declared-in-section">
    3575. 

  3575. 		<h4 class="method-subtitle">Declared In</h4>
    3576. 

  3576. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    3577. 

  3577. 	</div>				
    3578. 

  3578. 	
    3579. 

  3579. 	
    3580. 

  3580. </div>
    3581. 

  3581. 						
    3582. 

  3582. 						<div class="section-method">
    3583. 

  3583. 	<a name="//api/name/rollbackToSavePointWithName:error:" title="rollbackToSavePointWithName:error:"></a>
    3584. 

  3584. 	<h3 class="subsubtitle method-title">rollbackToSavePointWithName:error:</h3>
    3585. 

  3585. 	
    3586. 

  3586. 	
    3587. 

  3587. 	
    3588. 

  3588. 	<div class="method-subsection brief-description">
    3589. 

  3589. 		<p>Roll back to save point</p>
    3590. 

  3590. 	</div>		
    3591. 

  3591. 	
    3592. 

  3592.     
    3593. 

  3593. 

  3594. 	<div class="method-subsection method-declaration"><code>- (BOOL)rollbackToSavePointWithName:(NSString *)<em>name</em> error:(NSError **)<em>outErr</em></code></div>
    3595. 

  3595. 

  3596.     
    3597. 

  3597. 	
    3598. 

  3598. 	<div class="method-subsection arguments-section parameters">
    3599. 

  3599. 		<h4 class="method-subtitle parameter-title">Parameters</h4>
    3600. 

  3600. 		
    3601. 

  3601. 		<dl class="argument-def parameter-def">
    3602. 

  3602. 			<dt><em>name</em></dt>
    3603. 

  3603. 			<dd><p>Name of save point.</p></dd>
    3604. 

  3604. 		</dl>
    3605. 

  3605. 		
    3606. 

  3606. 		<dl class="argument-def parameter-def">
    3607. 

  3607. 			<dt><em>outErr</em></dt>
    3608. 

  3608. 			<dd><p>A <code>NSError</code> object to receive any error object (if any).</p></dd>
    3609. 

  3609. 		</dl>
    3610. 

  3610. 		
    3611. 

  3611. 	</div>
    3612. 

  3612. 	
    3613. 

  3613. 	
    3614. 

  3614. 	
    3615. 

  3615. 	<div class="method-subsection return">
    3616. 

  3616. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    3617. 

  3617. 		<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>
    3618. 

  3618. 	</div>
    3619. 

  3619. 	
    3620. 

  3620. 	
    3621. 

  3621. 	
    3622. 

  3622. 	
    3623. 

  3623. 	
    3624. 

  3624. 	
    3625. 

  3625. 	
    3626. 

  3626. 	
    3627. 

  3627. 	
    3628. 

  3628. 	<div class="method-subsection see-also-section">
    3629. 

  3629. 		<h4 class="method-subtitle">See Also</h4>
    3630. 

  3630. 		<ul>
    3631. 

  3631. 			
    3632. 

  3632. 			<li><code><p><a href="#//api/name/startSavePointWithName:error:">- startSavePointWithName:error:</a></p></code></li>
    3633. 

  3633. 			
    3634. 

  3634. 			<li><code><p><a href="#//api/name/releaseSavePointWithName:error:">- releaseSavePointWithName:error:</a></p></code></li>
    3635. 

  3635. 			
    3636. 

  3636. 		</ul>
    3637. 

  3637. 	</div>
    3638. 

  3638. 	
    3639. 

  3639. 	
    3640. 

  3640. 	
    3641. 

  3641. 	<div class="method-subsection declared-in-section">
    3642. 

  3642. 		<h4 class="method-subtitle">Declared In</h4>
    3643. 

  3643. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    3644. 

  3644. 	</div>				
    3645. 

  3645. 	
    3646. 

  3646. 	
    3647. 

  3647. </div>
    3648. 

  3648. 						
    3649. 

  3649. 						<div class="section-method">
    3650. 

  3650. 	<a name="//api/name/setDateFormat:" title="setDateFormat:"></a>
    3651. 

  3651. 	<h3 class="subsubtitle method-title">setDateFormat:</h3>
    3652. 

  3652. 	
    3653. 

  3653. 	
    3654. 

  3654. 	
    3655. 

  3655. 	<div class="method-subsection brief-description">
    3656. 

  3656. 		<p>Set to a date formatter to use string dates with sqlite instead of the default UNIX timestamps.</p>
    3657. 

  3657. 	</div>		
    3658. 

  3658. 	
    3659. 

  3659.     
    3660. 

  3660. 

  3661. 	<div class="method-subsection method-declaration"><code>- (void)setDateFormat:(NSDateFormatter *)<em>format</em></code></div>
    3662. 

  3662. 

  3663.     
    3664. 

  3664. 	
    3665. 

  3665. 	<div class="method-subsection arguments-section parameters">
    3666. 

  3666. 		<h4 class="method-subtitle parameter-title">Parameters</h4>
    3667. 

  3667. 		
    3668. 

  3668. 		<dl class="argument-def parameter-def">
    3669. 

  3669. 			<dt><em>format</em></dt>
    3670. 

  3670. 			<dd><p>Set to nil to use UNIX timestamps. Defaults to nil. Should be set using a formatter generated using FMDatabase::storeableDateFormat.</p></dd>
    3671. 

  3671. 		</dl>
    3672. 

  3672. 		
    3673. 

  3673. 	</div>
    3674. 

  3674. 	
    3675. 

  3675. 	
    3676. 

  3676. 	
    3677. 

  3677. 	
    3678. 

  3678. 	
    3679. 

  3679. 	
    3680. 

  3680. 	
    3681. 

  3681. 	<div class="method-subsection discussion-section">
    3682. 

  3682. 		<h4 class="method-subtitle">Discussion</h4>
    3683. 

  3683. 		<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>
    3684. 

  3684. 	</div>
    3685. 

  3685. 	
    3686. 

  3686. 	
    3687. 

  3687. 	
    3688. 

  3688. 	
    3689. 

  3689. 	
    3690. 

  3690. 	<div class="method-subsection see-also-section">
    3691. 

  3691. 		<h4 class="method-subtitle">See Also</h4>
    3692. 

  3692. 		<ul>
    3693. 

  3693. 			
    3694. 

  3694. 			<li><code><p><a href="#//api/name/hasDateFormatter">- hasDateFormatter</a></p></code></li>
    3695. 

  3695. 			
    3696. 

  3696. 			<li><code><p><a href="#//api/name/setDateFormat:">- setDateFormat:</a></p></code></li>
    3697. 

  3697. 			
    3698. 

  3698. 			<li><code><p><a href="#//api/name/dateFromString:">- dateFromString:</a></p></code></li>
    3699. 

  3699. 			
    3700. 

  3700. 			<li><code><p><a href="#//api/name/stringFromDate:">- stringFromDate:</a></p></code></li>
    3701. 

  3701. 			
    3702. 

  3702. 			<li><code><p><a href="#//api/name/storeableDateFormat:">+ storeableDateFormat:</a></p></code></li>
    3703. 

  3703. 			
    3704. 

  3704. 		</ul>
    3705. 

  3705. 	</div>
    3706. 

  3706. 	
    3707. 

  3707. 	
    3708. 

  3708. 	
    3709. 

  3709. 	<div class="method-subsection declared-in-section">
    3710. 

  3710. 		<h4 class="method-subtitle">Declared In</h4>
    3711. 

  3711. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    3712. 

  3712. 	</div>				
    3713. 

  3713. 	
    3714. 

  3714. 	
    3715. 

  3715. </div>
    3716. 

  3716. 						
    3717. 

  3717. 						<div class="section-method">
    3718. 

  3718. 	<a name="//api/name/setKey:" title="setKey:"></a>
    3719. 

  3719. 	<h3 class="subsubtitle method-title">setKey:</h3>
    3720. 

  3720. 	
    3721. 

  3721. 	
    3722. 

  3722. 	
    3723. 

  3723. 	<div class="method-subsection brief-description">
    3724. 

  3724. 		<p>Set encryption key.</p>
    3725. 

  3725. 	</div>		
    3726. 

  3726. 	
    3727. 

  3727.     
    3728. 

  3728. 

  3729. 	<div class="method-subsection method-declaration"><code>- (BOOL)setKey:(NSString *)<em>key</em></code></div>
    3730. 

  3730. 

  3731.     
    3732. 

  3732. 	
    3733. 

  3733. 	<div class="method-subsection arguments-section parameters">
    3734. 

  3734. 		<h4 class="method-subtitle parameter-title">Parameters</h4>
    3735. 

  3735. 		
    3736. 

  3736. 		<dl class="argument-def parameter-def">
    3737. 

  3737. 			<dt><em>key</em></dt>
    3738. 

  3738. 			<dd><p>The key to be used.</p></dd>
    3739. 

  3739. 		</dl>
    3740. 

  3740. 		
    3741. 

  3741. 	</div>
    3742. 

  3742. 	
    3743. 

  3743. 	
    3744. 

  3744. 	
    3745. 

  3745. 	<div class="method-subsection return">
    3746. 

  3746. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    3747. 

  3747. 		<p><code>YES</code> if success, <code>NO</code> on error.</p>
    3748. 

  3748. 	</div>
    3749. 

  3749. 	
    3750. 

  3750. 	
    3751. 

  3751. 	
    3752. 

  3752. 	
    3753. 

  3753. 	
    3754. 

  3754. 	<div class="method-subsection discussion-section">
    3755. 

  3755. 		<h4 class="method-subtitle">Discussion</h4>
    3756. 

  3756. 		<div class="warning"><p><strong>Warning:</strong> You need to have purchased the sqlite encryption extensions for this method to work.</p></div>
    3757. 

  3757. 	</div>
    3758. 

  3758. 	
    3759. 

  3759. 	
    3760. 

  3760. 	
    3761. 

  3761. 	
    3762. 

  3762. 	
    3763. 

  3763. 	<div class="method-subsection see-also-section">
    3764. 

  3764. 		<h4 class="method-subtitle">See Also</h4>
    3765. 

  3765. 		<ul>
    3766. 

  3766. 			
    3767. 

  3767. 			<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>
    3768. 

  3768. 			
    3769. 

  3769. 		</ul>
    3770. 

  3770. 	</div>
    3771. 

  3771. 	
    3772. 

  3772. 	
    3773. 

  3773. 	
    3774. 

  3774. 	<div class="method-subsection declared-in-section">
    3775. 

  3775. 		<h4 class="method-subtitle">Declared In</h4>
    3776. 

  3776. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    3777. 

  3777. 	</div>				
    3778. 

  3778. 	
    3779. 

  3779. 	
    3780. 

  3780. </div>
    3781. 

  3781. 						
    3782. 

  3782. 						<div class="section-method">
    3783. 

  3783. 	<a name="//api/name/setKeyWithData:" title="setKeyWithData:"></a>
    3784. 

  3784. 	<h3 class="subsubtitle method-title">setKeyWithData:</h3>
    3785. 

  3785. 	
    3786. 

  3786. 	
    3787. 

  3787. 	
    3788. 

  3788. 	<div class="method-subsection brief-description">
    3789. 

  3789. 		<p>Set encryption key using <code>keyData</code>.</p>
    3790. 

  3790. 	</div>		
    3791. 

  3791. 	
    3792. 

  3792.     
    3793. 

  3793. 

  3794. 	<div class="method-subsection method-declaration"><code>- (BOOL)setKeyWithData:(NSData *)<em>keyData</em></code></div>
    3795. 

  3795. 

  3796.     
    3797. 

  3797. 	
    3798. 

  3798. 	<div class="method-subsection arguments-section parameters">
    3799. 

  3799. 		<h4 class="method-subtitle parameter-title">Parameters</h4>
    3800. 

  3800. 		
    3801. 

  3801. 		<dl class="argument-def parameter-def">
    3802. 

  3802. 			<dt><em>keyData</em></dt>
    3803. 

  3803. 			<dd><p>The <code>NSData</code> to be used.</p></dd>
    3804. 

  3804. 		</dl>
    3805. 

  3805. 		
    3806. 

  3806. 	</div>
    3807. 

  3807. 	
    3808. 

  3808. 	
    3809. 

  3809. 	
    3810. 

  3810. 	<div class="method-subsection return">
    3811. 

  3811. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    3812. 

  3812. 		<p><code>YES</code> if success, <code>NO</code> on error.</p>
    3813. 

  3813. 	</div>
    3814. 

  3814. 	
    3815. 

  3815. 	
    3816. 

  3816. 	
    3817. 

  3817. 	
    3818. 

  3818. 	
    3819. 

  3819. 	<div class="method-subsection discussion-section">
    3820. 

  3820. 		<h4 class="method-subtitle">Discussion</h4>
    3821. 

  3821. 		<div class="warning"><p><strong>Warning:</strong> You need to have purchased the sqlite encryption extensions for this method to work.</p></div>
    3822. 

  3822. 	</div>
    3823. 

  3823. 	
    3824. 

  3824. 	
    3825. 

  3825. 	
    3826. 

  3826. 	
    3827. 

  3827. 	
    3828. 

  3828. 	<div class="method-subsection see-also-section">
    3829. 

  3829. 		<h4 class="method-subtitle">See Also</h4>
    3830. 

  3830. 		<ul>
    3831. 

  3831. 			
    3832. 

  3832. 			<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>
    3833. 

  3833. 			
    3834. 

  3834. 		</ul>
    3835. 

  3835. 	</div>
    3836. 

  3836. 	
    3837. 

  3837. 	
    3838. 

  3838. 	
    3839. 

  3839. 	<div class="method-subsection declared-in-section">
    3840. 

  3840. 		<h4 class="method-subtitle">Declared In</h4>
    3841. 

  3841. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    3842. 

  3842. 	</div>				
    3843. 

  3843. 	
    3844. 

  3844. 	
    3845. 

  3845. </div>
    3846. 

  3846. 						
    3847. 

  3847. 						<div class="section-method">
    3848. 

  3848. 	<a name="//api/name/setShouldCacheStatements:" title="setShouldCacheStatements:"></a>
    3849. 

  3849. 	<h3 class="subsubtitle method-title">setShouldCacheStatements:</h3>
    3850. 

  3850. 	
    3851. 

  3851. 	
    3852. 

  3852. 	
    3853. 

  3853. 	<div class="method-subsection brief-description">
    3854. 

  3854. 		<p>Set whether should cache statements or not</p>
    3855. 

  3855. 	</div>		
    3856. 

  3856. 	
    3857. 

  3857.     
    3858. 

  3858. 

  3859. 	<div class="method-subsection method-declaration"><code>- (void)setShouldCacheStatements:(BOOL)<em>value</em></code></div>
    3860. 

  3860. 

  3861.     
    3862. 

  3862. 	
    3863. 

  3863. 	<div class="method-subsection arguments-section parameters">
    3864. 

  3864. 		<h4 class="method-subtitle parameter-title">Parameters</h4>
    3865. 

  3865. 		
    3866. 

  3866. 		<dl class="argument-def parameter-def">
    3867. 

  3867. 			<dt><em>value</em></dt>
    3868. 

  3868. 			<dd><p><code>YES</code> if should cache statements; <code>NO</code> if not.</p></dd>
    3869. 

  3869. 		</dl>
    3870. 

  3870. 		
    3871. 

  3871. 	</div>
    3872. 

  3872. 	
    3873. 

  3873. 	
    3874. 

  3874. 	
    3875. 

  3875. 	
    3876. 

  3876. 	
    3877. 

  3877. 	
    3878. 

  3878. 	
    3879. 

  3879. 	
    3880. 

  3880. 	
    3881. 

  3881. 	
    3882. 

  3882. 	
    3883. 

  3883. 	
    3884. 

  3884. 	
    3885. 

  3885. 	<div class="method-subsection declared-in-section">
    3886. 

  3886. 		<h4 class="method-subtitle">Declared In</h4>
    3887. 

  3887. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    3888. 

  3888. 	</div>				
    3889. 

  3889. 	
    3890. 

  3890. 	
    3891. 

  3891. </div>
    3892. 

  3892. 						
    3893. 

  3893. 						<div class="section-method">
    3894. 

  3894. 	<a name="//api/name/shouldCacheStatements" title="shouldCacheStatements"></a>
    3895. 

  3895. 	<h3 class="subsubtitle method-title">shouldCacheStatements</h3>
    3896. 

  3896. 	
    3897. 

  3897. 	
    3898. 

  3898. 	
    3899. 

  3899. 	<div class="method-subsection brief-description">
    3900. 

  3900. 		<p>Return whether should cache statements or not</p>
    3901. 

  3901. 	</div>		
    3902. 

  3902. 	
    3903. 

  3903.     
    3904. 

  3904. 

  3905. 	<div class="method-subsection method-declaration"><code>- (BOOL)shouldCacheStatements</code></div>
    3906. 

  3906. 

  3907.     
    3908. 

  3908. 	
    3909. 

  3909. 	
    3910. 

  3910. 	
    3911. 

  3911. 	<div class="method-subsection return">
    3912. 

  3912. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    3913. 

  3913. 		<p><code>YES</code> if should cache statements; <code>NO</code> if not.</p>
    3914. 

  3914. 	</div>
    3915. 

  3915. 	
    3916. 

  3916. 	
    3917. 

  3917. 	
    3918. 

  3918. 	
    3919. 

  3919. 	
    3920. 

  3920. 	
    3921. 

  3921. 	
    3922. 

  3922. 	
    3923. 

  3923. 	
    3924. 

  3924. 	
    3925. 

  3925. 	
    3926. 

  3926. 	<div class="method-subsection declared-in-section">
    3927. 

  3927. 		<h4 class="method-subtitle">Declared In</h4>
    3928. 

  3928. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    3929. 

  3929. 	</div>				
    3930. 

  3930. 	
    3931. 

  3931. 	
    3932. 

  3932. </div>
    3933. 

  3933. 						
    3934. 

  3934. 						<div class="section-method">
    3935. 

  3935. 	<a name="//api/name/sqliteHandle" title="sqliteHandle"></a>
    3936. 

  3936. 	<h3 class="subsubtitle method-title">sqliteHandle</h3>
    3937. 

  3937. 	
    3938. 

  3938. 	
    3939. 

  3939. 	
    3940. 

  3940. 	<div class="method-subsection brief-description">
    3941. 

  3941. 		<p>The underlying SQLite handle</p>
    3942. 

  3942. 	</div>		
    3943. 

  3943. 	
    3944. 

  3944.     
    3945. 

  3945. 

  3946. 	<div class="method-subsection method-declaration"><code>- (sqlite3 *)sqliteHandle</code></div>
    3947. 

  3947. 

  3948.     
    3949. 

  3949. 	
    3950. 

  3950. 	
    3951. 

  3951. 	
    3952. 

  3952. 	<div class="method-subsection return">
    3953. 

  3953. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    3954. 

  3954. 		<p>The <code>sqlite3</code> pointer.</p>
    3955. 

  3955. 	</div>
    3956. 

  3956. 	
    3957. 

  3957. 	
    3958. 

  3958. 	
    3959. 

  3959. 	
    3960. 

  3960. 	
    3961. 

  3961. 	
    3962. 

  3962. 	
    3963. 

  3963. 	
    3964. 

  3964. 	
    3965. 

  3965. 	
    3966. 

  3966. 	
    3967. 

  3967. 	<div class="method-subsection declared-in-section">
    3968. 

  3968. 		<h4 class="method-subtitle">Declared In</h4>
    3969. 

  3969. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    3970. 

  3970. 	</div>				
    3971. 

  3971. 	
    3972. 

  3972. 	
    3973. 

  3973. </div>
    3974. 

  3974. 						
    3975. 

  3975. 						<div class="section-method">
    3976. 

  3976. 	<a name="//api/name/startSavePointWithName:error:" title="startSavePointWithName:error:"></a>
    3977. 

  3977. 	<h3 class="subsubtitle method-title">startSavePointWithName:error:</h3>
    3978. 

  3978. 	
    3979. 

  3979. 	
    3980. 

  3980. 	
    3981. 

  3981. 	<div class="method-subsection brief-description">
    3982. 

  3982. 		<p>Start save point</p>
    3983. 

  3983. 	</div>		
    3984. 

  3984. 	
    3985. 

  3985.     
    3986. 

  3986. 

  3987. 	<div class="method-subsection method-declaration"><code>- (BOOL)startSavePointWithName:(NSString *)<em>name</em> error:(NSError **)<em>outErr</em></code></div>
    3988. 

  3988. 

  3989.     
    3990. 

  3990. 	
    3991. 

  3991. 	<div class="method-subsection arguments-section parameters">
    3992. 

  3992. 		<h4 class="method-subtitle parameter-title">Parameters</h4>
    3993. 

  3993. 		
    3994. 

  3994. 		<dl class="argument-def parameter-def">
    3995. 

  3995. 			<dt><em>name</em></dt>
    3996. 

  3996. 			<dd><p>Name of save point.</p></dd>
    3997. 

  3997. 		</dl>
    3998. 

  3998. 		
    3999. 

  3999. 		<dl class="argument-def parameter-def">
    4000. 

  4000. 			<dt><em>outErr</em></dt>
    4001. 

  4001. 			<dd><p>A <code>NSError</code> object to receive any error object (if any).</p></dd>
    4002. 

  4002. 		</dl>
    4003. 

  4003. 		
    4004. 

  4004. 	</div>
    4005. 

  4005. 	
    4006. 

  4006. 	
    4007. 

  4007. 	
    4008. 

  4008. 	<div class="method-subsection return">
    4009. 

  4009. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    4010. 

  4010. 		<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>
    4011. 

  4011. 	</div>
    4012. 

  4012. 	
    4013. 

  4013. 	
    4014. 

  4014. 	
    4015. 

  4015. 	
    4016. 

  4016. 	
    4017. 

  4017. 	
    4018. 

  4018. 	
    4019. 

  4019. 	
    4020. 

  4020. 	
    4021. 

  4021. 	<div class="method-subsection see-also-section">
    4022. 

  4022. 		<h4 class="method-subtitle">See Also</h4>
    4023. 

  4023. 		<ul>
    4024. 

  4024. 			
    4025. 

  4025. 			<li><code><p><a href="#//api/name/releaseSavePointWithName:error:">- releaseSavePointWithName:error:</a></p></code></li>
    4026. 

  4026. 			
    4027. 

  4027. 			<li><code><p><a href="#//api/name/rollbackToSavePointWithName:error:">- rollbackToSavePointWithName:error:</a></p></code></li>
    4028. 

  4028. 			
    4029. 

  4029. 		</ul>
    4030. 

  4030. 	</div>
    4031. 

  4031. 	
    4032. 

  4032. 	
    4033. 

  4033. 	
    4034. 

  4034. 	<div class="method-subsection declared-in-section">
    4035. 

  4035. 		<h4 class="method-subtitle">Declared In</h4>
    4036. 

  4036. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    4037. 

  4037. 	</div>				
    4038. 

  4038. 	
    4039. 

  4039. 	
    4040. 

  4040. </div>
    4041. 

  4041. 						
    4042. 

  4042. 						<div class="section-method">
    4043. 

  4043. 	<a name="//api/name/stringFromDate:" title="stringFromDate:"></a>
    4044. 

  4044. 	<h3 class="subsubtitle method-title">stringFromDate:</h3>
    4045. 

  4045. 	
    4046. 

  4046. 	
    4047. 

  4047. 	
    4048. 

  4048. 	<div class="method-subsection brief-description">
    4049. 

  4049. 		<p>Convert the supplied NSDate to NSString, using the current database formatter.</p>
    4050. 

  4050. 	</div>		
    4051. 

  4051. 	
    4052. 

  4052.     
    4053. 

  4053. 

  4054. 	<div class="method-subsection method-declaration"><code>- (NSString *)stringFromDate:(NSDate *)<em>date</em></code></div>
    4055. 

  4055. 

  4056.     
    4057. 

  4057. 	
    4058. 

  4058. 	<div class="method-subsection arguments-section parameters">
    4059. 

  4059. 		<h4 class="method-subtitle parameter-title">Parameters</h4>
    4060. 

  4060. 		
    4061. 

  4061. 		<dl class="argument-def parameter-def">
    4062. 

  4062. 			<dt><em>date</em></dt>
    4063. 

  4063. 			<dd><p><code>NSDate</code> of date to convert to <code>NSString</code>.</p></dd>
    4064. 

  4064. 		</dl>
    4065. 

  4065. 		
    4066. 

  4066. 	</div>
    4067. 

  4067. 	
    4068. 

  4068. 	
    4069. 

  4069. 	
    4070. 

  4070. 	<div class="method-subsection return">
    4071. 

  4071. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    4072. 

  4072. 		<p><code>nil</code> if no formatter is set.</p>
    4073. 

  4073. 	</div>
    4074. 

  4074. 	
    4075. 

  4075. 	
    4076. 

  4076. 	
    4077. 

  4077. 	
    4078. 

  4078. 	
    4079. 

  4079. 	
    4080. 

  4080. 	
    4081. 

  4081. 	
    4082. 

  4082. 	
    4083. 

  4083. 	<div class="method-subsection see-also-section">
    4084. 

  4084. 		<h4 class="method-subtitle">See Also</h4>
    4085. 

  4085. 		<ul>
    4086. 

  4086. 			
    4087. 

  4087. 			<li><code><p><a href="#//api/name/hasDateFormatter">- hasDateFormatter</a></p></code></li>
    4088. 

  4088. 			
    4089. 

  4089. 			<li><code><p><a href="#//api/name/setDateFormat:">- setDateFormat:</a></p></code></li>
    4090. 

  4090. 			
    4091. 

  4091. 			<li><code><p><a href="#//api/name/dateFromString:">- dateFromString:</a></p></code></li>
    4092. 

  4092. 			
    4093. 

  4093. 			<li><code><p><a href="#//api/name/stringFromDate:">- stringFromDate:</a></p></code></li>
    4094. 

  4094. 			
    4095. 

  4095. 			<li><code><p><a href="#//api/name/storeableDateFormat:">+ storeableDateFormat:</a></p></code></li>
    4096. 

  4096. 			
    4097. 

  4097. 		</ul>
    4098. 

  4098. 	</div>
    4099. 

  4099. 	
    4100. 

  4100. 	
    4101. 

  4101. 	
    4102. 

  4102. 	<div class="method-subsection declared-in-section">
    4103. 

  4103. 		<h4 class="method-subtitle">Declared In</h4>
    4104. 

  4104. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    4105. 

  4105. 	</div>				
    4106. 

  4106. 	
    4107. 

  4107. 	
    4108. 

  4108. </div>
    4109. 

  4109. 						
    4110. 

  4110. 						<div class="section-method">
    4111. 

  4111. 	<a name="//api/name/update:withErrorAndBindings:" title="update:withErrorAndBindings:"></a>
    4112. 

  4112. 	<h3 class="subsubtitle method-title">update:withErrorAndBindings:</h3>
    4113. 

  4113. 	
    4114. 

  4114. 	
    4115. 

  4115. 	
    4116. 

  4116. 	<div class="method-subsection brief-description">
    4117. 

  4117. 		<p>Execute update statement</p>
    4118. 

  4118. 	</div>		
    4119. 

  4119. 	
    4120. 

  4120.     
    4121. 

  4121. 

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

  4123. 

  4124.     
    4125. 

  4125. 	
    4126. 

  4126. 	<div class="method-subsection arguments-section parameters">
    4127. 

  4127. 		<h4 class="method-subtitle parameter-title">Parameters</h4>
    4128. 

  4128. 		
    4129. 

  4129. 		<dl class="argument-def parameter-def">
    4130. 

  4130. 			<dt><em>sql</em></dt>
    4131. 

  4131. 			<dd><p>The SQL to be performed, with optional <code>?</code> placeholders.</p></dd>
    4132. 

  4132. 		</dl>
    4133. 

  4133. 		
    4134. 

  4134. 		<dl class="argument-def parameter-def">
    4135. 

  4135. 			<dt><em>outErr</em></dt>
    4136. 

  4136. 			<dd><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></dd>
    4137. 

  4137. 		</dl>
    4138. 

  4138. 		
    4139. 

  4139. 		<dl class="argument-def parameter-def">
    4140. 

  4140. 			<dt><em>...</em></dt>
    4141. 

  4141. 			<dd><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></dd>
    4142. 

  4142. 		</dl>
    4143. 

  4143. 		
    4144. 

  4144. 	</div>
    4145. 

  4145. 	
    4146. 

  4146. 	
    4147. 

  4147. 	
    4148. 

  4148. 	<div class="method-subsection return">
    4149. 

  4149. 		<h4 class="method-subtitle parameter-title">Return Value</h4>
    4150. 

  4150. 		<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>
    4151. 

  4151. 	</div>
    4152. 

  4152. 	
    4153. 

  4153. 	
    4154. 

  4154. 	
    4155. 

  4155. 	
    4156. 

  4156. 	
    4157. 

  4157. 	<div class="method-subsection discussion-section">
    4158. 

  4158. 		<h4 class="method-subtitle">Discussion</h4>
    4159. 

  4159. 		<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>
    4160. 

  4160. 	</div>
    4161. 

  4161. 	
    4162. 

  4162. 	
    4163. 

  4163. 	
    4164. 

  4164. 	
    4165. 

  4165. 	
    4166. 

  4166. 	<div class="method-subsection see-also-section">
    4167. 

  4167. 		<h4 class="method-subtitle">See Also</h4>
    4168. 

  4168. 		<ul>
    4169. 

  4169. 			
    4170. 

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

  4171. 			
    4172. 

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

  4173. 			
    4174. 

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

  4175. 			
    4176. 

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

  4177. 			
    4178. 

  4178. 		</ul>
    4179. 

  4179. 	</div>
    4180. 

  4180. 	
    4181. 

  4181. 	
    4182. 

  4182. 	
    4183. 

  4183. 	<div class="method-subsection declared-in-section">
    4184. 

  4184. 		<h4 class="method-subtitle">Declared In</h4>
    4185. 

  4185. 		<code class="declared-in-ref">FMDatabase.h</code><br />
    4186. 

  4186. 	</div>				
    4187. 

  4187. 	
    4188. 

  4188. 	
    4189. 

  4189. </div>
    4190. 

  4190. 						
    4191. 

  4191. 					</div>
    4192. 

  4192. 					
    4193. 

  4193. 					
    4194. 

  4194. 				</div>
    4195. 

  4195. 				<div class="main-navigation navigation-bottom">
    4196. 

  4196. 					<ul>
    4197. 

  4197. 	<li><a href="../index.html">Index</a></li>
    4198. 

  4198. 	<li><a href="../hierarchy.html">Hierarchy</a></li>
    4199. 

  4199. </ul>
    4200. 

  4200. 				</div>
    4201. 

  4201. 				<div id="footer">
    4202. 

  4202. 					<hr />
    4203. 

  4203. 					<div class="footer-copyright">
    4204. 

  4204. 						<p><span class="copyright">&copy; 2013 ccgus. All rights reserved. (Last updated: 2013-08-06)</span><br />
    4205. 

  4205. 						
    4206. 

  4206. 						<span class="generator">Generated by <a href="http://appledoc.gentlebytes.com">appledoc 2.1 (build 858)</a>.</span></p>
    4207. 

  4207. 						
    4208. 

  4208. 					</div>
    4209. 

  4209. 				</div>
    4210. 

  4210. 			</div>
    4211. 

  4211. 		</article>
    4212. 

  4212. 		<script type="text/javascript">
    4213. 

  4213. 			function jumpToChange()
    4214. 

  4214. 			{
    4215. 

  4215. 				window.location.hash = this.options[this.selectedIndex].value;
    4216. 

  4216. 			}
    4217. 

  4217. 			
    4218. 

  4218. 			function toggleTOC()
    4219. 

  4219. 			{
    4220. 

  4220. 				var contents = document.getElementById('contents');
    4221. 

  4221. 				var tocContainer = document.getElementById('tocContainer');
    4222. 

  4222. 				
    4223. 

  4223. 				if (this.getAttribute('class') == 'open')
    4224. 

  4224. 				{
    4225. 

  4225. 					this.setAttribute('class', '');
    4226. 

  4226. 					contents.setAttribute('class', '');
    4227. 

  4227. 					tocContainer.setAttribute('class', '');
    4228. 

  4228. 					
    4229. 

  4229. 					window.name = "hideTOC";
    4230. 

  4230. 				}
    4231. 

  4231. 				else
    4232. 

  4232. 				{
    4233. 

  4233. 					this.setAttribute('class', 'open');
    4234. 

  4234. 					contents.setAttribute('class', 'isShowingTOC');
    4235. 

  4235. 					tocContainer.setAttribute('class', 'isShowingTOC');
    4236. 

  4236. 					
    4237. 

  4237. 					window.name = "";
    4238. 

  4238. 				}
    4239. 

  4239. 				return false;
    4240. 

  4240. 			}
    4241. 

  4241. 			
    4242. 

  4242. 			function toggleTOCEntryChildren(e)
    4243. 

  4243. 			{
    4244. 

  4244. 				e.stopPropagation();
    4245. 

  4245. 				var currentClass = this.getAttribute('class');
    4246. 

  4246. 				if (currentClass == 'children') {
    4247. 

  4247. 					this.setAttribute('class', 'children open');
    4248. 

  4248. 				}
    4249. 

  4249. 				else if (currentClass == 'children open') {
    4250. 

  4250. 					this.setAttribute('class', 'children');
    4251. 

  4251. 				}
    4252. 

  4252. 				return false;
    4253. 

  4253. 			}
    4254. 

  4254. 			
    4255. 

  4255. 			function tocEntryClick(e)
    4256. 

  4256. 			{
    4257. 

  4257. 				e.stopPropagation();
    4258. 

  4258. 				return true;
    4259. 

  4259. 			}
    4260. 

  4260. 			
    4261. 

  4261. 			function init()
    4262. 

  4262. 			{
    4263. 

  4263. 				var selectElement = document.getElementById('jumpTo');
    4264. 

  4264. 				selectElement.addEventListener('change', jumpToChange, false);
    4265. 

  4265. 				
    4266. 

  4266. 				var tocButton = document.getElementById('table_of_contents');
    4267. 

  4267. 				tocButton.addEventListener('click', toggleTOC, false);
    4268. 

  4268. 				
    4269. 

  4269. 				var taskTreeItem = document.getElementById('task_treeitem');
    4270. 

  4270. 				if (taskTreeItem.getElementsByTagName('li').length > 0)
    4271. 

  4271. 				{
    4272. 

  4272. 					taskTreeItem.setAttribute('class', 'children');
    4273. 

  4273. 					taskTreeItem.firstChild.setAttribute('class', 'disclosure');
    4274. 

  4274. 				}
    4275. 

  4275. 				
    4276. 

  4276. 				var tocList = document.getElementById('toc');
    4277. 

  4277. 				
    4278. 

  4278. 				var tocEntries = tocList.getElementsByTagName('li');
    4279. 

  4279. 				for (var i = 0; i < tocEntries.length; i++) {
    4280. 

  4280. 					tocEntries[i].addEventListener('click', toggleTOCEntryChildren, false);
    4281. 

  4281. 				}
    4282. 

  4282. 				
    4283. 

  4283. 				var tocLinks = tocList.getElementsByTagName('a');
    4284. 

  4284. 				for (var i = 0; i < tocLinks.length; i++) {
    4285. 

  4285. 					tocLinks[i].addEventListener('click', tocEntryClick, false);
    4286. 

  4286. 				}
    4287. 

  4287. 				
    4288. 

  4288. 				if (window.name == "hideTOC") {
    4289. 

  4289. 					toggleTOC.call(tocButton);
    4290. 

  4290. 				}
    4291. 

  4291. 			}
    4292. 

  4292. 			
    4293. 

  4293. 			window.onload = init;
    4294. 

  4294. 			
    4295. 

  4295. 			// If showing in Xcode, hide the TOC and Header
    4296. 

  4296. 			if (navigator.userAgent.match(/xcode/i)) {
    4297. 

  4297. 				document.getElementById("contents").className = "hideInXcode"
    4298. 

  4298. 				document.getElementById("tocContainer").className = "hideInXcode"
    4299. 

  4299. 				document.getElementById("top_header").className = "hideInXcode"
    4300. 

  4300. 			}
    4301. 

  4301. 			
    4302. 

  4302. 		</script>
    4303. 

  4303. 	</body>
    4304. 

  4304. </html>
    4305.