Clovertech

hcitbllookup -> Database Lookup

› Clovertech Forums › Read Only Archives › Cloverleaf › Cloverleaf › hcitbllookup -> Database Lookup

  • Creator
    Topic
  • April 10, 2018 at 1:38 pm #55673
    Jerry Tilsley
    Participant

      All,

      I was looking at using the hcitbllookup in a tcl script against a SQLite database.  Unfortunately it is not behaving as I would expect.  No matter what value I provide for the in, I never get a valid out value, it just uses the default I setup.  Am I not providing the value correctly?

      TCL Snippet:

      Code:

      set computerName [lindex $fields 8]
      echo “>$computerName<" echo ">[hcitbllookup Forms_Printer_Lookup $computerName]<"

      Table config:

      Code:

      #
      dflt_passthrough=0
      dflt=NONE
      dflt_encoded=false
      #
      out_column_name=pagePrinter
      in_column_name=computerName
      dbconnection=forms_printer_lookup
      sqlstatement=SELECT pagePrinter FROM lookup WHERE computerName=

      Database schema:

      Code:

      CREATE TABLE lookup (computerName TEXT, pagePrinter TEXT, labelPrinter TEXT);

    • Creator
      Topic
    Viewing 0 reply threads
    • Author
      Replies
      • April 10, 2018 at 7:57 pm #86118
        Mark Thompson
        Participant

          Try the Tcl dblookup command for database tables.

          - Mark Thompson
          HealthPartners

      • Author
        Replies
      Viewing 0 reply threads
      • The forum ‘Cloverleaf’ is closed to new topics and replies.