hcitbllookup -> Database Lookup

[Jerry Tilsley]

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);

Topic

[Mark Thompson]

Try the Tcl dblookup command for database tables.

- Mark Thompson
HealthPartners

[Author]

Replies