¡@

Home 

2014/10/15 ¤U¤È 10:03:30

iphone Programming Glossary: addstatement

To reterive BLOB image from sqlite

http://stackoverflow.com/questions/10192945/to-reterive-blob-image-from-sqlite

propertyString animalidString breedString mainBreedString dateString sexString notesString imageData sqlite3_stmt addStatement NSLog @ @ appDelegate.sqlFile const char insert_stmt insertSQL UTF8String if sqlite3_open appDelegate.sqlFile UTF8String.. UTF8String if sqlite3_open appDelegate.sqlFile UTF8String database SQLITE_OK sqlite3_prepare_v2 database insert_stmt 1 addStatement NULL if sqlite3_step addStatement SQLITE_DONE sqlite3_bind_blob addStatement 1 imageData bytes imageData length SQLITE_TRANSIENT.. UTF8String database SQLITE_OK sqlite3_prepare_v2 database insert_stmt 1 addStatement NULL if sqlite3_step addStatement SQLITE_DONE sqlite3_bind_blob addStatement 1 imageData bytes imageData length SQLITE_TRANSIENT NSLog @ Data saved else..