Unable To Prepare Statement - code review.

Databases
22

Weird - I removed the comma (which I had already tried) and now it works :slight_smile:

Oh well - problem solved.
The code below now works, if anyone else is having a similar problem:

Dim ps As SQLitePreparedStatement = NotesDB.Prepare("UPDATE Notes SET NoteName=? WHERE NoteName=?") ps.BindType(0, SQLitePreparedStatement.SQLITE_TEXT) ps.BindType(1, SQLitePreparedStatement.SQLITE_TEXT) ps.Bind(1, NoteSelected) ps.SQLExecute

Thank you all for your help - it was much appreciated :slight_smile:

23

That’s the beauty of this forum … it was Patrick Delaney who straightened me out last week on that problem with the extra comma (and yes, I had pulled a few hairs out wondering what in hell’s bells was going on also ^^) … so, I’m throwing him a “shout out” here for both of us!