Sqlite Prepared Statement

  1. 8 months ago

    Bob G

    12 Sep 2017 Pre-Release Testers, Xojo Pro Minneapolis

    Came across (what I think is) an oddity:

    Setting up a prepared statement. Mistyped one of the column names. The error is not reported until the statement is executed. I would have thought such a problem would be detected at the "prepare". This might simply be the way sqlite works.

    Something to look for when what you expect to be inserted does not get inserted.

    Hope this helps someone.

    -Bob Gordon

  2. Dave S

    12 Sep 2017 San Diego, California USA

    Think of "prepare" as a recipe..... it calls for a cup of sugar... you accidently use a cup of salt....
    but you don't realize it until you bite into the final product (ie. execute)

or Sign Up to reply!