Clovertech

Access Error DB using script

› Clovertech Forums › Cloverleaf › Access Error DB using script

  • Creator
    Topic
  • August 21, 2026 at 1:00 pm #122629
    RICK L. PRITCHETT
    Participant

      Hi everyone,

      I can access the smat databases without issue. I am now looking to access the error db in the same manner. When running the script, I get back the error “file is not a database”.  Any ideas where I am going wrong?

      Using elog.elogdb as the database and the site name as the key

      if {[catch {sqlite3 db $smat_file -readonly 1} open_err]} {
          echo “Failed to open database: $open_err”
          exit 1
      }
      db eval “PRAGMA KEY=MY_KEY”
      set open_request [db errorcode *$smat_file]
      echo “open_request $open_request”
      set table_name “elog_msgs”
      set header_printed 0
      set query [db eval “SELECT * FROM $table_name LIMIT 5”]
      db close

       

       

       

    • Creator
      Topic
    • You must be logged in to reply to this topic.