Have Geek Brain

Why does sqlite3_bind seem to be LOOP?

I am using multiple sqlite3_bind routines (in the iPhone SDK) as shown below to do one update (INSERT or UPDATE) on a table:

        sqlite3_bind_text(update_statement, 1, aString, -1, SQLITE_TRANSIENT);
        sqlite3_bind_int(update_statement, 2, anInteger);
        sqlite3_bind_int(update_statement, 3, pk);

However, after checking the updated table, I see unexpected results. I have followed the progress using "step by step" in the Xcode Debugger and it looks like this bunch of three sqlite3_bind routines are looping to do MORE ONCE , and I get multiple attachments or updates when there should only be one. This routine hasn't come in for a while or whatever, so I'm puzzled.

Hope someone familiar with sqlite3 in iPhone SDK can help.

0


a source to share


1 answer


Oops .... It might help if the method containing sqlite3_bind was not redundantly called by another function elsewhere at the same time LOL. I created a separate function call using sqlite3_bind procedures and completely forgot to delete the original call. Invalid error, resolved: sqlite3_bind is not LOOP.



0


a source






More articles:


All Articles