Announcement

Collapse
No announcement yet.

SQLite Journey

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • #21
    Chris,

    Just tested results (without using :inmemory: database) with and without binding and works perfectly.




    https://duckduckgo.com instead of google

    Comment


    • #22
      Originally posted by Chris Holbrook View Post
      I made an improved version of my code above and posted it to the Source Code Forum here: https://forum.powerbasic.com/forum/u...ts-and-binding
      I created a new thread for discussion of your code for ease of future searching.

      Comment


      • #23
        Originally posted by Stuart McLachlan View Post

        I created a new thread for discussion of your code for ease of future searching.
        Thanks Stuart! Can't see it , give us a clue?

        Comment


        • #24
          OK, got it

          https://forum.powerbasic.com/forum/u...in-source-code

          Comment


          • #25
            Another nice thing is Chris added Explain code (which can be removed.)
            If a common routine for display and error trapping is used and the explain is removed, it reduces to a few lines of code.
            https://duckduckgo.com instead of google

            Comment


            • #26
              Originally posted by Mike Doty View Post
              Chris,
              Just tested results (without using :inmemory: database) with and without binding and works perfectly.


              Comment


              • #27
                Hardly a challenge:

                sSQL = "SELECT ID, lastname FROM mxembers WHERE lastname not like ?"
                Stuart,
                This is about preparing and executing the statement, returning the recordset and showing what and where if an error occurs.

                Thanks again to Chris Holbrook
                https://forum.powerbasic.com/forum/u...ts-and-binding
                https://duckduckgo.com instead of google

                Comment

                Working...
                X